I have a form on a webpage for a simple trouble ticket system. When
requesting a computer be fixed, software be installed, etc...a faculty
member can go to this website and type in the info via an HTML form.
My problem is, the form needs to be submitted to two different tables. All
of the faculty info(name, email, etc) goes into a faculty table. The actual
description of the request goes into a request table. But I also need to
insert the unique id that is given to the faculty member in the faculty
table INTO the request table. Because this is how I've related the two
tables. In the request table I have a foreign key(called requested_by) that
is the primary key of the faculty table. Is it possible for me to get the
primary key of the faculty table and insert it into the request table
through the same HTML form?
Thanks,
chriz
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
