MySQL, Perl CGI

[Philip Juels]

Hi all,

I'm developing a simple computer helpdesk system with MySQL as the
backend and Apache/CGI/Perl as the user interface. I've sucessfully
set up the part where a user enters an issue via HTML form and
"submits" it to the MySQL database. My question is: I have it set up
where the user posts the issue to the database, the database
auto_increments an issue_id number field. How do I return that
issue_id number back to Apache so that the user can see it (and use it
as a reference number)?

Thanks,

Philip Juels
pj****@rics.bwh.harvard.edu

[Philip Juels]

pj****@rics.bwh.harvard.edu (Philip Juels) wrote in message news:<4c**************************@posting.google. com>...

Hi all,

I'm developing a simple computer helpdesk system with MySQL as the
backend and Apache/CGI/Perl as the user interface. I've sucessfully
set up the part where a user enters an issue via HTML form and
"submits" it to the MySQL database. My question is: I have it set up
where the user posts the issue to the database, the database
auto_increments an issue_id number field. How do I return that
issue_id number back to Apache so that the user can see it (and use it
as a reference number)?

Thanks,

Philip Juels
pj****@rics.bwh.harvard.edu

Well, I figured it out using the MySQL command SELECT
COUNT(field_name) FROM table_name;.

[Philip Juels]

pj****@rics.bwh.harvard.edu (Philip Juels) wrote in message news:<4c**************************@posting.google. com>...

Hi all,

I'm developing a simple computer helpdesk system with MySQL as the
backend and Apache/CGI/Perl as the user interface. I've sucessfully
set up the part where a user enters an issue via HTML form and
"submits" it to the MySQL database. My question is: I have it set up
where the user posts the issue to the database, the database
auto_increments an issue_id number field. How do I return that
issue_id number back to Apache so that the user can see it (and use it
as a reference number)?

Thanks,

Philip Juels
pj****@rics.bwh.harvard.edu

Well, I figured it out using the MySQL command SELECT
COUNT(field_name) FROM table_name;.