[RESOLVED] how could i put DESCRIBE info into an array ?

[steamPunk]

hi

I've seen that using DESCRIBE will return information about a database table but i was wondering how i could put that info into an array eg :

$fieldsArray = array("field_name" => $var, "field_type=>$var, etc... );

is there a standard way of doing this ?

thanks

[cahva]

I dont know any "standard" way but this should work nicely:

$sql = 'DESCRIBE tablename';
$res = mysql_query($sql);

$arr = array();
while ($r = mysql_fetch_assoc($res)) {
        $f = $r['Field'];
        unset($r['Field']);
        $arr[$f] = $r;
}

That will give you the array with Field as key and rest are value array. I think this is what u were after?

[steamPunk]

that's actually more sophisticated than what i had in mind - all i really need is

$sql = 'DESCRIBE tablename';
$res = mysql_query($sql);
$arr = array();
$f = 0;
while ($r = mysql_fetch_assoc($res)) {
	$arr[$f] = $r;
	$f++;	
}

it was the $r = mysql_fetch_assoc($res) bit that i wouldn't have got

many thanks !

[cahva]

Actually you can shorten that a little bit 🙂 :

while ($r = mysql_fetch_assoc($res)) {
    $arr[] = $r;
}

[steamPunk]

oops yes 😃
thanks again

[ahundiak]

If you really want short then:

while ($arr[] = mysql_fetch_assoc($res));

[steamPunk]

that's a new one on me !