I came across this script from evilwalrus
Code: Select all
<?
$result = mysql_query (SELECT * FROM table);
if ($row = mysql_fetch_array($result)) {
for ($i = 0; i < count($row); $i++) {
// Set Table Row Color
if ($i % 2) {
echo "<tr bgcolor=B0C4DE>";
} else {
echo "<tr bgcolor=FOF8FF>";
}
// Now display our table cell info
?>
<td><? echo $rowї"whatever"]; ?></td>
</tr>
<?
} else {
echo "<tr bgcolor=B0C4DE><td>Sorry, no records were found!</td></tr>";
}
?>Code: Select all
<TABLE><TR><TD align=center>Title</TD></TR></TABLE>
<TABLE><TR><TD>Username: </TD></TR></TABLE>
<TABLE><TR><TD>Date: </TD></TR><TABLE>
<TABLE><TR><TD>Tel: </TD></TR></TABLE>
<TABLE><TR><TD>Website: </TD></TR></TABLE>
<TABLE><TR><TD>Price: </TD></TR></TABLE>
<TABLE<TR><TD>Email: </TD></TR></TABLE>
<TABLE><TR><TD align=center>Ad Description</TD></TR></TABLE>Code: Select all
<td><? echo $rowї"whatever"]; ?></td>
</tr>Thanks