--- whoisquilty <[EMAIL PROTECTED]> wrote: > The problem is that if they add a row to the title table, how can I call the > auto-incremented > titleid from the title table to relate their addition to the disc table to > the proper title. > > I can add to the database without problem. But I need to be able to find the > titleid to pass to > the disc creation form as a hidden variable. > > I'm absolutely stumped. Can anyone help? Or offer suggestions for a different > process?
Have you looked at mysql_insert_id() in PHP or last_insert_id() in MySQL? http://php.net/mysql_insert_id http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html James
