I get a list, but instead of getting ALL dates on which orders have been placed, I am getting a repetitive list of only the LAST date on which an order was placed.
Can anyone tell me where I have erred?
Code: Select all
<?php
//View orders by order date
$query3 = "SELECT DISTINCT date FROM orders ORDER BY date DESC";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_assoc($result3);
?>
//html
<?php
do {
?>
<?php
//Run query
if ($result3 = mysql_query ($query3));
//Convert order date format
$date = $row3['date'];
$date_arr = explode('-', trim($date));
$order_date = ($date_arr[1].'-'.$date_arr[2].'-'.$date_arr[0]);
?>
<!-- Show list of available dates -->
<option value="<?php echo $order_date; ?>"><?php echo $order_date; ?></option>
<?php
} while ($row3 = mysql_fetch_assoc($result3));
$rows = mysql_num_rows($result3);
if($rows > 0) {
mysql_data_seek($result3, 0);
$row3 = mysql_fetch_assoc($result3);
}
?>