2 questions

[________]

I got some questions about MySQL

1. When inserting data to a table, I often see this is done in two diffrent:
   • telleing what fields that is going to uses... like INSERT INTO tablename (field1, field2...) VALUES ('ha', 'ho'...)
   • but some tutorials is just inserting without defining the fields, eg. INSET INTO tablename VALUES('ha', 'ho'...)

What's the diffrence?

2. I have a picture upload script, where I store the link to the picture in a mysql table... the problem is that I need to name the picture with the same name as the id field (that is auto_increment).

I don't got a clue on this one... since the link must contain the name of the picture - and I have to name the picture the same as the id field... who do I do this?

It would be ok if the picture would be renamed... it's just important to notis that there may be many uploads at the same time - so that the pictures don't det mixed up!

Need all the help I can get!
Thanks!

[ahundiak]

1. Specifying the field names is alittle more work but you don't have to worry about the order matching the actual table layout. Both formats are equivalent.

2. After inserting a new record use $id = mysql_insert_id() to get the actual id. Then build your link or whatever.

[________]

Thanks!

There is only one thing that Im not sure about...
when using the mysql_insert_id() function - will it allways return the right value... what happens if more people submits a picture at the same time... will the function still work - or is there any danger that the id will be mixed up?

[ahundiak]

The id will be correct.

It's connection based meaing that even if two people do insert at the same time, they will be using different connections and you will always get the correct result.

Of course, you do need to call it before your next insert operation.

[________]

Thanks a lot!