Quickies, by Andrea Olivato

How to export to an array a MySQL query with 3 lines of code

codepuzzling:

By reading a good contribution on PHP site, I discovered this method for exporting to an array a query submitted to MySQL:

$result = mysql_query("SELECT * FROM table");
for($i = 0; $array[$i] = mysql_fetch_assoc($result); $i++) ;
array_pop($array); // removes last empty array

It produces:

Array
(
    [0] => Array
        (
            [id] => 1
            [user] => myuser
            [pass] => mypass
            ... other fields
        )
    ... and so on

That’s to say you’ll have count($array) records, of which every row has count($array[0]) fields.