> It is not apparent from your question, where the problem lies. Why not > show us what you have so far? > SQL is used to retrieve data from relational databases. Are you really > intending to retrieve FROM a web page?
Sorry, I meant that I am writing a PHP web page that takes input from a user through a standard HTML form and based on that input generates an SQL query. > If your difficulty is with the SQL phrasing: check out the keyword > BETWEEN (MySQL (or whichever) manual). It is an SQL phrasing difficuly and I think I now understand how to do it (SELECT * from myTable where creationDate BETWEEN 20010101000000 and 20020101000000), so I am off to have a play and work it out. Many thanks, Ben --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
