troubleshooting Question

Update statement causing the Resource #3 to display

Avatar of pingeyeg
pingeyeg asked on
PHP
9 Comments1 Solution245 ViewsLast Modified:
I have created an update statement, but for some reason I am getting the Resource #3 display when I don't feel I should be.  I know that this message is wanting the mysql_fetch_array function, but I don't feel I need it.


$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("353322_photos") or die(mysql_error());
 
if($_POST['Submit']) {
	$id = $_POST['ID'];
	$pA = $_POST['packageA'];
	$pB = $_POST['packageB'];
	$pC = $_POST['packageC'];
	$printA = $_POST['8x10'];
	$printB = $_POST['5x7'];
	$printC = $_POST['4x6'];
	$wallet = $_POST['wallet'];
	
		$update = "update pricing set packageA = '$pA', packageB = '$pB', packageC = '$pC', 8x10 = '$printA', 5x7 = '$printB', 4x6 = '$printC', wallet = '$wallet' where ID = '$id'";
		$result = mysql_query($update) or die(mysql_error());
		
		if($_POST['Submit']) {
			$result = "Your pricing changes have now been made and have reflected in the cart.";
		} else {
			$result = "There seems to have been an issue with your update.  Please contact <a href=\"mailto:brannon@goodboyweb.com\">Goodboy</a> for further assistance.";
		}
}
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros