note 29335 rejected from function.pg-query by rioter
| From: | rioter@php.net | Date: | Mon, 10 Feb 2003 15:00:44 +0000 |
| Subject: | note 29335 rejected from function.pg-query by rioter | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-43729@lists.php.net to get a copy of this message | ||
Hi i have created the data base CSGP13 in PostGreSQL. The Tabel name is BugReport and the table is
Layed out as follows:
Field Type
--------------------------------
BugID Serial
Finder varchar(4)
Bug Area text
Reason text
Datefound date
Remedy text
fixed bool
Fixed by varchar(4)
Verified varchar(4)
DateFixed date
My uestion is how whould u write the query for this in PHP that lists all records and how would 2
other queries one of all bugs fixed and one of all bugs not fixed.