[RESOLVED] Using Insert Into Where

[bosco500]

Can't get this code to work, am I doing something wrong? From the sql manual it looks right. It seems to get caught up only when I include the last part with the userid and password (The WHERE statement)

$sql = "INSERT INTO client SET
              compname = '$_POST[compname]',
              web = '$_POST[web]',
              email = '$_POST[email]',
	      cat = '$_POST[cat]',
              recip = '$_POST[recip]',
		description = '$_POST[description]',
		state = '$_POST[state]',
		city = '$_POST[city]' WHERE userid = '$_SESSION[userid]' AND 
                 password = '$_SESSION[password]'";

Thanks for any help.

[bradgrafelman]

INSERT queries can't have 'WHERE' clauses (assuming they don't have a SELECT sub-query)... and for good reason: it makes no sense to have a WHERE clause on an INSERT query.

[Piranha]

You probably want to update the row, not creating a new one. If that is the case you should use update instead:

UPDATE table SET name = $name WHERE id = $id

[bosco500]

Piranha wrote:

You probably want to update the row, not creating a new one. If that is the case you should use update instead:

UPDATE table SET name = $name WHERE id = $id

Thank you, Exactly what I was trying to do.