Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] a more eloquent PostgreSQL/PHP version of MySQL/PHP routine From: Doug Semig (dougslist <email protected>)
Date: 12/03/00

How about something like this?

        $query = "select * from something";
        $result = pg_exec($database,$query);
        $tbNumRows=pg_numrows($result);
        for ($tbCount = 0; $tbCount < $tbNumRows; $tbCount++) {
                $row = pg_fetch_array($result,$tbCount); # or could use fetch row
                # do whatever with your row/result
        }

The only reason I can think of to nest the do/while within an if for your
MySQL solution is so you can have an else on the if to do something if no
rows were returned. (Read that sentence to your grandma and see if she
thinks your still human!)

If you don't have to do anything if no rows are returned, then this might
be more efficient (please forgive me, though, if it is wrong...I haven't
used MySQL in a long time and am only going on memory):

        $query = "select * from something";
        $result = mysql_query($query);
        while ($row = mysql_fetch_array($result)) {
                # do whatever with your row
        }

Doug

At 02:41 PM 12/3/00 -0500, Dave VanAuken wrote:
># the following has worked well with MySQL.
># assume $database contains previously designated connection.
>
> $query = "select * from something";
> $result = mysql_query($query);
> if ($row = mysql_fetch_array($result)) {
> do {
> # do whatever with your row
> } while ($row = mysql_fetch_array($result));
> }
>
>
># using the same syntax causes a number of errors with PostgreSQL.
># have had to resort to the following.
># assume $database contains previously designated connection.
>
> $query = "select * from something";
> $result = pg_exec($database,$query);
> if(pg_numrows($result)>0) {
> $tbNumRows=pg_numrows($result);
> $tbCount=0;
> while($tbCount<$tbNumRows) {
> $row = pg_fetch_array($result,$tbCount); # or could use fetch row
> # do whatever with your row/result
> $tbCount++;
> }
> }
>
>
># would appreciate any insight into streamlining the PostgreSQL code a
>little more
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>