How to retrieve info from DB

[David Miller]

On 2/20/2004 2:23 PM -0500, Jeet Shangari wrote:

> Actually I was looking through code of Bugzilla application and I need to
> customize this software as per my company's requirement. For that I need to
> make change in MySQL database. But I m unable to find out the way that How
> existing application retreiving info from database to perl script. Suppose I
> want to retrieve info from Products table, wht are the steps I need to
> follow to do that?

The answer to this question is more of knowing how Perl interacts with
databases.  If you have Bugzilla 2.17.x, we're using the standard DBI stuff
(read the docs for the DBI Perl module).  In 2.16.x, we're also using DBI,
but there's several "wrapper" functions in globals.pl that try to hide some
of it.

Learning how to use a database from Perl is beyond the scope of this list.
I would suggest the dbi-users list at perl.org for that.  But read up on
the docs first before going there for help.
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/