Re: Single/Double Quotes

This should work ... $result=mysql_query("SELECT book FROM TAB_AUTHORS WHERE aid = '$aid'"); When PHP sees the single quotes around the $aid it evaluates it to the value stored in the variable. Your first example connntained $aid within a set of double quotes, thus it was treated as a literal. Hope this helps - Miles Thompson At 09:08 AM 12/12/2001 -0500, Gerard Samuel wrote:

Im tring to rewrite some code to use single/double quotes correctly (as correct as can be). If I use $result=mysql_query('SELECT book FROM ' . TAB_AUTHORS . " WHERE aid = $aid"); I get an mysql error. That should be correct, if I understand it right. But if I use $result=mysql_query('SELECT book FROM ' . TAB_AUTHORS . " WHERE aid = '$aid'"); it works. So what I need to know is that do I have to ride the fine thin line for correctness and speed??? -- 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