Images, database and other fun stuff

[Anon]

I'm working on a PHP message board right now where users can have images related to them. I made a registration page with a "file" type field in it where users can select the image they want on their pc and upload it to my server where it is stored a a folder. What I wanna do, is give the image the same name as the user's unique Id, thus making it impossible to have image name conflicts. In order to do so, I must insert the new user, then select is ID, and then update the Image field (I keep a link, not the file itself in that field) for that user. That's 3 query on the database. I'm looking for a faster way to do it. Thanks

[Anon]

if you are using the copy() function, just specify that the destination file is the same name as the username.

copy($image, "$username.gif")

[Anon]

My problem is with getting the username. I end up doing a total of query, one to create the user, one to select the id of the user i just created (since it's an auto-increment field) and one to update the image field in the table to be the same as is id:
insert into users;
select id from users where = ...;
update image from users where id =id above;