0

I want to update a table based on what a user enters. I know I got the username and password correct. But I keep getting an error based on my debugging code. I'm connecting to the database successfully, but it's just not updating. The variables print into the page, so they're not Null. What could be causing my table not to update? If this helps, I'm using Yahoo Web hosting to do this.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Posted</title>
</head>

<body>


<?

	$name = $_REQUEST["name"];
	$date = $_REQUEST["date"];
	$make = $_REQUEST["make"];
	$model = $_REQUEST["model"];
	$year = $_REQUEST["year"];
	$rating = $_REQUEST["rating"];
	$service = $_REQUEST["service"];
	
	$conn = mysql_connect("mysql", "my_name", "my_password");
	$select = mysql_select_db("Posts");
	$sql = "INSERT INTO posts VALUES (NULL, \'$name\', \'$date\', \'$make\', \'$model\', \'$year\', \'$service\', \'$rating\')'";
	
	$result = mysql_query($sql);

        print "Name: " . $name . " Date: " .$date . " Make: " . $make . " Model: " . $model . " Year: " . $year . " Rating: " . $rating . " Service: " . $service . "\n\n\n\n\n\n\n\n\n";

        if($conn){
		print "Connected to database successfully";
	}else{
		print "Error!";
	}
	
	if($result){
		print "Database updated";
	}else{
		print "Error!";
	}
	
?>
</body>
</html>

Edited by SolidSora: n/a

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by dashawk
0

I got the error corrected, but now it's just posting $name, $date, etc. into my database.

Edited by SolidSora: n/a

0

i revised your code and it look like this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Posted</title>
</head>

<body>


<?

	$name = $_REQUEST["name"];
	$date = $_REQUEST["date"];
	$make = $_REQUEST["make"];
	$model = $_REQUEST["model"];
	$year = $_REQUEST["year"];
	$rating = $_REQUEST["rating"];
	$service = $_REQUEST["service"];
	
	$PRIMARYKEY = $_REQUEST["ID"];
	
	
	$conn = mysql_connect("mysql", "my_name", "my_password") or die(mysql_error());
	mysql_select_db("Posts") or die(mysql_error());
	$sql = "UPDATE post 
			SET field1 = ".$name.", field2 = ".$make.", 
			field3 = ".$model.", field4 = ".$year.", 
			field5 = ".$service.", field6 = ".$rating." WHERE fieldID = ".$PRIMARYKEY;
		
	mysql_query($sql) or die(mysql_error());

	echo "Name: ".$name." Date: ".$date." Make: ".$make." Model: ".$model." Year: ".$year." Rating: ".$rating." Service: ".$service."<br /><br />";
	
	echo "Database Updated!";
	
?>
</body>
</html>

this code should work, I tested it in my local server and it work just fine.
Do not use "INSERT" when updating a record, use "UPDATE" instead.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.