php and mysql inserting

bakaneko

how do you sepcify what row you want to insert a value for a column? for example say i want to add the name of an item to user = "baka". i thought it would be something like this

insert into table_name (item) values ("neo stick") where user = "baka";

but i get an error...

drag0n

looks about right..

bakaneko

still doesnt work... i get cant query this is my exact line =(

$query = "insert into member (data1) values ('$temp') where login = '$user'";
$result = mysql_query($query) or die ("cant query");

drag0n

do die(mysql_error())
and then post that error 🙂

bakaneko

that is what i get;
o lol woops... i shouldnt use $user as a session var because i use that to login into the database ...

bangs head onto desk *

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 login = 'root'' at line 1

thanks drag0n!

drag0n

yep, always use die(mysql_error) itll tell you the specific problem 🙂

bakaneko

err still same error... hmm

fox_m

Originally posted by bakaneko
still doesnt work... i get cant query this is my exact line =(

$query = "insert into member (data1) values ('$temp') where login = '$user'";
$result = mysql_query($query) or die ("cant query");

I hade a look for an while and then it struck me ....
You cant do an insert with an where clause.
this needs to be an update.
So then the code look like this

$query = "update member set data1 = $temp where login = $user";
$result = mysql_query($query) or die "Cant execute update";

That should do the trick.

Fox_m

drag0n

Doesnt UPDATE only update a column?what is he trying to do?

fox_m

Originally posted by drag0n
Doesnt UPDATE only update a column? if there is no row, does it add one?

Nope .. update does update and insert does inserts ...

you can do an select on the user to determin his excistance in the DB.
And based on that result do an insert or an update.

drag0n

actually now Im confuzed.... what is he wanting to do? inserting with a where?

fox_m

Originally posted by drag0n
actually now Im confuzed.... what is he wanting to do? inserting with a where?

By the look of his snippet yeah i think so

$query = "insert into member (data1) values ('$temp') where login = '$user'";
$result = mysql_query($query) or die ("cant query");

bakaneko

thanks you two. got it to work. kewl kewl! :p