Hi i want to pull info from a database like in the following example
[CODE]<table width=”90%” border=”0″>
<?PHP
$query = “SELECT * FROM speakers WHERE featured = ‘yes’ ORDER BY lname ASC”;
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
while ($row) {
print “<tr>”;
print ” <td align=”left”>”;
print ” <b><a href=”speaker-“.$row[‘id’].”-“.$row[‘fname’].”-“.$row[‘lname’].”.html”>”;
print $row[‘fname’].’ ‘.$row[‘lname’];
print ” </b><br>”;
print ” <img width=”30%” height=”30%” src=”speakers-photos/”.$row[‘photo’].”” alt=””.$row[‘fname’].” “.$row[‘lname’].”” border=”0″/></a>”;
print ” </td>”;
print “</tr>”;
$row = mysql_fetch_array($result);
}
?>
</table>
The above takes my info from the database and displays a new row in the table for each entry
however i want it to display 3 database entries per row instead of just one but all i can seem to do is display one entry per row or one entry per colum
any help please asap
thanks