MySQL Forums
Forum List  »  PHP

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
Posted by: J M
Date: November 21, 2007 04:54AM

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in
/clientdata/clients/t/h/thebandits.com.au/www/index.php on line 418


The section in index.php around line 418 is

<?php

while($querystrrow=mysql_fetch_assoc($querystrrs))
{list($gyear,$gmonth,$gday)=split("-",$querystrrow['gig_date']);
echo date("jS D", mktime(0, 0, 0,$gmonth, $gday, $gyear)).' '.$querystrrow['gig_venue']."<br />";

?>

I put the error in mysql and got

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'while(querystrrow=mysql_fetch_assoc(querystrrs))
{list(gyear,gmonth,gday)=split' at line 1


Any help would be great!

Options: ReplyQuote


Subject
Written By
Posted
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
J M
November 21, 2007 04:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.