Re: What is going on?!? PHP-MySQL query weirness

"alter table Table1 primary key (field1,field2,...)" . HTH Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Noah Spitzer-Williams <noahsw@cyberdude.com> Para: <php-db@lists.php.net> Enviada em: domingo, 26 de novembro de 2000 17:56 Assunto: Re: [PHP-DB] What is going on?!? PHP-MySQL query weirness > yeah i woudl check that, i know you cant add a column called "desc" > > -- > > ----------------- > The DevBoard - http://www.thedevboard.com > ----------------- > http://www.alladvantage.com/go.asp?refid=BIY971 - AllAdvantage > "Doug Semig" <dougslist@semig.com> wrote in message > news:3.0.6.32.20001122141957.007e9380@sloth.c3net.net... > > I'm not saying this is the problem, but "date" is an SQL reserved word. > > You might want to rename that column. > > > > Doug > > > > At 10:41 AM 11/22/00 -0600, John Guynn wrote: > > >I have the following code: $result = mysql_query("SELECT Date FROM > $dbname > > >ORDER BY Date"); ($dbname is set to neon) > > > $row = mysql_fetch_array($result); > > > > > >Pretty standard stuff right. > > > > > >When the code executes $row has 2 values in the array. The problem is > when > > >I go to the mysql command line and execute SELECT Date FROM neon ORDER BY > > >Date; I get 49 rows in set as a result which is what I expect. > > > > > >I've never had the PHP code return less than the correct number of items. > > >Also the values in $row are 1995-09-26 (the first date) and BLANK > (nothing > > >echos to the screen in $row[1]). > > > > > >Any ideas? > > > > > >John Guynn > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >