Yeah, just have your backend script parse the info it needs and just call
two queries to make that happen.
On Fri, 16 Feb 2001, Chris Toth wrote:
> 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
>
---------------------------------------------------------------------
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