Making this a multidemensional array?

[Perad]

Hey, can someone help me turn the following code below into a multidimensional array like the following.

 

$this->field

- Name

- Type

- Length

 

I just can't get my head around it.

 

$sql = "DESCRIBE $table";		
	$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)) {
$this->field[] = $row['Field'];
// Separate Length From Type
$type = $row['Type'];
$values = array("(", ")");
$split = str_replace($values, " ", $type);
$explode = explode(" ", $split);
// End
$this->type[] = $explode[0];
$this->length[] = $explode[1];
}

[rajivgonsalves]

Some code which might help

 

$sql = "DESCRIBE $table";		
	$result = mysql_query($sql);


while($row = mysql_fetch_assoc($result)) {
// Separate Length From Type
$this->field[] = $row['Field];
$strTemp = $row['Type'];
preg_match("#(\w+)\(\d+)\)#",$strTemp, $arrMatches);

$this->type[] = $arrMatches[1][0];
$this->length[] = $arrMatches[1][1];

}