if(!$sort)
 $sort="item";
if(!$add)
$add="No";
if(!$amount)
$amount=0;

$link=mysql_connect("mysql.tjhsst.edu", "syousuf", "*********");
mysql_select_db("syousuf", $link);

$query= "select * from inventory order by $sort";
$result = mysql_query($query, $link);
$num_rows = mysql_num_rows($result);

<br>
<br>




<table border=2 align=center width=80% cellpadding=4>
 <tr>
  <td align=center colspan=6>
   <b><font size="+2">Sort by: </font><form action="inventory.php" method=post>
<select name=sort>
<option>Item
<option>Sku
<option>Price
<option>Color
</select><br clear=all>
<input type="submit" value="Refresh">
</form></b>
  </td>
 </tr>
 <tr>
   <td width=10%>
   <u>Item</u>
  </td>
  <td width=10%>
   <u>Sku</u>
  </td>
  <td width=10%>
   <u>Price</u>
  </td>
  <td width=10%>
   <u>Color</u>
  </td>
  </tr>
 
  
  
for($x=0; $x<$num_rows; $x++)
{
$row=mysql_fetch_array($result);
$item=$row["item"];
$sku=$row["sku"];
$price=$row["price"];
$color=$row["color"];

Print<<<ENDHTML
<tr>
<td>$item</td>
<td>$sku</td>
<td>$ $price</td>
<td>$color</td>
</tr>
ENDHTML;
}

for($zoo=0; $zoo<$amount; $zoo++)
{
Print<<<ENDHTML
<tr>
<td><input name="a" type="value"></td>
<td><input name="b" type="value"></td>
<td><input name="c" type="value"></td>
<td><input name="d" type="value"></td>
</tr>
ENDHTML;
}
$amount=0;

</table>
<br><br>

<form action="inventoryM.php" method=post>
Add items to inventory?
<select name=add>
<option>Yes
<option>No
</select><br clear=all>
<input type="submit" value="Select">
</form>


if($add=="Yes")
{
Print<<<ENDHTML
<form action="inventoryM.php" method=post>
How Many?
<select name=amount>
<option>1
<option>2
<option>3
<option>4
<option>5
</select><br clear=all>
<input type="submit" value="Add">
</form>
ENDHTML;
}
$add="No";