Re: Vexing PHP problem - browser hangs.

Be aware that $artist_list is an array (rows) of arrays (columns in each row).

For your version of php you need to first get the row with
$thisrow = pg_fetch_row($artist_list, $row)
and then get the fields from the row array with
$thisrow[0], $thisrow[1]...

See: http://us2.php.net/manual/en/function.pg-fetch-row.php

Cheers,
Steve

On Wednesday 16 July 2003 1:44 pm, Lynna Landstreet wrote:
> Hi folks,
>
> I'm running into trouble with a bit of PHP code that ought to be simple and
> probably is to anyone who actually knows what they're doing, but is causing
> my browser to hang every time I run it. The script in question follows;
> it's supposed to query the artists table in my database and print a list of
> all the artists, one per line, last name then first name. It also pulls up
> the artist_id field because once I've gotten the damn thing to work at all,
> I'm going to use that to link the names to artist info pages, but right now
> that field isn't being used.
>
> I know the connection to the database (which happens in the head section of
> the document, not here) is being made successfully, because I tested that
> on its own first. And the query is being made successfully, because I
> tested that to, before I added the code to display the artists' names. It's
> that part that is causing it to hang. I don't get any error message or
> anything, the browser just "thinks" for an eternity, locking up my system
> while doing so, until I eventually force-quit it.
>
> Does anyone have any idea what might be going wrong? There is a fairly
> large number of artist records (around 500), but I don't think that's it,
> because when I tried changing the second expression in the for statement to
> row < 30 instead of row < pg_numrows($artist_list) to just print the first
> 30 names, it didn't help. I'm hoping the problem is something simply that a
> more experienced person could see easily and I'm just missing because I'm
> new at this...
>
> Anyway, here's the code. BTW, the server has PostgreSQL 7.2 and PHP 4.1, so
> some of the names of the PHP functions are different than they would be in
> 4.2.
>
> <?
>
> // queries the database, finds artists
>
> $query = "SELECT artist_id, firstname, lastname FROM artists
> ORDER BY lastname";
> $artist_list = pg_exec($db, $query);
> if ($artist_list) {
>
> // checks to see if any results where found
>
> if ( pg_numrows($artist_list) == 0) {
> echo "<p>Sorry, no artists were found.</p>";
> } else {
>
> // writes list
>
> for ($row = 0; row < pg_numrows($artist_list); $row++) {
> echo "<p>" . pg_result($artist_list, $row,
> 'lastname') . ", " . pg_result($artist_list, $row, 'firstname') . "</p>";
> }
>
> // adds total to bottom of list
>
> echo "<p>Total results retrieved:" .
> pg_numrows($artist_list) . "</p>";
>
> }
>
> // prints error message if query fails
>
> } else {
> echo "<p>The query failed with the following error
> message:</p>";
> echo "<p>" . pg_errormessage($db) . "</p>";
> }
> ?>
>
> Thanks,
>
> Lynna