Re: show number of search results

make a sql just with your where clause like this select count(*) from table where your where clause the relsulting result set will give u the number of records for your where clause sgibbs@vt.globalhealth.org schrieb: > Good day, > > I'm trying to figure out how I can show the following on my search results > page: > > SEARCH RESULTS 1 - 10 of 14 total results for books > > Currently, I have a limit of 10 results printing on a page using "offset". > I figured out how to program the pages to know what page of the results its > viewing (eg: you are on page 4 or 10 pages of results) so programming the > above statement shouldn't be difficult because the two statements seem quite > similar. Nevertheless, I can't figure it out - I have a feeling I'm making > it harder than it really is. Any suggestions or leads would be greatly > appreciated! > > Thank you, Shawna