[RESOLVED] Why will update never work for me?

[m37h0d]

Hello guys,
Why will edit never work for me? I have the following code but it always returns an error similar to this:
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 'UDPATE sitebans SET url='eee', reason='This isnt a weight loss website..', by=' at line 1

here is my code:

	$new_url = $_POST['new_url'];
	$new_reason = $_POST['new_reason'];
	$new_by = $_POST['new_by'];

$updateQuery = "UDPATE sitebans SET url='$new_url', reason='$new_reason', `by`='$new_by' WHERE id='$id'";
mysql_query($updateQuery) or die(mysql_error());
echo '<div align="center" class="style2">Changes saved!  You may close this window..</div>';

I know by is a reserved word by I used `` so it should work.. I can never use update... please help 🙁

[bpat1434]

I see something:
1.) You don't specify which item to update. There's no WHERE clause.
2.) Without the where, you seem to be inserting, not updating. Inserting is a slightly different syntax.

Are you trying to insert? If not, then specify a where clause. It's not the answer to your problems, but it's a step toward getting the record updated. Right now, your query updates every row with the new information. That's a big UhOh!!

As far as your issue, I'm not sure. It should work. I can only think that the value of $new_name is causing an issue with mySQL and thus would need looking at (or escaping).

[m37h0d]

I spelt update wrong, thread resolved :9

[bpat1434]

lol :p

You "spelt" spelled wrong too... lol...