Re: PHP+ postgresql help?
| From: | speedboy | Date: | Tue, 21 Aug 2001 03:14:34 +0000 |
| Subject: | Re: PHP+ postgresql help? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11580@lists.php.net to get a copy of this message | ||
> $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>";
}