get the exact data and array format function as below

[raven1001]

Anyone knows how to put tables value into the array I shown below? For example my table is as below

name score sex

michael 80 m
michelle 70 f
james 90 m
hando 50 m

wat I want is to put all the value into the array format. The reason is I dun want to define the value in the array else I have to put more than hundreds data inside the array manually.

$aGraphData = Array
		(array('michael', 80, 'm'),
		array('michelle', 70, 'f'),
		array('james', 90, 'm'),
		array('hando', 50, 'm'),

	);

I hope I can get the solution as above... Thanks!

[Weedpacket]

How is your table stored?

[TheDefender]

This is very generic, not knowing all of the details about your table, but it gives you an idea...

// Setup your table's connection here, before you try to query it...
$getdata = mysql_query("SELECT * FROM table_name");
$ouputarray = array();
while($gotdata = mysql_fetch_array($getdata)) {
	$outputarray[] = array($gotdata['name'], $gotdata['score'], $gotdata['sex']);
}