Could not update the entry because...

[cturner01]

I am trying to update a media release with this mysql code:

$update = "UDPATE `mediareleases` SET title = '$title', text = '$text', date = '$date' WHERE id = '$id'";

. When I do it displays the following error:
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 `mediareleases` SET title = 'Youth participation the key to strong commun' at line 1. The query was UDPATE `mediareleases` SET title = 'Media release title goes here', text = 'Media release text goes here.
', date = 'Friday, February 22, 2008' WHERE id = '44'. Could it be the date field? The date type is date. I did a select query to display that date with date_format. Can someone please help me get past that error? Thanks in advance.

[Dan Grossman]

Are $title and $text being escaped before put in the query?

[cturner01]

Yes.

[Dan Grossman]

The date field being invalid shouldn't cause the query to fail, just the wrong date to be inserted, so that isn't it. Output the entire actual query that failed. Does it look right to you? Does it run when you execute it against MySQL directly (through the MySQL console or phpMyAdmin)?

Also try putting backticks around `text` and `date`, as they are reserved words you shouldn't be using as column names.

[r937]

i am going to take a wild guess and say that maybe UDPATE is the wrong command keyword

[cturner01]

No update is the right command that I should be using, r937. As I want to edit this media release.

[cturner01]

I have changed some things in my database. However I am still getting the error. My database structure looks like this:
id // the primary key auto-incremented number
title // type: text
body // type: text
date_entered // date

Now it is going one further and having a problem with the body. Anyway here is the error message again in a different row:
Could not update the entry because: 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 `mediareleases` SET title = 'Baradine\'s doctor crisis', body = 'Over eig' at line 1. The query was UDPATE `mediareleases` SET title = 'Baradine\'s doctor crisis', body = 'Over eig...', date_entered = 'Friday, April 4, 2008' WHERE id = '57'. Here is the update thing again:

$update = "UDPATE `mediareleases` SET title = '$title', body = '$body', date_entered = '$date_entered' WHERE id = '$id'";

[r937]

okay, i hinted at it, and nobody saw it, so i will come right out and tell you

you spelled it wrong

it's UPDATE, not UDPATE

[longneck]

i noticed.