[RESOLVED] MYSQL Data Into HTML Table Problem - Help?

[renaker]

I have a database full of categories, and I would like to show each one in an html table cell. I can't seem to figure out how to actually divide the results into cells.

EX:

<table width="741" border="0" cellpadding="3">
        <tr>
          <td width="239" height="100" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
            <a href="#" class="style1">'.$row['description'].'</a> 

      <td width="237" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
        <a href="#" class="style1">'.$row['description'].'</a>

      <td width="239" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
        <a href="#" class="style1">'.$row['description'].'</a>         
    </tr>
  </table>

I would like to show my results in a table like the one above. My problem is that when i use some code like:

$row = mysql_fetch_array($sql);
print_r ($row);

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

  echo'<table width="741" border="0" cellpadding="3">
    <tr>
      <td width="239" height="100" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
        <a href="#" class="style1">'.$row['description'].'</a> 

      <td width="237" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
        <a href="#" class="style1">'.$row['description'].'</a>

      <td width="239" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
        <a href="#" class="style1">'.$row['description'].'</a>         
    </tr>
  </table>';

}

It shows the same record 3 times in a row, and I can see why, I just don't see how to get around this problem. Does anyone here know how I would show X amount of records, one in a new cell every time, 3 cells to a table? So 9 records would produce 3 tables with 3 cells in each table, showing 9 records total. If I am not being clear enough please ask away. Thanks in advance. 🙂

PS: it doesn't have to be a new table, if you know how to make it so it generates a new row along with individual cell records, that would be cleaner, I just lack the logic behind this one, been trying to solve it for 3 hours or so, and thought it was time to ask for some advice.

[bretticus]

Each time you call mysql_fetch_array() you move the pointer ahead by one. Thus, you can just call mysql_fetch_array() inside of the loop when you need the next record. Just check for a record before attempting to print it. Your code will end up looking something like this:

<?php

$result = mysql_query($sql);

/*$row = mysql_fetch_array($sql);
print_r ($row);*/

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

echo'<table width="741" border="0" cellpadding="3">
<tr>
  <td width="239" height="100" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
    <a href="#" class="style1">'.$row['description'].'</a></td>';

	//fetch another record
	$row = mysql_fetch_array($result);		
	if ( $row !== false ) {	                     
		echo '<td width="237" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
		    <a href="#" class="style1">'.$row['description'].'</a></td>';	
	} else {
		echo '<td width="237" align="center" valign="middle">&nbsp;</td>';
	}

	//fetch another record
	$row = mysql_fetch_array($result);		
	if ( $row !== false ) {	                     
		echo '<td width="237" align="center" valign="middle"><img src="ccat/'.$row['picture'].'"/><br />
		    <a href="#" class="style1">'.$row['description'].'</a></td>';	
	} else {
		echo '<td width="237" align="center" valign="middle">&nbsp;</td>';
	}
echo '       
</tr>
</table>';

}
?>

[djjjozsi]

if you open a <td>, lets close that with a </td>...

anyway: lets try this

<?php
include("connect.php");
$query="SELECT * FROM `table`";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();
print $num;
if ($num > 0 ) 
{
	$i=0;
	echo '<table border="1">';
	while ($i < $num)   //this is the main loop
	{
		echo '<tr>';
		$o=3;
		while($o)  //lets start a 3 element with this loop
		{
			$picture = mysql_result($result,$i,"picture");
			$description = mysql_result($result,$i,"description");
			$id = mysql_result($result,$i,"id");
			if($id) //if the incremented $i value cause emty, lets print 2 an emty cell...
			{
				echo "<td>".($i+1).": $picture</td>";
				echo "<td> $description</td>";
			}
			else
			{
				echo "<td>$i: -</td>";
				echo "<td> - </td>";
			}

		$i++;
		$o--;
	} //3th element...while end

	echo '</tr>'; //that will make new rows in evry 3th elements...
} //main while end...
echo "</table>";
}  //if the select is emty...
else { echo "The database is empty"; 
}
?>

[renaker]

bretticus thank you so much for the fix, it works great! I tried your code out djjjozsi, but for some reason I couldn't get it to work. I'm still a novice at php, so maybe I was having a picnic. Still, thank you for helping. 🙂