repeating field

[tazgalsinh]

I have recordset that displays all the records from one table and these are then links to the next page. Currently all the records come out as a row, one after another. Is there something i can do to format the way they are displayed. for example, have a table. With 3 records in a row etc.

[OhLordy]

<?
for($i=0;$i<mysql_num_rows($result);$i++) {
$row=mysql_fetch_array($result);
if($i%3!=0) {
?>
<td><?=$row[0]?></td><td><?=$row[1]?></td>
<?
} else {
?>
<td><?=$row[0]?></td><td><?=$row[1]?></td></tr><tr>
<?
}
}
?>

HTH
Rob

[tazgalsinh]

thankls for the reply, but i don't understand what to do

this is my code so far

<table width="100%" border="0" cellpadding="2">
                    <tr> 
                      <td>&nbsp;</td>
                      <td><strong>Product Name</strong></td>
                      <td><strong>Manufacturer</strong></td>
                      <td><strong>Price (excl VAT)</strong></td>
                      <td>&nbsp;</td>
                    </tr>
                    <?php do { ?>
                    <tr> 
                      <td><img src="<?php echo $row_Catalog['ItemCoverThumbURL']; ?>"></td>
                      <td><a href="itemdetail.php?ItemID=<?php echo $row_Catalog['ItemID']; ?>">                      <?php echo $row_Catalog['ItemName']; ?></a></td>
                      <td><?php echo $row_Catalog['ManName']; ?></td>
                      <td><div align="center"><?php echo strtoupper($row_Catalog['itemRRP']); ?></div></td>
                      <td><table width="75%" border="0" cellspacing="5">
                          <tr> 
                            <td><a href="itemdetail.php?ItemID=<?php echo $row_Catalog['ItemID']; ?>"><img src="assets/info.gif" width="30" height="30" border="0"> 
                              </a></td>
                            <td width=5></td>
                            <td><a href="cart.php?action=add_item&id=<?php echo $row_Catalog['ItemID']; ?>&qty=1&id2=<?php echo rawurlencode($row_Catalog['ManName']); ?>"><img src="assets/addtocart.gif" width="30" height="30" border="0"></a></td>
                          </tr>
                        </table></td>
                    </tr>
                    <?php } while ($row_Catalog = mysql_fetch_assoc($Catalog)); ?>
                  </table>

[OhLordy]

<table width="100%" border="0" cellpadding="2">

                <tr> 
                  <td>&nbsp;</td>

                  <td><strong>Product Name</strong></td>

                  <td><strong>Manufacturer</strong></td>

                  <td><strong>Price (excl VAT)</strong></td>

                  <td>&nbsp;</td>

                </tr>

                <?php 
				$i=0;
				do { 
				if($i%3==1) echo("<tr>");?>

                  <td><img src="<?php echo $row_Catalog['ItemCoverThumbURL']; ?>"></td>

                  <td><a href="itemdetail.php?ItemID=<?php echo $row_Catalog['ItemID']; ?>">                      <?php echo $row_Catalog['ItemName']; ?></a></td>

                  <td><?php echo $row_Catalog['ManName']; ?></td>

                  <td><div align="center"><?php echo strtoupper($row_Catalog['itemRRP']); ?></div></td>

                  <td><table width="75%" border="0" cellspacing="5">

                      <tr> 
                        <td><a href="itemdetail.php?ItemID=<?php echo $row_Catalog['ItemID']; ?>"><img src="assets/info.gif" width="30" height="30" border="0"> 
                          </a></td>

                        <td width=5></td>

                        <td><a href="cart.php?action=add_item&id=<?php echo $row_Catalog['ItemID']; ?>&qty=1&id2=<?php echo rawurlencode($row_Catalog['ManName']); ?>"><img src="assets/addtocart.gif" width="30" height="30" border="0"></a></td>

                      </tr>

                    </table></td>

                <? if($i%3==0) echo("</tr>"); ?>

                <?php 
				$i++;
				} while ($row_Catalog = mysql_fetch_assoc($Catalog)); ?>

              </table>

I haven't tested, or even looked through the code properly but I think it should work. Give it a try.
Good luck.
Rob

[tazgalsinh]

tried that and am getting errors "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\recordstorephpstart\TMP4vfx2fpcyo.php on line 184"

which is the

 } while ($row_Catalog = mysql_fetch_assoc($Catalog)); 

thanks for help so far.

[tazgalsinh]

<table width="490" border="0">
                    <?php do { ?>
                    <tr> 
                      <td width="230" height="49"><div align="center"><?php echo $row_Recordset1['typeofproduct']; ?></div></td>
                      <td width="183"><a href="catalog.php?typeid=<?php echo $row_Recordset1['typeID']; ?>&id1=<?php echo rawurlencode($row_Recordset1['typeofproduct']); ?>"><img src="<?php echo $row_Recordset1['imageURL']; ?>" width="100" height="60" border="1"></a></td>
                    </tr>
                    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

              </table>

this is a much shorted table,could you show me how to do it on this table please, maybe easier to do it on this. thanks

[OhLordy]

Two points, 1) why are you using a do while loop instead of a while loop. A do loop does the first iteration no matter what and before executing the where condition. In this case it means that the loop will be running once before the mysql_fetch_assoc has been executed. 2) this one may be a little cheeky but it's always best to ask, have you got a line $recordset1=mysql_query($result); somewhere higher up the page?
HTH
Rob

[tazgalsinh]

yes i got

 $Recordset1 = mysql_query($query_Recordset1, $RecordStorePHP) or die(mysql_error()); 

at the top of the page.