Formatting Results Question

[RobinR]

Hi Guys,

I have this:

$query="SELECT * FROM table_name ORDER BY Surname ASC ";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

echo "<table><tr><td>";

$i=0;
while ($i < $num) {

$firstname=mysql_result($result,$i,"Firstname");
$surname=mysql_result($result,$i,"Surname");

echo "
<a href=\"test.php?name=$firstname $surname\"><b>$surname, $firstname</b></a><br>";

$i++;
}

echo "</td></tr></table>";

Which outputs a list of names from a MySQL database, I'd like to format it into a table so I have 2 or 3 columns, any ideas on how to achieve that.

Thanks in advance,

RobinR

[roscor]

This (untested) will display records from your database, along with giving alternate row colours which makes it easier on the eye,

hope this helps

roscor

<?PHP
$query="SELECT * FROM table_name ORDER BY `Surname` ASC ";
$result=mysql_query($query);
$num=mysql_num_rows($result);

if ($num==0) {
$empty = "No Matching";
}
 else
  {
$num_rows = mysql_num_rows($result);
}

mysql_close();

?>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="centre" >
<tr>
    <td align="centre"><? echo $num_rows; ?><? echo $empty; ?>&nbsp;&nbsp;Records Found</font></td>
    </tr>  

  </table>

 <br>



<table width="600" border="0" cellspacing="0" cellpadding="0" align="centre" >
<tr>
	<td width="50%" align="center">Firstname</font></td>
	<td width="50%" align="center">Surname</font></td>	
	</tr>
</table>

<tr>
      <td width="600" height="20" valign="top">


<div class="scrollable" style="height:100px; width:100%; overflow:auto;">

<table cellSpacing="0" cellPadding="1" border="0" width="100%" height="20">
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
</tr>

   <?PHP
$i=0;

while ($row = mysql_fetch_array($result)) {
//if ($foo % 2 )
if($i % 2)
{
$bg_color = '#FFFFFF';
}
else
{
$bg_color = '#EEEEEE';
}

$surname = $row["surname"];
$firstname = $row["firstname"];
?>

<td><? echo "<td width='50%' align='center' bgcolor=$bg_color>$fistname"; ?></td>
  <td><? echo "<td width='50%' bgcolor=$bg_color align='center'>$surname</td>"; ?></td>


</tr>
<?
$i++;
}
echo "</table>";

?>

[bpat1434]

I think the user wants to have a table that lists the names in 2 or 3 columns, not the first name in one and last name in another.

If you want to have multiple columns of names, search the forums for Vertical / Horizontal Table. I've already posted the code for something very similar multiple times.

Horizontal/Vertical Looper
Horizontal / Vertical Looper Function