On Monday 16 December 2002 01:22, drparker wrote:
This is the type of question that is best asked on the php-db list.
> I'm adding information with the INSERT command to 2 tables. In the
> first table, called "courses", I have a field called "course_id" that is
> an auto-increment - assigned by the table. In the second table, called
> "par", I have a field also called "course_id". I need to assign to
> this field the value that is assigned for "course_id" in the "courses"
> table. The problem is, I don't know what it is going to assign, and I
> can't get the variable with a query such as "SELECT * FROM counties
> WHERE course_id = ##" because I don't know what number is going to be
> assigned as the course_id. Basically, I need to store the that
> course_id value of the course I just added in a a variable, and I don't
> know how to retrieve that variable.
If you're using MySQL you can use mysql_insert_id(). If you're using some
other DBMS then have a look at the manual to see whether there is a similar
function.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Pardo's First Postulate:
Anything good in life is either illegal, immoral, or fattening.
Arnold's Addendum:
Everything else causes cancer in rats.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
