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.marlowe@gmail.com]
Sent: Friday, January 02, 2009 10:28 AM
To: ioguix@free.fr
Cc: Marc Fromm; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] access data in php
On Fri, Jan 2, 2009 at 11:09 AM, <ioguix@free.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.