The website that displays this problem is as follows:
http://www.pureimpressions.net/AMISH/ad ... sort=total
Code: Select all
<?php
<td bordercolor=7587AF bgcolor="$row_color" width=23%>";
$query = "SELECT order_status, cust_name from customer_request ORDER BY cust_name ASC";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
### And print ###
while(list($order_status) = mysql_fetch_row($result))
{
if ($order_status == "4_1")
{
$status = "Staining";
}
if ($order_status == "4_2")
{
$status = "Varnishing";
}
echo "<select name=selectbox>";
echo "<option value=$order_status selected=";
echo $status;
echo ">$status</option>";
echo "</select>";
}
echo "</td>";
?>