Hello all,
This is beginning to annoy me now.
I've tried many different ways but to no avail.
At the moment i'm successfully placing two results from my query over two HTML columns from a table.
What i'm wanting to do is place it over three columns instead of two.
Can anyone give me some pointers?
Here's the code:
<table cellpadding="5" cellspacing="0" border="0">
<?
$result = mysql_query("SELECT * FROM ladies WHERE status = 'yes' ORDER BY first_name, last_name");
$total = mysql_num_rows($result);
$count = 0;
while ($row = mysql_fetch_array($result)) {
$lady_id = $row["lady_id"];
$first_name = $row["first_name"];
$last_name = $row["last_name"];
$list_pic = $row["list_pic"];
$new = $row["new"];
if($count == 0){
if($new == 'yes'){
echo "<tr><td><img src=\"images/$list_pic\"> <a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a> <img src=\"images/new_flash.gif\"></td>";
} else {
echo "<tr><td><img src=\"images/$list_pic\"> <a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a></td>";
}
$count = 1;
} else {
if($new == 'yes'){
echo "<td><img src=\"images/$list_pic\"> <a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a> <img src=\"images/new_flash.gif\"></td></tr>";
} else {
echo "<td><img src=\"images/$list_pic\"> <a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a></td></tr>";
}
$count = 0;
}
}
?>
</TABLE>
Cheers,
micmac
