How to create an array of MySQL result?

[fouwaaz]

Hello PHP gurus,

I have a select statement in MySQL that goes like this:

SELECT major_category_id, category_id, category_name from merchandise_categories;

This query returns around 100 rows.

Now I want to collect these result rows into a two-dimensional array -- is this possible?

Thanks & Regards
Fouwaaz

[nnichols]

You can do this -

$sql = "SELECT major_category_id, category_id, category_name from merchandise_categories";
$res = mysql_query($sql, $db);

while ($row = mysql_fetch_assoc($res)) {
$data[] = $row;
}

Hope this helps 😉