savagenoob Posted September 27, 2009 Share Posted September 27, 2009 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 More sharing options...
Zane Posted September 27, 2009 Share Posted September 27, 2009 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); Link to comment https://forums.phpfreaks.com/topic/175736-solved-database-entries-not-displaying/#findComment-926102 Share on other sites More sharing options...
savagenoob Posted September 27, 2009 Author Share Posted September 27, 2009 OMG yes i knew i was dumb... thanks. Link to comment https://forums.phpfreaks.com/topic/175736-solved-database-entries-not-displaying/#findComment-926106 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.