Re: SQL query to array?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux