calculation with month...

akaki

Hello,
I create some search option with drop down list box. search by month is 1 of them. I've a table named orders, suppose LabOrder_No & Log_date. dates are storing in database as yy-mm-dd but im retriving as dd-mm-yy. I will select a month name from list (jan,feb....dec & their values are 01,02...12), click submit button & display the total orders & quantity of that month. to collect total quantity, i wrote a function:

$month = $_POST['month'];

function totalOrders(){
$q = "SELECT LabOrder_No, LogIn_Date FROM orders WHERE LogIn_Date = '$month'";
$r = mysql_query($q);
if($r){
while($data = mysql_fetch_array($r))
$total = $total + count($data['Sl_No']);
echo $total;
}
}
?>

Topal quantity : <?php echo totalOrders();?>
But displaying nothing. Whats wrong with query

sandthipe

hey akaki, I'm no php master, but I see a few things wrong with your script, so maybe I'll be of some help.
1. you need to include '$month' in your function when you define the function and when you call the function as follows:
Function Definition:

function totalOrders($month)

Function Call:

<?php totalOrders($month);?>

also, as you can see from the "Function Call" example, you don't need to use the 'echo' command to print out the results of your function. You already told the function to 'echo $total'
in this line
```
$total = $total + count($data['Sl_No']);
```
you are looking for a table field called 'Sl_No' but no such field was selected as part of your initial query. Add that to the select fields as follows:
```
$q = "SELECT LabOrder_No, LogIn_Date, Sl_No FROM orders WHERE LogIn_Date = '$month'";
```

I don't think that covers all of the problems, but at least some of them. Without knowing the rest of your script, I'm gonna go out on a limb and suggest that you can't match the POST variable '$month' to your date field until you first strip out the year and day parts of that field. In other words, you need to make the yy-mm-dd date field stripped down to be just mm, so it will match your POST variable.

hope that helps a little,
-chris

suntra

<?php
function totalOrders(){
    $month = intval($_POST['month']; // Converts to an integer to prevent MySQL injection
    $month = (($month < 10) ? '0' : '') . $month; // Adds a 0 if month < 10
    $q = "SELECT LabOrder_No FROM orders WHERE LogIn_Date LIKE '%-$month-%'"; // Selects 1 field (whatever it is) where the date is LIKE 'anything-$month-anything'
    $r = mysql_query($q); // Queries the db
    if($r) { // if $r is ok
            return mysql_num_rows($r); // Returns the number of rows returned
    }
}
?>

Topal quantity : <?php echo totalOrders();?>

akaki

Thanks Sandip/Suntra,
Suntra, while using ur function, its counting rightly. But There is another surprising problem with ur code. I m retrieving all records first, displaying in a table & at the last the function count total numbers. But with ur code, my own code are not working. I mean, the table is not displaying the whole records!!! Just displaying the quaitity, Do u figure out what kind of problem with ur code?

And is it posible to display the month name, which i m retrieving? Suppose:
Total record of "June" is : (Its value in select option is '06')
Thanks