// connect to the database $connection = pg_connect("localhost", "5432", "olivebranch"); if($connection) { $query = "SELECT distinct category FROM member"; $result = pg_exec($connection, $query); if($result) { print("Category:
\n"); print("
--- All Categories ---\n"); for($row = 0; $row < pg_NumRows($result); $row++) { print("
"); print(pg_result($result, $row, 0)); print("\n"); } pg_freeresult($result); } print("
\n"); pg_close($connection); } print("
"); print("
Company Name:
"); print("
\n
"); print("
Starts with
"); print("
Ends with
"); print("
Contains
"); print("
"); print("
"); print("
Contact Name:
"); print("
\n
"); print("
Starts with
"); print("
Ends with
"); print("
Contains
"); print("
"); print("
"); print("
Results per Page:
"); print("
\n
"); print("
"); ?>