What's wrong with these PHP?

[Barrucadu]

heres the code:

$query='update myfile_visitors set field02=\''.$browser.'\' where field01=\''.$_GET['field01'].'\', field03=\''.$_GET['field03'].'\'';
$result=mysql_query($query) or die("Could not execute the query:".mysql_error());

it returns the error:

Could not execute the query: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 ' field03=' - - none - -'' at line 1

But, I cant fgure out whats wrong with it..

what its trying to do is change field02 to broswer wherever field01 = their ip and field03 = their referer.

 

[RJ]

try for your query instead:

 $query='update myfile_visitors set field02=\''.$browser.'\' where field01=\''.$_GET['field01'].'\' and field03=\''.$_GET['field03'].'\'';

I just replaced your command with the word "and"

 

[Barrucadu]

thanks