insert file name as +1 grater than last ID

[erdem]

hi guys.

 

I hope I can explain.

 

I'm uploading file and I'm inserting some info from the file into mysql.

 

I want to rename the file grater then my latest file ID.

 

so i did this.

 

mysql_query("INSERT INTO replay (ReplayID, Version, Map, GameLenght, TeamSize, Realm, PlayedTime, Location, Uploaded) VALUES 
                                (NULL, '".$Version."', '".$Map."', '".$GameLenght."', '".$TeamSize."', '".$Realm."', '".$PlayedTime."', '".$FileName."','".time()."')")or mysql_error();
                 
                $FileName = mysql_insert_id().'.SC2Replay';               
                move_uploaded_file($tmpname,"Replays/" . $FileName);

 

as you can understand in the database Location is empty.

 

how can I do this?

[sunfighter]

Your inserting the $FileName into Location and then defining the $FileName. Why not define it before the query?

[kicken]

how can I do this?

 

Put a NULL in that field during the insert, then after you get the ID and move the file run an UPDATE which changes it to the actual value.

 

Why not define it before the query?

 

Because he has to run the query before he can get the insert id that is used to generate the file name.

 

[ManiacDan]

You could also use uniqid() to generate a unique filename every time, to be used in the file and in the query, without performing two queries.

 

-Dan

[erdem]

thanks for your answers.