On May 13, 2008, at 6:35 AM, Sanjeev N wrote:
fetchAll() works if php version is greater than 5.
As Wang suggested, we should write our own function.
its easy... i have done so many times for larger database.
Store earch rows of the resultset in the array (multidimensional ie.
2). and
then work on the array using the loops & conditions
$query = "select * from tablename";
$result = mysql_query($query);
while($arr = somefunction($result)){
$resultarray[] = $arr;
}
Hope it works!
Here's a way to get a 2-dimensional array of results that you can loop
through when needed. Don't know if it's what you need, but it's useful
when you have more than 1 row as a result.
<?php
function fetchObjectsAsArray ($sql)
{
$result = mysql_query ($sql);
if (!$obj['count'] = mysql_num_rows ($result)) { return null; }
while ($rows[] = mysql_fetch_array ($result)) { }
foreach ($rows as $array) {
foreach ($array as $field => $value) {
$obj[$field][] = $value;
}
}
return $obj;
}
?>
Have fun!
~Phil
On 5/13/08, Forcey <forcey@xxxxxxxxx> wrote:
I guess PDOStatement::fetchAll() should work?
see http://www.php.net/manual/en/pdostatement.fetchall.php for
details.
- Forcey
On Tue, May 13, 2008 at 9:55 AM, Yi Wang <wangyi6854@xxxxxxxxx>
wrote:
I think flance's meaning is whether there is a build-in function
that
can convert the result set to an array.
The short answer is: do it yourself.
On 5/12/08, Stut <stuttle@xxxxxxxxx> wrote:
On 12 May 2008, at 15:56, It flance wrote:
is there any function that can convert the result of query to an
associative array?
what i want is the following:
$query = "select * from tablename";
$result = mysql_query($query);
$arr = somefunction($result);
where $arr should be an assoiative array whose indices have the
same name
as the fields names of table tablename.
http://php.net/mysql_fetch_assoc
Please please please read the manual: http://php.net/mysql
-Stut
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
