PHP Data by Month

Smackie

Alright im having a little problem i have data in the database needing to be retrieved by each month ok well before reviewing the data the admin/user will have to have a drop down menu (which i already have) it shows all the months that has data in it. now my problem is recieving the data for that month it either shows all the data (not by month) or it will just show blank screen.

here is what i have so far for the page and not sure if i'm over looking something or what.

$date = $_GET['date'];

$sql = mysql_query("SELECT * FROM reports WHERE review = 'reviewed' AND user_name = '$user_name' ORDER BY date DESC"); 
while($row = mysql_fetch_array($sql)) {

jeremyphphaven

Yah, so you're missing the main part of your SQL query... (your current query is like a car with no engine)... you need the guts, the part that looks for the dates applicable in the table.

if you're using unix based timestamps while storing your data... you can probably simply add something like so -

SELECT * FROM reports WHERE review = 'reviewed' AND user_name = '$user_name'  AND date > '######' AND date < '#####' ORDER BY date DESC

Of course you'll need to create variables to pass to those dates based on what the user selection is, but I think you're only asking about the SQL...

If you need further help (let's say you're not using unix timestamps, but mysql timestamps, or you're stuck on what to feed those pound signs above), drop a line.

good luck

Smackie

sorry the field called date shows date like

2008-05-12

but i need the script to only use 2008-05 or something like that i have a script thats like it can't figure out on how to get it to work with mine.

    $query_reports = "SELECT * FROM reports WHERE callsign='".$_SESSION['officer']."' AND review='$reviewer' ORDER BY date DESC";
    $result_reports = mysql_query($query_reports) or die('QUERY REPORTS FAILED: ' . mysql_error());
    while ($line = mysql_fetch_array($result_reports)) {

        $rep_date = explode("-", $date); # Year = $dates[0] | Month = $dates[1] | Day = $dates[2]
        $yr_mon = $rep_date[0]."-".$rep_date[1];