Posted by J.O. Aho on 12/28/06 19:48

Joja wrote:
>> You could have a column which is the userid and set it UNIQUE, before
>> inserting the image to the database, check if there is a such user, if not
> use
>> INSERT, if yes use UPDATE.
> -----------------------------------------
> hmmmm, this could be a bit of a problem or i have understand this wrong.
>
>
> signup form is in one window -- data is inserted into
> signup table
> upload page is loaded in second window -- data is inserted into picture
> table
>
> Problem is that the photo is uploaded to db, _before_ the user registration
> and then i can not know which photo belongs to which user....

Store the image temporarily on the harddrive with the session value and insert
it into the image table first after the registration is finished.

If I had been you, I had made a file-select option in the sign-up form, where
those who sign-up can select the image they want to upload, with other words
skip the sing-up-upload-page. If they would have selected the wrong image,
they can always change that, right?

--

//Aho

[Back to original message]