Getting a list of bugs

[Mark Ingram]

Hi,

ive been trawling through the buglist.cgi this morning and i cant see a
simple way of just displaying a list of bug IDs.
I thought i could get some code base from the above file but i cant work out
where it actually does the selecting.

Basically all i want todo is run this query:
SELECT bug_id, short_desc, product_id FROM bugs WHERE bug_status='RESOLVED'
AND bug_resolution='FIXED' ORDER BY delta_ts DESC

Then using a template i will display the bug ids in a list.

Can anyone point me in the right direction or give me a helpful tip on howto
get a couple of details out of the DB?


Best Regards,

Mark Ingram
Software Engineer
Nexsan Technologies
33 - 35 Parker Centre
Mansfield Road
Derby
DE21 4SZ