Whats wrong with theis PHP?

Barrucadu · 09-02-2005, 02:06 AM

heres the code:

PHP Code:

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

????: NamePros.com http://www.namepros.com/programming/120404-whats-wrong-with-theis-php.html
$result=mysql_query($query) or die("Could not execute the query:".mysql_error());

it returns the error:

Code:

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 · 09-02-2005, 02:19 AM

try for your query instead:

Code:

 $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 · 09-02-2005, 02:38 AM

thanks

09-02-2005, 02:06 AM	THREAD STARTER #1 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Whats wrong with theis PHP? heres the code: PHP Code: `$query='update myfile_visitors set field02=\''.$browser.'\' where field01=\''.$_GET['field01'].'\', field03=\''.$_GET['field03'].'\''; ????: NamePros.com http://www.namepros.com/programming/120404-whats-wrong-with-theis-php.html $result=mysql_query($query) or die("Could not execute the query:".mysql_error());` it returns the error: Code: 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. __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

09-02-2005, 02:19 AM	#2 (permalink)
RJ NamePros Admin Join Date: Feb 2003 Posts: 12,919 Follow @DomainBuyer	try for your query instead: Code: $query='update myfile_visitors set field02=\''.$browser.'\' where field01=\''.$_GET['field01'].'\' and field03=\''.$_GET['field03'].'\''; I just replaced your command with the word "and" __________________ Reach me at rj at namepros dot com

09-02-2005, 02:38 AM	THREAD STARTER #3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	thanks __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: Getting started with PHP (The Basics)	deadserious	Webmaster Tutorials	60	11-17-2007 11:35 AM
Googlism - What does google think of you?	deadserious	The Break Room	55	12-15-2005 09:09 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
PHP Editor Software List	Ber\|Art	Free Resources	3	08-22-2004 08:59 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)