A easier way to list my poll with date

Chrysanthus

Hello

Is there a easer way to make my PHP code to MYSQL request, instead of using the PHP code first the inserting the request in to mysql sow I can list out my right values.

<?
$day = date("w");
$day = $day == 0
? -6
: 1-$day;

$vecklypoll = date("Y-m-d", strtotime("$day days")); 

$result = mysql_query("SELECT srvplon FROM srv_poll WHERE srvplde = '$vecklypoll'") or die (mysql_error());
$vecklyoption = mysql_fetch_array($result);
?>

bastien

MySQL supports numerous DATE TIME functions to format dates and times...RTFM

Chrysanthus

Originally posted by bastien
MySQL supports numerous DATE TIME functions to format dates and times...RTFM

I have looked in it i have the problem of how to solve or to get the right date of the last curret date of monday and i dont know how to get it.

i do not know of on the right path here is what i have done so far...

$t = mysql_query("SELECT srvplon FROM srv_poll WHERE IF(DATE_FORMAT(NOW(), '%w') = 1, srvplde = ADDDATE(????, INTERVAL -1 DAY), srvplde = ADDDATE(???, INTERVAL -6 DAY))") or die (mysql_error());
$n = mysql_fetch_array($t);

bastien

Originally posted by Chrysanthus
get the right date of the last curret date of monday

um, huh? I don't get what date you are after? last monday of the month, coming monday, last monday? Can you clarify?

Chrysanthus

Oki the date of the last monday from today or someother day this week, can't find any thing in the MYSQL manuel that refears to a function in mysql that points out the date of last monday or someother date this week if there is then i must be blind or something.

it's for adding or removeing days from the last current date of monday sow i can list the right values.

bastien

what is the goal of the querry?

Chrysanthus

To add or to remove days from last monday date if its not monday today i think that's the way i did it in PHP.

like this exampel

if it's not monday to day liste after last mondays date from to day

exampel

today is it 2005-03-03 and its not monday to day
the MYSQL shal liste efter last mondays date and that is int this exampel 2005-02-28

Othervise if it is monday to day the MYSQL will list after todays date.

the only thing that i dont solved yest is what to put in the fieald ???

$t = mysql_query("SELECT srvplon FROM srv_poll WHERE IF(DATE_FORMAT(NOW(), '%w') = 1, srvplde = CURDATE(), srvplde = ???)") or die (mysql_error());
$n = mysql_fetch_array($t);