[RESOLVED] Can't display details of an item in a separate page

[seamres]

After clicking the 'View details' link, I only get a blank table.

This is my code for displaying the list of items

$con = mysql_connect("localhost","root","");
	mysql_select_db("new", $con);

$id=$_SESSION['idnum'];

$sql=mysql_query("SELECT order_id, order_desc, order_date FROM order_info where cust_id=$id ORDER BY order_date");
$limit=2; //maximum of only 2 pending orders
$count=0;

echo "<div id=\"panel\">";

	echo "<table id=\"contable\">";
	echo "<tr><th colspan=\"3\">Order Details</th></tr>";
	echo "	<tr><th>Order ID</th><th>Description</th><th>Date</th></tr>";

	while($row=mysql_fetch_array($sql))
	{
		$order_id=$row['order_id'];
		$order_desc=$row['order_desc'];
		$order_date=$row['order_date'];	

		/*Display selected rows from table order_info*/

		if($count<$limit)
		{
			//order_id
			echo "<tr><td>$order_id ";
			//link to view order details
			echo "<a class=\"tablelink\" href=\"cust_vieworder.php?order_id=".$row['order_id']."\">View details</a></td>";
			//order_desc and order_date
			echo "<td>$order_desc</td><td><center>$order_date</center></td></tr>";				
		}
		else $count=0;

		$count++;
	}

	echo "<tr><td><a href=\"cust_addorder.php\">Add an order</a></td></tr>";
	echo "</table>";

And this one for displaying specific item details in a separate page

$con = mysql_connect("localhost","root","");
	mysql_select_db("new", $con);

/*Display all rows from table order_info of specific order item*/

$o_id=(int)$_GET['order_id'];
$sql=mysql_query("SELECT * FROM order_info where order_id=$o_id");
$row=mysql_fetch_array($sql);

echo "<div id=\"panel\">";

	/******************ORDER DETAILS TABLE**********************/

	echo "<table id=\"contable\">";
	echo "<tr><th colspan=\"6\">Order Details</th></tr>";

	while($row=mysql_fetch_array($sql))
	{
		$order_id=$row['order_id'];
		$order_desc=$row['order_desc'];
		$order_date=$row['order_date'];
		$prod_type=$row['prod_type'];
		$prod_qty=$row['prod_qty'];
		$total_amount=$row['total_amount'];

		echo "<tr><td>Order ID</td><td>$order_id</td></tr>";
		echo "<tr><td>Description</td><td>$order_desc</td></tr>";
		echo "<tr><td>Order Date</td><td>$order_date</td></tr>";
		echo "<tr><td>Product</td><td>$prod_type</td></tr>";
		echo "<tr><td>Quantity</td><td>$prod_qty</td>";
		echo "<tr><td>Total Amount</td><td>$total_amount</td>";
		//echo "<tr><td>Design</td><td> ??? </td>";
	}	
	echo "</table>";
echo "</div>";

[bradgrafelman]

In the second code snippet, you're calling mysql_fetch_array() immediately after executing the query, but then you never do anything with $row. Assuming that at most one record will be matched, your while() loop will then discard that one and only row (leaving you with an empty table).

I would say you need to get rid of the while() loop construct, since it doesn't make sense to use a loop when you only expect to execute the code once.

[seamres]

Oh, that makes sense. I could display it now. Thank you very much.