Echoing everything from the Database

[dean7]

hi all, I have a piece of code which I coded where it selects all there cars out of the database and shows them, well it is meant to:

 

$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");
$gotall = mysql_fetch_object($getall);

echo "$gotall->car  - $gotall->id<br />";

 

Its meant to echo out all the cars which the user own, but for some reason its only echoing one car.

 

Can anyone see why its only showing one car with the id not all the cars they own?

 

Thanks.

[Skewled]

You have to use a loop..

 

 

<?php

$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");

while($row = mysql_fetch_array($getall)){
echo $row['car']. " - ". $row['id'];
echo "<br />";
}
?>

[dean7]

You have to use a loop..

 

 

<?php

$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");

while($row = mysql_fetch_array($getall)){
echo $row['car']. " - ". $row['id'];
echo "<br />";
}
?>

Thanks, that worked

[Skewled]

Your most welcome.