Display Data without While Loop

[Dysan]

Can data in the database be displayed without using a while loop. Obviously only one record will get displayed.

 

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM details");

while($row = mysql_fetch_array($result))
{
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
}

[alecks]

If you know there is only one row that you are getting (if query is something like '.... WHERE `id` = [specific id]', or you know for certain that your table only has one row) then you can just do

 

$result = mysql_fetch_array(mysql_query("SELECT * FROM `details`"));
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";

 

otherwise you need the while() to loop through all the rows.

[Dysan]

well I using a for loop to display all the records, if a condition is true. How do I display the data from the database now?

 

oreach ($contents as $id=>$qty)
{
}

[alecks]

If there are multiple rows of data, then you need to use the while loop.