Using a HTML form/PHP to update MySQL database. PHP parses fine, but the databas

[Kolusion]

I am using a HTML forum with PHP to update a MySQL database. I have tried this PHP code:

[php]$query = “UPDATE products set category = '”.$_POST[‘category’]."’ where id = ‘".$_POST[‘id’]."’";[/php]

PHP parses the code, but it has no effect on my database which leads me to suspect a MySQL syntax problem, OR, I’ve implimented PHP wrong inside my MySQL query.

Can anyone see a problem with my code that I’ve missed?

[Kolusion]

Here is the MySQL database:

[Kolusion]

On a note regarding the MySQL table image: ID’s will be unique, they are only not unique because the table currently serves as a testing ground.

[lamp]

i suggest you echo the sql query see if there exist any wrong if you still can find it, i will very pleased to help you just email me