Re: access data in php

This is my code:
<?php
$dbconn = pg_connect("host=localhost port=5432 user=postgres dbname=studentalerts");

if(isset($_GET["value"])){
$w_number=$_GET["value"];
}
//echo $w_number;

$query = "select first_name, last_name, alert from alert_list where w_number='$w_number'";
$result = pg_query($dbconn,$query);
if (!$result) {
echo "Problem with query " . $query . "<br/>";
echo pg_last_error();
exit();
}

$rows = pg_fetch_assoc($result);
if (!$rows){
echo "There are no alerts for $w_number!\n\n";
}else{
$result = pg_query($dbconn,$query);
$count=1;
while ($row = pg_fetch_array($result)){
echo "Alert $count: ";
echo htmlspecialchars($row['first_name']) . " ";
echo htmlspecialchars($row['last_name']);
echo "\n";
echo htmlspecialchars($row['alert']);
echo "\n\n";
$count++;
}
}
if ($w_number==""){echo "Enter a W number!\n\n";}
echo "End of line";

pg_free_result($result);
pg_close($dbconn);
?>

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, January 02, 2009 10:28 AM
To: ioguix(at)free(dot)fr
Cc: Marc Fromm; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] access data in php

On Fri, Jan 2, 2009 at 11:09 AM, <ioguix(at)free(dot)fr> wrote:
> pg_fetch_assoc behave like pg_fetch_array: it increments the internal
> pointer to the current result.
> So if you call it once, then pg_fetch_array will return the 2nd result
> in the result set.

Wow, I'm so used to seeing

$rows = pg_num_rows() that that's what I saw up there.