first, make a function called query or something for pg_Exec ($conn, $sql);
in this example though you would do
$res = pg_Exec ($conn, $sql);
for($i=0; @$row=pg_fetch_array($res, $i); $i++) {
echo "$row[first] $row[last] <br><br>"
}
that will loop through the results. make sure your actual query statement is
correct though, the one below is not.
> -----Original Message-----
> From: Smileyq [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 7:53 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP+ postgresql help?
>
>
> Hey I'm new to php and using databases. I've setup a postgres server and
> have already populated the database. I'm able to connect the the server
> just fine with php my problem is showing the results. Can somebody show
> me a easy to understand example. For example. I've got a address book
> database setup. I want to be able to search for first names. I'm using
>
> $conn = pg_connect ("host=localhost user=username password=password
> bname=dbname");
>
> I then have a sql statement setup as such
> $sql = "SELECT * FROM database where lower('$name%') order by last;";
>
> I then execute the sql statement
>
> pg_Exec ($conn, $sql);
>
> Now I want to be able to diplay the results on a page no tables or forms
> just a simple output I'll work on layout later. I've trying to do so
> using. pg_result. If anybody could help me I would greatly appreciate
> it. Thanks guys.
>
> -Smileyq
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
