Jump to content

Jeneca

Members
  • Content Count

    24
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Jeneca

  • Rank
    Newbie
  • Birthday 06/22/1992

Previous Fields

  • Languages
    PHP, HTML, CSS, MYSQL

Profile Information

  • Gender
    Male
  • Location
    Philippines

Contact Methods

  • Yahoo
    nica_krystal22@yahoo.com
  1. Jeneca

    Looping

    Going to choose by Name, but the output is correct, the problem only is when the selection of all store there are output or data displayed.
  2. Jeneca

    Looping

    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
  3. Jeneca

    Looping

    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
  4. Jeneca

    Looping

    Nothing, only the selected date like.. Other than that there are no restaurant name and data displayed.
  5. Jeneca

    Looping

    Thank you Birbal! it already works.. but when I try to select all there are no data displayed..?
  6. Jeneca

    Looping

    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="
  7. Jeneca

    Looping

    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>"; ?>
  8. Jeneca

    Looping

    How can I add in the drop list the "ALL", that when I choose to select all store names..?
  9. Jeneca

    Looping

    @Don E and @ birbal thank you for your response. I already shows the store names in the drop down list, my problem now is how can I get their value..? Ex: If I Choose Greenhills, only the record of Greenhills should be displayed.
  10. Jeneca

    Looping

    how can I get their value..?Example:I Choose Greenhills, only Greenhills should be displayed.
  11. Jeneca

    Looping

    What I'm trying to display is the list of store names in a drop down list, but their restaurantID should be called/select..?What should I do..?
  12. Jeneca

    Looping

    I also try that, but I know why but still there are no store names in the drop down list. :|
  13. Jeneca

    Looping

    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
  14. Jeneca

    Looping

    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['
×
×
  • Create New...