NameSilo

What's wrong with these PHP?

SpaceshipSpaceship
SpaceshipSpaceship
SpaceshipSpaceship
Watch

Barrucadu

Established Member
Impact
64
heres the code:

PHP:
$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:

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.
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
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"
 
0
Close
thanks
 
0
Close
DomainEasy: white label portfolios are live. Enable yours.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Filters for activity feeds
Your news feed, Latest activity, and the activity tab on profiles now have filter buttons: All, Posts, Quick replies, and Other. Your...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back