query with array for a option select

[Anon]

Hello, I'm trying to write a dinamic "select option" script that print all field into it from a mysql database! Thanks!

This is the code:

<? // ARTIST DATA
require ("../../connection.php");

    // connect db

    $db=new database();
    $query=$db->newQuery();


 $query->run("SELECT fs,genere FROM playlist WHERE fs='1'");
    while(list($fs,$genere)=$query->getNextRow()){

	$sez=array("$genere"=>"$genere"); }

	if (is_array($sez)){
	echo"<select name='[sez]' class='testoform' style='font-size: 10px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;' onChange='CambiaPlay(this.value);'>";
	while(list ($key, $value) = each($sez)){
		echo"<option value='$key'>".ucwords($value)."</option>";
		}
	echo"</select>";

}

    $query->free();
    $db->close(); 
?>

[Anon]

so... what's the problem?

[Anon]

Excuse me! Selected only one field from the database!
Japp.

Craig H wrote:

[Anon]

well, without knowing your database structure, it is difficult to know exactly the problem, but I suspect that your SQL (which includes this: WHERE fs='1') could be the reason. Have you tried the SQL statement on the command line to see if you get more than one row?