MYSQL Query Result to Arrays

[system]

Hi… How do you insert MYSQL Query Result to Arrays?

[php]$user = $_GET[“user_name”];
$con=mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); }
$result = mysqli_query($con,“SELECT data1, data2, FROM datatable”);
while($row=mysql_fetch_array($result)){
echo $row[‘data1’];
echo $row[‘data2’];
echo $row[‘data3’];
}

$row[] = “data1”;
$row[] = “data2”;
$row[] = “data2”;
$xls->addRow($row);

or multidimentional array

$row = array();
$row[] = array(0 =>‘data1’, 1=>‘data2’, 2=>‘data3’);
$xls->addRow($row);[/php]

[ttbakiatwoam]

[php]$result = mysql_query(‘SELECT ID, FirstName, LastName FROM Users’);

$data = array();
while ($row = mysql_fetch_assoc($result)) {
$id = array_shift($row); // Shifts first element
$data[$id] = $row;
}[/php]

try something like that!

[JimL]

This is a duplicate thread, should be merged with:
http://www.phphelp.com/forum/general-php-help/mysql-query-result-to-arrays/