[RESOLVED] Creating Array

[sheephat]

Good Evening All (its now 22:10 here):

Can someone please help me out with an array, im tring to insert all the table names off a database into an array, i only know how to use a loop to echo them our and am having trouble with getting them all in an array.

Something i have not yet covered.

Thanks for all your help.

[cahva]

Well its almost the same as with any other sql statement:
(Im assuming you use mysql)

$sql = "SHOW TABLES";
$result = mysql_query($sql);
$tables = array();
while($row = mysql_fetch_row($result)) {
    $tables[] = $row[0];
}

[sheephat]

Resolved, Thank You.