William Stokes wrote:
Hello,
Can someone please help me to put the results of a query to an array. Never
done this before:
$sql = "SELECT sortteri,jouk_id,jouk_nimi FROM x_table ORDER BY sortteri
ASC";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$cur = 1;
//create empty array that contains an array before loop
$arr = array("Team" => array());
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$id = $row["jouk_id"];
$srt = $row["sortteri"];
$nimi = $row["jouk_nimi"];
//append values to the array
$arr = array("Team$cur" => array(0 => $id, 1 => $srt, 2 => $nimi));
$cur++;
}
Thanks
-Will
You might try this as an alternative:
$cur = 0;
while (list($id, $srt, $nimi) = $mysql_fetch_array($result)) {
$arr = array("Team{$cur}" => array(0 => $id,
1 => $srt,
2 => $nimi));
$cur++;
}
Jim
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php