MysQL Update query problem - inserts instead of update

[SanSui]

$result=MYSQL_QUERY("UPDATE rec set n_date='$tf_date', n_title='$tf_title', n_new='$c_new', n_urgent='$c_urgent', n_text = '$new_ta', n_author='$tf_author', n_archive='0' WHERE n_id='$id'") or die(mysql_error()) ;

Here's my query. n_id is the primary key (autoincrement), and there is also a timestamp field. When I run this I get a whole new row instead of updating the existing row - why???

My other update queries for other tables works fine, so this is totally baffling me. I've struggled with this for over a day now, so I'm about to lose my wits over something that should be incredibly simple :eek:

[nemonoman]

Are you sure that $id isn't null? this could conceivably create the situation. Try echoing the query with the values filled in:

echo "UPDATE rec set n_date='$tf_date', n_title='$tf_title', n_new='$c_new', n_urgent='$c_urgent', n_text = '$new_ta', n_author='$tf_author', n_archive='0' WHERE n_id='$id'";

[SanSui]

I found my problem.... the form action was pointing to the INSERT file version of the same code rather than the UPDATE version. So... the output was identical, just the wrong query being invoked.

Yay for stupidity ;*(

What's really sad is I looked over the form action names already to make sure they were correct, yet didn't catch it, so I had already ruled it out of my troubleshooting 🙁