mofm Posted April 17, 2008 Share Posted April 17, 2008 im making a website and i want the websit to track its users ie what page they are on how many are online etc etc and iv done most of this code it just that a qurey is being a pain in my arse can i get some help please ? this is my mysql query: UPADTE usersonline SET member='y' refurl='http://localhost/25%20march%2008/' userid='1' currentpage='/25 march 08/test.php' activity = now() WHERE ipaddress ='127.0.0.1' this is the error that i recive from PHP myadmin Error SQL query: UPADTE usersonline SET member = 'y'refurl = 'http://localhost/25%20march%2008/'userid = '1'currentpage = '/25 march 08/test.php'activity = now( ) WHERE ipaddress = '127.0.0.1' MySQL said: Documentation #1064 - 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 'UPADTE usersonline SET member='y' refurl='http://localhost/25%20march%2008/' use' at line 1 I thank you for reading and i hope you can come up with a soloution to this tahnks MOFM Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted April 17, 2008 Share Posted April 17, 2008 You need a comma between each field you would like to update. You also appear to have a typo. It should be UPDATE and not UPADTE. Quote Link to comment Share on other sites More sharing options...
mofm Posted April 17, 2008 Author Share Posted April 17, 2008 Ginger robot !!! i want to marry you byut seriously thanks ...its always the most simplist things that get me stumped it was stuck on thsi for nearly a hour !! i feel so stupid but thanks alot for your help its working as intended now lots of love MofM Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.