Hi, I have a couple of records in the DB with timestamp(14) values. The field is join_date_time and the values are something like: 20040222000015 20040223015329
Everything is working fine and dandy except now that the client wants a search functionality in his "control panel" where he can enter the day, month, year and see all the people who have joined on that particular date... I have created 3 text boxes in the html form named mm,dd,yyyy....but how do i search on that? I have been looking at both the PHP and MySql manual for this and google..the closest solution I could find was to select all the records from the database then convert them to a unix timestamp with mktime and then compare them....which is a long process and pretty resource wasteful (IMHO) as there will most probably be hundreds if not thousands of records... Any suggestions? Thanks, -Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
