Make assoc array from query results...

[RIRedinPA]

If I have a db with these fields: displayname, title

 

and I run a successful query on the db, will this code:

 

 

if (mysql_num_rows($results) == 0) {

return "!fail";

} else {

while ($row = mysql_fetch_assoc($results)) {

    extract($row);

}

 

return $row;

}

 

 

create an associative array of $var = array(array('displayname' => value, 'title' => value), array('displayname' => value, 'title' => value)...)

 

If not, is there a way to do so, especially when I will not know the names or number of fields in a db table?

[Pikachu2000]

This should work for ya.

$var = array();
while ($row = mysql_fetch_assoc($results)) {
        $var[] = $row;
}