UPDATE command. what am i doing wrong

[AxisC]

Hi ppl.

I have captured some simple information from a form and want to use this to update a given article in a table in my datbase, the code i have is as follows :

  

$query = "UPDATE maincontent SET MAINIMAGE='$Tmainimage', IMGTYPE='$Timagetype', SUBIMAGE='$Tsubimage' 
WHERE ARTICLE='$article'";
$update = mysql_query($query); 

The page definitley gets the information as i can echo it all onto the screen correctly in testing so i am really unsure why it doesnt work. Is there any command i am not using correctly or need to add?? I have had great success so far connecting, selecting and inserting data, and am using exactly the same connection script, so i am really lost for a solution.

any ideas? (i bet its embarassingly simple isnt it?? 🙂 )

[Shrike]

I can't see anything wrong with the above code, assuming that all table names/columns and variables are named correctly, and that register_globals is enabled.

What does mysql_error() say?

[AxisC]

Thanks for you reply 🙂 i have got it working now anyway, i knew it was something simple, and it was.... always the way eh??

🙂