Re: mysql_query

Double check the select buy having php print the variable. For example: $SELECT_TXT = "SELECT * FROM"; print("$SELECT_TXT"); $SELECT_QRY = MYSQL_QUERY($SELECT_TXT); Try that and then manually run the $SELECT_TXT on your mysql server and see if the results are different and let us know. -nc ---------------------------------------------------------------------- .:: Nathan Cook - Network/Security Admin office: 208.343.3110 - Web Programmer email: ncook@pcsedu.com - Qmail Admin pager: 208.387.9983 - MIS Admin ----------------------------------------------------------------------- ----- Original Message ----- From: "Augusto Cesar Castoldi" <castoldi@inf.ufsc.br> To: <php-general@lists.php.net> Sent: Tuesday, January 09, 2001 10:33 AM Subject: [PHP] mysql_query > a few days ago I asked you this: > ____________________ > when I do a mysql_query on php, like > > $result=mysql_query("select * from counter where date='2001-01-06'"); > > In case of there is no date='2001-01-06', what should be the contents of > $result? > > How can I know that was no data of '2001-01-06' in database? > _____________________ > > you answer me like that: > > $hoje=date("'Y-m-d'"); > if (mysql_query("select unique,total from counter where data=$hoje")){ > echo "true"; > }else{ > echo "false"; > } > > At the begining it was working. But now returns always true! I can put > anything, like "... where data='1999-05-05'", that it returns true, but > there is no date='1999-05-05' at database. > > I was thinking that maybe the PHP4 server is not good... > > well, someone know what the solution. > > thanks, > > Augusto Cesar Castoldi > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >