August 19th, 2004, 03:13 PM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 14
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Update Query Error
Hello
How's every one once again i give u invitaion to check this i am just kidding please help me i have that error in update query .....
Error : You have an error in your SQL syntax near 'from guest name= 'asdf', email='aasdf', url= 'asdf', location= 'asdf', comments=' at line 1
PHP Code:
<?PHP
include "connection.php";
session_start();
$id = $_REQUEST['id'];
$name1 = $_POST['name'];
$email1 = $_POST['email'];
$url1 = $_POST['url'];
$loc1 = $_POST['location'];
$com1 = $_POST['comments'];
$sql = "update guest name= '$name1', email='$email1', url= '$url1', location= '$loc1', comments='$com1' where id = $id ";
$query = mysql_query($sql,$db)or die("Error : ".mysql_error());
header("Location: admin.php?user_name=${_REQUEST['user_name']}")
?>
Please look this.. what is the error...
Bye C U...soon
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
