Qustion about timeing

[mohamad_1978]

hi there
lets say i have table called (poll) and this is the info

qustion ... answer1 .. answer2 .. answer3 .. start_date .. end_date

i want to know the code that show the poll from this table that in this date range and if not show msg say there is no poll today

[kevinsequeira]

im not sure what formats you have stored your date values, but the general idea is this
get the $start_value and $end_value from a form or whatever ...

$q = select * from poll where start_date >= '".$start_value."' AND end_date < ="'.$end_value."'";

$r = mysql_query($q);

if(mysql_num_rows($r) > 1){

// display polls

}else{

// no polls
}

reg
kevin

[mohamad_1978]

i will use time value i will use mkdate when i add start date and end date i dont think ur idea will work with it

[jimson]

To : mohamad_1978
first, I don't know what type of data is start_date and end_data, it is "datetime" ? anyway to kevinsequire, your code is wrong! I don't think your code will run.

I don't know how will you display your poll, it is one poll or many polls you want to display?
To show one poll, the SQL query would be

$currentDate = date('Y-m-d H:i:s');
$sqlstm = "SELECT FROM poll WHERE start_date < '$currentDate' AND end_date > '$currentDate' ORDER BY start_date DESC LIMIT 1";

if you want to show many poll, then omit the LIMIT 1.
Hope this will help.

[mohamad_1978]

thanks jimson it is nice

[jimson]

you are welcome