[budiarto]

Hi,

Anybody know how to do a "search by date" with php.?

For example:
I have customers table in MySQL and I want to search all customers who have birthdate between Jan01-2003 and Feb01-2003.

Any help are greatly appreciated.

regards,

Budiarto.
+++++++++++++

[Infinite_Hackers]

look at some of these.
http://programmingtalk.com/search.php?searchid=34429

[budiarto]

Hi,

I can't seem to find what I'm looking for in the URL you gave.
Any specific examples..?

B.
+++++++++++++++++

Originally Posted by Infinite_Hackers

look at some of these.
http://programmingtalk.com/search.php?searchid=34429

[Infinite_Hackers]

Originally Posted by Infinite_Hackers

$query = 'SELECT * FROM records WHERE ' . $t . ' REGEXP ' . $trimmed;

try that

you can change the records to date (the row name)

[budiarto]

Infinite_Hackers.., thanks for the info.

I also try something easier and works fine:

query= "select * from tablename where date_column betwen condition1 AND conditions2" ;

the format of condition1 and condition2 must be "yyyymmdd" not "yyyy/mm/dd" nor "yyyy-mm-dd".

If anybody can tell me a better way, I really appreciate it..

Budiarto.
--------------

Originally Posted by Infinite_Hackers

you can change the records to date (the row name)