Re: Dynamic <td> generation when retrieving data fromdatabase...

i think u want to backcolor every other row with diffirent color , so you can use : //////////////// $result = mysql_query("$sql"); $i = TRUE; while($row = mysql_fetch_array($result)) { $i=!$i; $bgcolor = ($bgcolor == '#E3E8F0' ? '#C7D0E2' : '#E3E8F0'); ?><tr bgcolor="<?=$bgcolor?>"> <?php echo "<td><div align=\"center\"><font face=\"Verdana\">". ////////////////// but if u were looking for odd and and even function you can use: ($i++ % 2 == 0) regards "Gavin Amm" <Gavin@ksg.com.au> wrote in message news:6360DB81131C094BA970711B9FA05BFD0C6406@ksg-sbs2k.ksg.com.au... Use while loops to cycle through & build the table, & mod to determine if it's even or odd. ie, If mod not = 0 then the number is odd. I could only find fmod(), I don't know if this is the right function... Gav -----Original Message----- From: Jonathan Villa [mailto:jvilla@isdesigndev.com] Sent: Friday, 23 May 2003 2:30 PM To: Jadiel Flores Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Dynamic <td> generation when retrieving data fromdatabase... Actually, now that I think about it, I would also like to create the <tr> dynamically. I'm looking for something which will determine if the result is 1 or an odd or even number. If it's 1, then just print out that result. If it's an odd number > 3, display the results in rows of 3 colspaning where needed. If it's an even number, display the results in groups of 2, and colspan where needed. That is my logic, just need some syntax On Thu, 2003-05-22 at 23:22, Jadiel Flores wrote: > You can have an extra index in your loop, and every time you write a <tr> > return it's value to 0, so, everytime you write a <td> ask > if($resultsindex+1 == count($results)) then you just have to check if the > extra index is 0, 1 or 2, if it's 0 you should have a colspan=3 if it's 1 > use colspan=2 or if it is 2 you don't have write the colspan. > > Hope I explained it ok. > > At 11:10 p.m. 22/05/2003 -0500, you wrote: > >Does anyone have a script which will do the following: > > > >For a shopping cart, I have the merchandise coming from the database > >(image references, prices, ids, names, etc.) > > > >When I begin to display the results on the page I want to be able to > >specify my <td> colspans and basic HTML table structure dynamically. > > > >For example, if result is 4, I want this > > > ><tr> > > <td>image1</td> > > <td>image2</td> > > <td>image3</td> > ></tr> > ><tr> > > <td colspan=3>image4</td> > ></tr> > > > >if it's 5, > ><tr> > > <td>image1</td> > > <td>image2</td> > > <td>image3</td> > ></tr> > ><tr> > > <td>image4</td> > > <td colspan=2>image5</td> > ></tr> > > > >etc. > > > >Any idea, scripts? > > > > > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php