Hey guys,
I'm having a brain freeze...
I have a query, but it's only pulling ONE record from a table instead of ALL of the records from the table. Please help
$query = "select * from users ";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo "<br><br><a href=search.php?act=search>Click Here for Extended Search</a><br><br>";
while ($row = mysql_fetch_array($result)) {
echo "<table width=80% align=center border=1 cellpadding=0 cellspacing=0 bordercolor=999999>";
echo "<tr>
<td border=1 width=100><a href=".$row["cam_url"]."><img src=".$row["cam_url"]." width=100 border=0></td>
<td border=1 valign=top class=table-bg style=padding:10px;><b><h4>Username: ".$row["username"]."</b></h4><br><b>Location: </b>".$row["city"].", ".$row["state"]."<br><b>Category:</b> <i>".$row["category"]."</i><br><b>About:</b> ".$row["about"]."<br><h4>WEBSITE: <a href=".$row["url"]." target=blank>Launch Website</a></h4></td>
</tr></table>";
}
