From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]> To: "PHP DB"
<[email protected]> Date: Sun, 04 Dec 2005 13:38:58 -0500 Subject:
SELECT & html <table>
I have two questions. I would like to display the contents of my table
with the first row being grey in background and the next row being white and
the third row being grey, fourth being white, etc. I am not sure how to do
this. Secondly I only want the first 20 records to be displayed at a time
and then I want to create a "NEXT" link for the next 20 records (21-40) ...
any idea how you would use the SELECT command to do this? Ron
[input] [input] [input] [input] [input] [input] [input]
[input]
Visit http://www.mysql.com/ and read a little bit about LIMIT command. :)
Jerry
---------------------------------
Do you Yahoo!?
Take your Mail with you - get Yahoo! Mail on your mobile
---------------------------------
Do you Yahoo!?
Never miss an Instant Message - Yahoo! Messenger for SMS