Re: Displaying a 2 column html table with N elements

In article <20020324202536.38510.qmail@pb1.pair.com>, map@inter-resa.com says... > Hello, > > I am trying to display a HTML table of 2 cells with "n" elements... This means > an unknown number of lines. > > I need to use 2 FOR loops (one to determine the number of <TR> and one to > create the 2 cells needed). This is a bit to overwellming for me... > > I have: > > $result = connect_db("select prod_id,photo from prod where cat_id=1"); > $Rows = pg_NumRows($result); > $lines_TOT = ceil($Rows/2); > > > for($TR=0; $TR < $ligne_TOT; $TR++){ > print "<tr>\n"; > > for($TD=0; $TD < 2;$TD++){ > $photo=pg_Result($result,$TD,photo); > $prod_id=pg_Result($result,$TD,prod_id); > print "<td>"; > if ($prod_id != ""){ > print "<img src=\"../photo/". $photo. "s.jpg\" > border=0>\n"; > } else { > print "&nbsp;"; > } > print "</td>"; > } > } > > > As you can see, the second loop cant continue to display the next product... So > the first line with the 2 images are ok but the other lines are identical, so > if I have 10 products, I see only 1 and 2 over 5 lines! > > How can I solve this? To have 2 columns per line, I must limit the loop but I > need to continue at that point on the second line... > > Thank you for any assistance! > What about something like: <TABLE><TR> <?php $i = 1; // This is counter for number of records processed $items = 2; // how many cells per row $result = connect_db("select prod_id,photo from prod where cat_id=1"); while($row = pg_fetch_array($result, PGSQL_ASSOC)) { extract($row); if($i % $items == 0) { echo '</TR><TR>'; } echo '<TD><img src="../photo/'. $photo. 's.jpg" border=0></TD>\n"; $i++; } ?> </TR></TABLE> Uses the modulus operator to keep track of how many rosws/columns you have. Untested, of course. -- David Robley Temporary Kiwi! Quod subigo farinam