On 2/28/2004 4:43:48 AM, Michal Migurski ([EMAIL PROTECTED]) wrote: > >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?
> All you need is substr() and the mysql keyword 'like', and you should be > all set. Why didn't you make join_date_time a datetime in the first place? Hey, Thanks for replying. We needed a timestamp there because of other calcalations from other scripts that access the same table. Regarding your solution, can you give me a quick example please? its 5am and i'm pretty braindead.... I am familier with the LIKE command with the % operator as I use it often to search for words, but am just a bit puzzled with what you wrote... Thanks, -Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
