problem in using strtotime in query mysql

[oranoos3000]

hi
i work with php and mysql on the os windows
i want to using function strtotime for compute diffrences between
two date , one with format date("Y-F-d") and another date is current time
and query is

$sql_select="select * from $table_name  where  confirm=1 and ";
$sql_select.=strtotime."(".expire_date_show.") - ".time().">=0";
//expire_date_show is the column in database with format date("Y-F-d")
 

but this query select and show all of the query even they that epire_date_show
is greater than current time
please help me that how write this query to solve this problem

[Atli]

Hi.

You can not fuse a PHP function into a MySQL query in that manner.
The data returned by a SQL query can not be used by your PHP code until the query has been executed and the data returned.

I'm betting that if you put these two lines at the top of your code, so that errors will be displayed, that you will get a "undefined constant" warning for the strtotime function. (And probably "expire_date_show" to).

error_reporting(E_ALL | E_STRICT);
ini_set('display_errors', true);

In any case, you do not need the strotime function to do this. MySQL is capable of doing this all by itself.
Consider this:

SELECT * FROM myTable
WHERE `DateValue` > NOW()

This would return only those rows from the "myTable" table where the "DateValue" is greater then the current date.

[oranoos3000]

hi
excuse me
in your answer
DateValue that one of the columln in table in db,what is data type of this column and format amount of this column?
because
i want to save two date in the table
and compare current time with two date and if current time is between
two date then show this record


thanks


@Atli

[Atli]

The "DateValue" column in my example would be either a DATE, DATETIME or TIMESTAMP. They should all work.

The good thing about using these types for dates (as apposed to using strings or integers) is that MySQL has a lot of date functions that are specifically built to manipulate them.
If you store dates as strings or integers you won't be able to use them and all manipulation would have to be done manually by your front-end.

If you need to find out whether a value is between a pair of other values, you can use the BETWEEN AND syntax.

SELECT * FROM myTable
WHERE DateValue BETWEEN  NOW() AND DATE_ADD(NOW(), INTERVAL 1 DAY);

This would return all rows who's DateValue is between the current time and the same time tomorrow.