Jeneca
-
Content Count
24 -
Joined
-
Last visited
-
But why when I try to choose one store there is a rows that returning..? <?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: <inp
-
SELECT restaurant_master.code, restaurant_master.name, 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 '2012-01-01 00:00:00' AND '2012-01-31 23:59:59' AND restaurant_master.name = '0' AND mds_orders.StatusFKID = 3 GROUP BY ReasonMaster.ReasonDescription this is the echo prints after I cho
-
Don E not that info, when someone selects a restaurant name from the drop down list it display the data for that particular restaurant, and data will come from the database. Any ways already done with that, my problem now is what if I select "ALL" restaurant..? IThis is my updated code <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="
-
This query already works, but when I try to select all, there is no data displayed <?php $result = mysql_query("SELECT name FROM restaurant_master"); echo "<select name='name'>"; echo "<option value='0'>ALL</option>"; while($r = mysql_fetch_array($result)) { echo "<option value='".$r['name']."'>".$r['name']."</option>"; } echo "</select>"; ?>
-
I already put my database connection at the top. <?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="dfr
-
This is what I've done..Is that correct..? <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="name"><?php $result = $dbc->query("SELECT RestaurantID FROM mds_orders"); while($row = mysqli_fetch_assoc($result)) { $id = $row['
