Search Results, Per Page, Total Results...
| From: | Thomas Edison Jr. | Date: | Mon, 15 Apr 2002 07:30:03 +0000 |
| Subject: | Search Results, Per Page, Total Results... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-92972@lists.php.net to get a copy of this message | ||
Hi,
I'm working on a search program that searches on a
mySQL DB and gives back results.. something like this
:
$sql_text = ("SELECT * FROM searchtb where
vCategory='$q' || vSubCategory='$q'");
What i want is that the results should be displayed
PageWise.. that is, maybe 15 results per page.
Something like this :
Page : [<<] 1|2|3|4|5 [>>]
And also i would like to display the "Total Results"
on the resulst page.
Secondly, i have a table with a column vProName, which
let's say, contain "Basket Ball Game".
Now what i want is that if someone searches for "Game"
or "Ball", even then this record should appear.
Could someone guide me for the same....
Thanks,
T. Edison Jr.
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@yahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/