Jump to content

[SOLVED] Database Entries Not Displaying


savagenoob

Recommended Posts

I am going crazy... I have a simple query below that should pull all the offices listed in the database, but it doesnt, it displays one, the first one in the database. I have tried numerous different ways but cant get it to pull all of them. There are 9 in the database, and only the one showing.

 

<?php
$agency = $_SESSION['SESS_AGENCY'];
$offices1 = mysql_query("SELECT * FROM offices") or die(mysql_error());
$offices3 = mysql_fetch_array($offices1);
$offices[] = $offices3['Office'];
print_r($offices);
?>

Link to comment
https://forums.phpfreaks.com/topic/175736-solved-database-entries-not-displaying/
Share on other sites

this is when you would use a loop

$offices3 = mysql_fetch_array($offices1);
$offices[] = $offices3['Office'];
print_r($offices);

becomes

while($offices3 = mysql_fetch_array($offices1)) {
     $offices[] = $offices3['Office'];
}
print_r($offices);

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.