[PHP-DB] PHP+ postgresql help?

[Smileyq]

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]

Re: [PHP-DB] PHP+ postgresql help?

[speedboy]

 $conn = pg_connect (host=localhost user=username password=password 
 bname=dbname);
 
 $sql = SELECT * FROM database where lower('$name%') order by last;;
 
$result = pg_exec($conn, $sql);

for ($i = 0; $i  pg_numrows($result); $i++) {
$row = pg_fetch_array($result, $i);
echo pre;
print_r($row);
echo /pre;
}


-- 
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]

Re: [PHP-DB] PHP+ postgresql help?

[Ted Rolle]

print_r?  Am I about to learn something new?  Be still, my beating heart!

On Tue, 21 Aug 2001, speedboy wrote:

  $conn = pg_connect (host=localhost user=username password=password
  bname=dbname);
 
  $sql = SELECT * FROM database where lower('$name%') order by last;;
 
 $result = pg_exec($conn, $sql);

 for ($i = 0; $i  pg_numrows($result); $i++) {
   $row = pg_fetch_array($result, $i);
   echo pre;
   print_r($row);
   echo /pre;
 }


 --
 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]