PHP & Mysql Error
Posted: Fri Feb 25, 2005 8:12 am
Hi
The following PHP code:
Produces the following warning:
For the following query:
Any ideas?
Many thanks in advance
Mark
The following PHP code:
Code: Select all
$query = $_POSTї'query'];
$result = mysql_query($query);
if(!$result)
{
do_html_message('Error: Could not perform MySQL query - '.mysql_error());
do_html_footer();
exit();
}
$is_highlights = FALSE;
while( $row = mysql_fetch_array( $result ) )Code: Select all
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/XXX/public_html/admin.php on line 108Code: Select all
SELECT * FROM Properties WHERE ConsultancyID=2 ORDER BY PropertyTitle LIMIT 0,30Many thanks in advance
Mark