Re: [PHP] Search Results, Per Page, Total Results!
Here you can find a php class to make it work very simply...
http://phpclasses.promoxy.com/browse.html/package/366.html
- Original Message -
From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 9:23 AM
Subject: [PHP] Search Results, Per Page, Total Results!
> Hi,
>
> I have a mySQL table on which i'm performing a
> search.. something like this :
>
> $sql_text = ("SELECT * FROM searchtb where
> vCategory='$q' || vSubCategory='$q'");
>
> Now i want the Search Results to appear per page..
> that is, maybe 15 Records per page should appear..
> with something like this on top to navigate through
> search results :
>
> Page : [<<] 1|2|3|4|5 [>>]
>
> And i would also like to display total results found
> on results page.
>
> Lastly, suppose i have a column "vProName" in my mySQL
> Database, which contains a record like this :
> Millenium basket ball
>
> Now if someone searches for "basket" or "ball" .. i
> want this record to show up in search results. How can
> i make that possible?
>
> Can anyone guide me towards this..
>
> Thanks,
> T. Edison Jr.
>
>
>
>
>
> =
> Rahul S. Johari (Director)
> **
> Abraxas Technologies Inc.
> Homepage : http://www.abraxastech.com
> Email : [EMAIL PROTECTED]
> Tel : 91-4546512/4522124
> ***
>
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results...
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 : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results!
Hi,
I have a mySQL table on which i'm performing a
search.. something like this :
$sql_text = ("SELECT * FROM searchtb where
vCategory='$q' || vSubCategory='$q'");
Now i want the Search Results to appear per page..
that is, maybe 15 Records per page should appear..
with something like this on top to navigate through
search results :
Page : [<<] 1|2|3|4|5 [>>]
And i would also like to display total results found
on results page.
Lastly, suppose i have a column "vProName" in my mySQL
Database, which contains a record like this :
Millenium basket ball
Now if someone searches for "basket" or "ball" .. i
want this record to show up in search results. How can
i make that possible?
Can anyone guide me towards this..
Thanks,
T. Edison Jr.
=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
