
May 8th, 2000, 10:40 AM
|
|
Junior Member
|
|
Join Date: May 2000
Posts: 15
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
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");
mysql_close();
|