Moving to next Record

[nomz]

Hello,

I have this script which is picking the records from database and displaying in 3 Coulmns on a page.

It displays the first three records but when moves to next row, skips one record and then starts a new row.

	<?php
	include 'conn.php';
	$result=mysql_query("select * from main_categories where catstatus=1", $db);

print("<table>");
$record_column = 0;
while($query_data = mysql_fetch_array($result)){
		$catid=$query_data['catid'];
		echo $catid;		
   if($record_column <3){
      if($record_column == 0)
	  {
		  print("<tr>");
	  }
      print("<td><b>" .$catid.$query_data['catname']."</b></td>");
	$record_column++;
   } else {
   print("</tr>");
	  $record_column = 0;
   }

} 
?>[code=php]

------------------
plllllllllllllllllllllsssssssssssss help meeeeeeeeeeeeeeee :rolleyes:

[sid]

 
<?php 

include 'conn.php'; 
$result=mysql_query("select * from main_categories where catstatus=1", $db); 

print("<table>"); 

$record_column = 0; 

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

  $catid=$query_data['catid']; 
  echo $catid; 

  if($record_column % 3 == 0) { 
    print("<tr>"); 
  } 

  print("<td><b>" .$catid.$query_data['catname']."</b></td>"); 
  $record_column++; 

  if($record_column % 3 == 2) { 
    print("</tr>"); 
  } 

  $record_column++;
} 

print("</table>");
?>

[ahundiak]

And just for completeness you might want to close the tr element when the number of records is not a multiple of 3.

}
if (($record_column % 3) != 0) {
  echo "</tr>\n";
}

[sid]

speaking of completeness...

}
if (($record_column % 3) != 0) {
  for ($x = 0; $x < $record_column; $x++) {
    echo "<td>&nbsp;</td>\n";
  } 
  echo "</tr>\n";
}

:p