INSERT little problem

[nomad9]

hi ...

// Collect Session Var
$clientRef = session_register("clientRef");

// Collecting Form Var
$cieDef = $_POST['cieDef'];

// Input Info Into DB
$sql = "INSERT INTO f".$clientRef." (formQuestion) VALUES('".$cieDef."') WHERE formName LIKE 'cieName'";
$result = mysql_query($sql,$db) or die(mysql_error());

and it gave me this error message :

You have an error in your SQL syntax near 'WHERE formName LIKE 'cieName'' at line 1

don't understand .... need help

Steve

[nnichols]

There shouldn't be a WHERE clause in an INSERT query of this sort. You'd better give a better explanation of what you are trying to do.

[cgraz]

Like nnichols stated, WHERE clauses don't belong in INSERT statements. If you need to have a where clause in there, then you're most likely updating the table and should look into the UPDATE command.

[nomad9]

thank guy .... it help me alot