Help with MySQL - Insert and Where Functions

Rictus

I'm a littler bit stuck trying to do this...

I made a table of 4 columns... one for the user name, the other for the password and the two others for the ip and the date... what I'm trying to do is enter the Ip and the date based on the user..... I'm using this:

mysql_query("INSERT INTO login WHERE name='$name' (date, ip) VALUES('$date_time', '$ip')") or die(mysql_error());

but I'm having this error:

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 'WHERE name='example')(date, ip) VALUES('Wednesday May 18, 2005.....

SBro

The WHERE clause goes at the end, your code should look like:

mysql_query("INSERT INTO login (date, ip) VALUES('$date_time', '$ip') WHERE name='$name'") or die(mysql_error());

Rictus

Thanks for reply...

I try this code but it does not resolve the problem... This error message appear:

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 'WHERE nombre='example'' at line 1

if someone have any idea please reply

😕

Rictus

Well... I think I resolve the issue....I use UPDATE function

I use this code:

mysql_query("UPDATE login SET hora='$date_time' WHERE name='$name'") or die(mysql_error());
mysql_query("UPDATE login SET ip='$ip' WHERE nombre='$name'") or die(mysql_error());

Thanks