I've searched & searched and haven't figured it out, any help is great!
I need to display certain fields from my table, right now it only displays the first row of the table. I need to display all rows in the table.
Code I have right now
$query = "SELECT name, desc, city FROM table";
$result = mysql_query($query) or die('Could not find info');
$row = mysql_fetch_array($result, MYSQL_ASSOC) or die('No records retrieved');
{
$name = $row['name'];
$desc = $row['desc'];
$city = $row['city'];
}
echo $name . "\n"
blah blah blah
How do you display all info from all rows in database table? I have an id for each row but id isn't used on this page. Thanks -Giggaman