I have one table called member, and i have 2 column called date and date1
how i can substract the 2 of them, date1-date > 0??
i tried TIMEDIFF, but could not make it, because nothing happened in my server
if($dateasd =mysql_query("SELECT * TIMEDIFF ('date1', 'date') FROM member")>0)
{
$login=0;
}
is there something wrong in how i define the variable?
Comparing 2 datetime in mysql
Moderator: General Moderators
Re: Comparing 2 datetime in mysql
How do you write the name of a field (or table, or database) in a SQL query?
How do you write a string value?
Which of those methods did you use for TIMEDIFF?
Which one should you have used?
How do you write a string value?
Which of those methods did you use for TIMEDIFF?
Which one should you have used?