Re: howto get PK id after INSERT??
| From: | Larry E . Ullman | Date: | Tue, 20 Jul 2004 02:26:16 +0000 |
| Subject: | Re: howto get PK id after INSERT?? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35396@lists.php.net to get a copy of this message | ||
I have a form to insert customer data into a table. The form goes to php page to input data to db hen uses header to go to a final page displaying customer's information. Is there a way to get the ID (custid PK UNIQUE AUTO_INCREMENT) from mysql after INSERT then pass to final page using urlencode to pull cust record?Use the appropriately named mysql_insert_id() function. Larry