[zoliky]

I have a table with 2 columns and 2 rows (2x2). Four cells exist (a,b,c and d):

Code:

a | b
--- ---
c | d

I need to list products like an e-commerce website. For example: In cell A I have another table with 3 columns and 3 rows (3x3).

To understand this, see: http://img216.imageshack.us/img216/9052/tablesy1.jpg

This is the HTML code:

Code:

	<table width="100%" border="0">
		<tr>
			<td>
			<table cellpadding="0" cellspacing="0">
				<tr>
					<td><img src="images/procesor.jpg" alt="[image]" /></td>
					<td>&nbsp;</td>
					<td>210 USD</td>
				</tr>
				<tr>
					<td bgcolor="#ff6600">Price</td>
					<td bgcolor="#ffcc99">&nbsp;</td>
					<td bgcolor="#ffcc99">210 USD</tr>
				</tr>
				<tr>
					<td>&nbsp;</td>
					<td>&nbsp;</td>
					<td>&nbsp;</td>
				</tr>
			</table>
			</td>
			
			<td>
			<table cellpadding="0" cellspacing="0">
				<tr>
					<td><img src="images/procesor.jpg" alt="[image]" /></td>
					<td>&nbsp;</td>
					<td>210 USD</td>
				</tr>
				<tr>
					<td bgcolor="#ff6600">Price</td>
					<td bgcolor="#ffcc99">&nbsp;</td>
					<td bgcolor="#ffcc99">210 USD</tr>
				</tr>
				<tr>
					<td>&nbsp;</td>
					<td>&nbsp;</td>
					<td>&nbsp;</td>
				</tr>
			</table>
			</td>
			
		</tr>
	</table>

Now I don't undestand how to use mysql_fetch_array to show all products.

Code:

$querydb = mysql_query("SELECT * FORM products");
while ($row = mysql_fetch_array($querydb)) {
}

The first product in cell A (row1) , the second product in cell B (row1), the third product in cell C (row 2), etc..

Someone help me a bit ? Please, any help is appreciated.

[Walkere]

Originally Posted by zoliky

Now I don't undestand how to use mysql_fetch_array to show all products.

Code:

$querydb = mysql_query("SELECT * FORM products");
while ($row = mysql_fetch_array($querydb)) {
}

The first product in cell A (row1) , the second product in cell B (row1), the third product in cell C (row 2), etc..

There are a couple of ways to handle this situation.

One way would be to cycle through the mySQL result, create an array of the result-set, and then reference that array in your table.

Here's an abbreviated example...

PHP Code:

<?php $resArray = array();

$result = mysql_query("SELECT * FROM products");



while ( $row = mysql_fetch_array($query) ) {

   $resArray[] = $row;

} ?>



<table>

  <tr>

    <td><table> ...  use $resArray[0] to populate this table ... </table></td>

    <td><table> ...  use $resArray[1] to populate this table ... </table></td>

  </tr>

...

If you're unsure of how many results you're getting, then you could include the table creation inside your loop through the DB result-set.

Something like this...

PHP Code:

<?php 

echo "<table>";

$iteration = 0;



$result = mysql_query("SELECT * FROM products");

while ($row = mysql_fetch_array($result)) {

  if ($iteration % 2 == 0) {

    //  We're at an even iteration.  Open a table row

    echo "<tr>"; }



   echo "<td>";



   //  This is where you create the table and fill it with values from the $row array



   echo "</td>";



  if ($iteration % 2 == 1) {

    //  We're at an odd iteration.  Close a table row

    echo "</tr>"; }



   $iteration++;

}



if ($iteration % 2 == 1) {

   //  Our last iteration in the table was even

   //  Which means we need to close the table row

   echo "</tr>";

}



echo "</table>";

Good luck,
- Walkere

[zoliky]

Yahhooooo, thanks ! this help me a lot, work great