RE: [PHP] Search logic question

Hardik Doshi <mailto:php_hardik@yahoo.com> on Thursday, December 04, 2003 2:21 PM said: > Please let me know. If you have any doubt in > understanding the entire process please let me know so > i can try to explain more. Let me know if I get this right. A user searches for something. User gets 500 results spanning 50 pages (10 results per page). You want the user to then be able to search using ONLY the 500 results OR using ONLY the results currently being displayed on the page? In either case I would store the ID's (assuming each result has it's own unique ID from the data, i.e. an auto-increment field) in an array and then pass all those ID's to the SQL statement using the "IN" clause. SELECT thing FROM stuff WHERE id IN(1,2,3,4,5,10,14,24,54,etc.) HTH, Chris. -- Don't like reformatting your Outlook replies? Now there's relief! http://home.in.tum.de/~jain/software/outlook-quotefix/