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

[EMAIL PROTECTED] 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


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to