Getting Started with PHP's HTML_QuickForm
Subject:   MySQL Table to PHP Array
Date:   2006-02-12 13:06:35
From:   jgbutler
I'm sure there's a simple way to do this, but I'm such a newbie I can't figure it out...

I'm enjoying making my first HTML_QuickForm form, but I'm having trouble populating an array to use with $form->addElement('select'). I tried using the following code to pull data from a simple, 2-field MySQL table and insert it into an array named $genres, but all I get is the very first row of data. Can you clue me in as to how to get the other rows to cooperate?


mysql_select_db($database_tifrl, $tifrl);
$query_rsGenre = "SELECT * FROM genre";
$rsGenre = mysql_query($query_rsGenre) or die('Query failed: ' . mysql_error());
$ar_genre = mysql_fetch_array($rsGenre, MYSQL_ASSOC);
$genres = array ($ar_genre['genreID'] => $ar_genre['category']);