Pica Posted March 8, 2005 Share Posted March 8, 2005 My products database contains more than 10,000 items. When doing a search, I can obtain several pages if I don't specify some criteria. Is there a way to limit the number of results ? And add a message like : "Too many resultsL. Please be more specific." (or something like this) Also, would this use less server-resources ? Thx. Link to comment Share on other sites More sharing options...
peterr Posted March 8, 2005 Share Posted March 8, 2005 Hi, Any MySQL qry can have the LIMIT qualifier appended to the sql, so try that. Peter Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.