RE: [PHP] SQL Warning
| From: | Martin Towell | Date: | Wed, 24 Apr 2002 03:54:49 +0000 |
| Subject: | RE: [PHP] SQL Warning | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-94301@lists.php.net to get a copy of this message | ||
or make it
$config[prefix]
-----Original Message-----
From: Jason Murray [mailto:Jason.Murray@melbourneit.com.au]
Sent: Wednesday, April 24, 2002 1:51 PM
To: 'Jennifer Downey'; php-general@lists.php.net
Subject: RE: [PHP] SQL Warning
> Would you please direct your attention to this URL
>
> http://testphp.netfirms.com/code1.html
>
> Look at the bottom where the big orange commented syntax is
> and explain what is going on there?
{$config["prefix"]}
I think this should be
${config["prefix"]}
... also, it's handy to actually echo or print the SQL you're
executing, as you will be able to see if the SQL is correct
or not.
The error on line 14 occurs because you're trying to execute
mysql_fetch_array on a mysql result set that doesn't exist.
The most likely reason it doesn't exist is because the SQL is
wrong. Echo the SQL and you'll find out whats happening.
J
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php