Re: [PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Allen McCabe
You all are great! Thank you so much. On Wed, Oct 28, 2009 at 12:27 PM, Martin Scotta wrote: > > > On Wed, Oct 28, 2009 at 4:21 PM, Allen McCabe wrote: > >> Hey everyone, I have an issue. >> >> I need my (employee) users to be able to insert shows into the our MySQL >> database and simultaneous

Re: [PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Martin Scotta
On Wed, Oct 28, 2009 at 4:21 PM, Allen McCabe wrote: > Hey everyone, I have an issue. > > I need my (employee) users to be able to insert shows into the our MySQL > database and simultaneously upload an image file (and store the path in the > table). > > I have accomplished this with a product-ba

Re: [PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Floyd Resler
Allen, Use mysql_insert_id(). This will return the id of the last record inserted. Take care, Floyd On Oct 28, 2009, at 3:21 PM, Allen McCabe wrote: Hey everyone, I have an issue. I need my (employee) users to be able to insert shows into the our MySQL database and simultaneously uploa

Re: [PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Ashley Sheridan
On Wed, 2009-10-28 at 12:21 -0700, Allen McCabe wrote: > Hey everyone, I have an issue. > > I need my (employee) users to be able to insert shows into the our MySQL > database and simultaneously upload an image file (and store the path in the > table). > > I have accomplished this with a product

Re: [PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Mari Masuda
Maybe you could use http://us.php.net/manual/en/function.mysql-insert-id.php to get the inserted id. On Oct 28, 2009, at 12:21 PM, Allen McCabe wrote: Hey everyone, I have an issue. I need my (employee) users to be able to insert shows into the our MySQL database and simultaneously upload

[PHP] [php] INSERT and immediately UPDATE

2009-10-28 Thread Allen McCabe
Hey everyone, I have an issue. I need my (employee) users to be able to insert shows into the our MySQL database and simultaneously upload an image file (and store the path in the table). I have accomplished this with a product-based system (adding products and uploading images of the product), a