[RESOLVED] Insert Query Problem

[obrienkev]

Hi all,

Why do I get this error...
"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 'Resource id #3' at line 1"

Here's my code...

while($row = mysql_fetch_array($result))
{
 	 $class = $row['class_ID'];
 	 $query = "INSERT INTO training ".
	 					"VALUES(NULL, '$class', '$ffnumber', NOW())";
	 echo $query;			
}
$result = mysql_query($result) or die(mysql_error());

/****************************
Found Error -
$result = mysql_query($result)
****************************/

Thanks

[Weedpacket]

Sounds like you're trying to stick a resource variable into the query. One of $class or $ffnumber is not what you think it is.