Skip navigation links

MySQL Forums :: PHP :: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL


Advanced Search

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 11/21/2007 04:54AM
Re: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL Diego Medina 11/21/2007 12:21PM
Re: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL J M 11/23/2007 05:14AM
Re: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL Vladimir Nikolic 11/24/2007 04:45AM
Re: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL Diego Medina 11/25/2007 10:54PM


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.