Displaying SELECT results
| From: | Christopher J. Crane | Date: | Fri, 22 Mar 2002 02:31:19 +0000 |
| Subject: | Displaying SELECT results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-89633@lists.php.net to get a copy of this message | ||
I wrote a shopping cart, but I
don't understand two things.
1) What is the best way to display like the first ten records and then a
list of how many pages with 10 records on them...similar to like a search
engine when it returns it's results. If I have 100 items I do not want to
display all of them on one page. So I will display the first ten, and then a
link for the next ten or something like that. I did this in PERL, but it was
a long mathematical routine to get it and I know there must be an easier
way.
2) To display the results of a SELECT statement, but every other line is a
off color. So Like row 1 is white and row 2 is gray and row 3 is white and
row 4 is gray and so one.