Syntax for update? Errors?

[Skipjackrick]

This is obviously not the correct syntax for update because I keep getting an error.

 

what do I have incorrect?

 

 

<?php
$result = mysql_query("UPDATE submit 

SET 	submit_id=175,
	team_id=17,
	angler='Ay Jay',
	species_id=5,
	points=10,
	length=0,
	yyyy=2008,
	mm=03,
	dd=30,
	image='rick1.jpg',
	region_id=1

WHERE submit_id=175,
	team_id=17,
	angler='Ay Jay',
	species_id=4,
	points=20,
	length=0,
	yyyy=2008,
	mm=03,
	dd=30,
	image='rick1jpg',
	region_id=1") 

or die(mysql_error());  
?>

[BlueSkyIS]

what is the error?

 

WHERE's must be separated with ANDs, not commas

 

WHERE x = '1' AND y = '2', etc.

[Skipjackrick]

what is the error?

 

WHERE's must be separated with ANDs, not commas

 

WHERE x = '1' AND y = '2', etc.

 

 

Ah, yeah, I forgot where's must be separated by AND

 

That fixed it..

 

Thanks!