How to select "All" the store names in a drop down list..?
<?php
// db connection
$db = "mds_reports";
if($connect = mysql_connect("172.16.8.32", "mds_reports", "password"))
$connect = mysql_select_db($db);
else die("Unable to connect".mysql_error());
$date_from = $_POST['dfrom'];
$date_to = $_POST['dto'];
$name = $_POST['name'];
?>
<html>
<head>
<title>Cancelled Order</title>
</head>
<body>
<h1>Cancelled Order Report</h1>
<form name="fetching" method="POST" action="cancelled_orders_index.php">
Date From: <input type="text" name="dfrom" id="dfrom">
Date To: <input type="text" name="dto" id="dto"><br /><br />
Select: <select name="pkid">
<?php
echo "<option value='0'>ALL</option>";
$result = mysql_query("SELECT name,pkid FROM restaurant_master");
while($r = mysql_fetch_assoc($result))
{
echo "<option value='{$r['pkid']} '>{$r['name']}</option>";
}
echo "</select>";
?>
<input name="submit" type="submit" value="Go">
</form>
<table>
<table border="2"
cellpadding="2"
cellspacing="1"
style='width:100%;'>
<tr>
<th>Restaurant Code</th>
<th>Restaurant Name</th>
<th>Order No.</th>
<th>Order Source</th>
<th>Payment Type</th>
<th>Net Price</th>
<th>Gross Price</th>
<th>Reason</th>
<th>Count Reason</th>
</tr>
<?php
if(isset($_POST['submit']))
{
echo "Date select from $date_from to $date_to"."</p>";
echo "Restaurant: $name"."</p>";
$sql = "SELECT restaurant_master.code, restaurant_master.name,
mds_orders.OrderNo,
mds_orders.OrderSourceText AS 'ordersource',
mds_orders.PaymentTypeText AS 'paymenttype',
mds_orders.NetTotal AS 'netprice',
mds_orders.GrossTotal AS 'grossprice',
ReasonMaster.ReasonDescription AS 'reason',
COUNT(ReasonMaster.ReasonDescription) AS 'reacount'
FROM mds_orders
JOIN ReasonMaster
ON mds_orders.ReasonFKID = ReasonMaster.PKID
JOIN restaurant_master
ON mds_orders.RestaurantID = restaurant_master.pkid
WHERE
mds_orders.OrderDate BETWEEN '".$date_from." 00:00:00' AND '".$date_to." 23:59:59'
AND restaurant_master.name = '$name'
AND mds_orders.StatusFKID = 3
GROUP BY restaurant_master.code, restaurant_master.name, mds_orders.OrderNo,
mds_orders.OrderSourceText, mds_orders.PaymentTypeText, ReasonMaster.ReasonDescription,
mds_orders.NetTotal, mds_orders.GrossTotal";
if($_POST['pkid'])
$sql.=" WHERE pkid={$_POST['pkid']}";
$result = mysql_query($sql)
or die("Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
$i = 0;
if (mysql_num_rows($result) >0) {
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$csv .= $row['code'].",".
$row['name'].",".
$row['OrderNo'].",".
$row['ordersource'].",".
$row['paymenttype'].",".
$row['netprice'].",".
$row['grossprice'].",".
$row['reason'].",".
$row['reacount'].","."<br>";
?>
<tr>
<td><?php echo $row['code'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['OrderNo'];?></td>
<td><?php echo $row['ordersource'];?></td>
<td><?php echo $row['paymenttype'];?></td>
<td><?php echo $row['netprice'];?></td>
<td><?php echo $row['grossprice'];?></td>
<td><?php echo $row['reason'];?></td>
<td><?php echo $row['reacount'];?></td>
</tr>
</tr>
</tr>
<?php
}}}
?>
This is my sample program.
