CodingForums.com - View Single Post

BluePanther · 07-26-2011, 09:25 AM

Because you are limiting your query to 1 result, you don't actually need a while loop, so remove the while to leave you with this inside the if:

PHP Code:


			
$row = mysql_fetch_array($sql); 

$product_ name = $row["product_ name "];

$price = $row["price "];

You Should add 'or die(mysql_error())' to the end of your query to catch any errors.

Also, could you post your form code?

07-26-2011, 09:25 AM	PM User \| #2
BluePanther Senior Coder Join Date: Jul 2011 Posts: 1,226 Thanks: 3 Thanked 171 Times in 171 Posts	Because you are limiting your query to 1 result, you don't actually need a while loop, so remove the while to leave you with this inside the if: PHP Code: `$row = mysql_fetch_array($sql); $product_ name = $row["product_ name "]; $price = $row["price "];` You Should add 'or die(mysql_error())' to the end of your query to catch any errors. Also, could you post your form code?