insert into help

[cfgcjm]

I'm looking to create a sql statement in php that says Insert into the table 'users' column 'client' value $client where column 'username'=$username

 

I've got this:

 

mysql_query("INSERT INTO users (client) VALUES ('$client')");

 

 

but i'm not quite sure how to do the where part

[aebstract]

MYSQL_QUERY("INSERT INTO users (client) WHERE username=$username".
"VALUES ('$client')") or die (mysql_error());

 

Should work

[cfgcjm]

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 username=Thenapster87VALUES ('1')' at line 1

 

<?php
require ('mysql.php');
if ($_POST['submit']='submit') { 
$username = $_POST['un'];
$client = $_POST['Yes'];
mysql_query("INSERT INTO users (client) WHERE username=$username"."VALUES ('$client')") or die (mysql_error());
}
?>

[revraz]

WHERE goes After the VALUE not before

[revraz]

Actually, it sounds like you want to UPDATE and not INSERT if the record already exists.

[cfgcjm]

Thats correct

 

i changed it to this:

	mysql_query("UPDATE users SET client = $client WHERE username = $username") or die (mysql_error());

 

but i'm getting this:Unknown column 'Thenapster87' in 'where clause'

 

Thenapster87 is the value of $username but it's confusing it with the column name which is username...?

[revraz]

Put single quotes around $client and $username

[cfgcjm]

thats it...thanks