Check out Pear DB http://pear.php.net/manual/en/package.database.db.php
and adodb
http://adodb.sourceforge.net/
pete
Dan Joseph wrote:
Hi Everyone,
I'm trying to build a class to handle various SQL functions. One of them is to take a query, and return all rows. Here's what I have so far:
function selectRows( $sql )
{
$count = 0;
$results = mysql_query( $sql, DB::connect() );
$data = mysql_fetch_array( $results );
return $data;
}
Right now it only returns 1 row. I'm guessing this is how it should be, considering I haven't looped thru any other rows.
What I want to do is return something that holds all the rows,
however, I cannot see a decent way of doing this. I've played with putting
it into a new array, but I can't decide if that's the best way to do it.
Wondering if I could get some opinions on how you all would handle this?
-Dan Joseph
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
