Could somebody please help me with this problem. I want to create an admin page so people can edit data in a MySQL database. I have read all the tutorials i can find but none of them go into using the UPDATE function. I have tried using the coding below and although i receive no parse errors the database is not being updated. Am I using the incorrect syntax?
mysql_connect($DBHost,$DBUserName,$DBPassword) or die("server");
@mysql_select_db("xxxxxxx") or die("db");
$result = mysql_query("update news_stories set type="$type" body="$body" email="$email" uname="$uname" headline="$headline" where id=$id");