Re: [PHP-DB] howto get PK id after INSERT??

2004-07-20 Thread John W. Holmes
Vincent Jordan wrote: I think I got it correct got the most part. I am having a problem with the urlencode function I believe. On page CustomerAddNew1.php ( page than handles form data ) im using: $last_id = mysql_query("SELECT LAST_INSERT_ID() from customerinfo"); $last_id is now a Result Reso

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-20 Thread jeffrey_n_Dyke
> I think I got it correct got the most part. I am having a problem with > the urlencode function I believe. > On page CustomerAddNew1.php ( page than handles form data ) im using: > $last_id = mysql_query("SELECT LAST_INSERT_ID() from customerinfo"); > $last_id = urlencode ($last_id); Why en

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-20 Thread Jason Wong
On Tuesday 20 July 2004 19:49, Vincent Jordan wrote: > I think I got it correct got the most part. I am having a problem with > the urlencode function I believe. > > On page CustomerAddNew1.php ( page than handles form data ) im using: > > $last_id = mysql_query("SELECT LAST_INSERT_ID() from custom

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-20 Thread Vincent Jordan
I think I got it correct got the most part. I am having a problem with the urlencode function I believe. On page CustomerAddNew1.php ( page than handles form data ) im using: $last_id = mysql_query("SELECT LAST_INSERT_ID() from customerinfo"); $last_id = urlencode ($last_id); header("Location:

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-19 Thread Larry E . Ullman
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

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-19 Thread Jason Wong
On Tuesday 20 July 2004 10:09, Vincent Jordan wrote: > 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? manual > MySQL Functions -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open S

[PHP-DB] howto get PK id after INSERT??

2004-07-19 Thread Vincent Jordan
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