quickie mysql query help

[Lodius2000]

what i want to do is insert values into 2 columns, (title and article) in only one row (id) and the row already exists and id is derived from $_GET so I should shield it using a ?

 

can I have a query that says

 

'INSERT INTO tablename (article_title, article) VALUES(?, ?) WHERE article_id = ?', array($title, $article, $id)

 

[ohdang888]

You cannot put an INSERT INTO with a WHERE clause, it doesn't work( and think about it, theres no point)

 

use "UPDATE tablename SET `column`='$var' WHERE `id`='$id'"

 

also, use "or die(mysql_error())" after every query to find the problems

[Lodius2000]

could I use UPDATE if title and article are currently empty?

[Nexy]

UPDATE would be the way to go:

 

$sql = "UPDATE tablename SET article_title = '$title', article = '$article' WHERE article_id = '$id'";

$res = mysql_query($sql) OR die(mysql_error());

 

Replace the text in single quotes to whatever you want, and this will work if they are empty, assuming the row exists. Now show about your array there.

[.josh]

insert is for adding a new row. update is for editing an existing row.