[Fwd: Re: [PHP-DB] Re: SELECT & html ]

2005-12-04 Thread Shahmat Dahlan
-- Best Regards, Shahmat Dahlan Research and Development SAINS Mobile: +(60)16 882 6130 Office: +(60)82 426 733 ext 5512 --- Begin Message --- (1) i've been using this method for years now, maybe somebody else has a better way to do this? "; php codes $i++; } ?> (2) check out the limit

[PHP-DB] Re: SELECT & html

2005-12-04 Thread JeRRy
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>To: "PHP DB" Date: Sun, 04 Dec 2005 13:38:58 -0500Subject: SELECT & html 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 whit

RE: [PHP-DB] SELECT & html

2005-12-04 Thread Robbert van Andel
There's a couple of ways to do this. For the row color you would set that as you looped through the returned rows. Using the pear db class: $count = 0; echo "\n"; while($db->fetchInto($data)) { $count++; if($count % 2 == 0) { $bgColor = "background-color:#dcdcdc";

[PHP-DB] SELECT & html

2005-12-04 Thread Ron Piggott (PHP)
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 ti