[RESOLVED] mysql Update code not working

[richsmith]

hi i am trying to run an update command but it keeps failing

<?php
$updatetext = $HTTP_POST_VARS['welcomeinfo'];

$conn=@mysql_connect("localhost", "ckids_ckids1", "christiankids")
or die("MYSQL Connection Error");

$rs = @mysql_select_db("ckids_wcms1", $conn)
or die("Database Error");



$sql = "UPDATE `hompage` SET `welcome` = '$updatetext' WHERE `id` = 1 LIMIT 1";

mysql_query($sql) 
or die("Error: Update Failed");

echo "Updated";



?>

its keeps showing error update failed
i have tried many things and cant get it to work, i know that $updatetext contains a value as i have echoed this in trying to fix it

[lintz]

Try the below. HTH

$sql = "UPDATE hompage SET welcome = '$updatetext' WHERE id = 1 LIMIT 1"; 

[visualAd]

Back ticks ` should only be used for table names. Not field names.

[visualAd]

You can also display the error from mysql by using the mysql_error()

[richsmith]

nope still doesnt work

[visualAd]

What is the error mysql is giving you?

[richsmith]

the mysql_error() wouldnt work, but have fixed it now, it was a spelling error in the table, thanks everyone

[lintz]

If the table name was incorrect then mysql_error() should have told you that

[richsmith]

yes i know it should have, and i set it up like it showed, but for some reason it didnt like it, might try it again one day when my code goes wrong