dan2684 Posted May 30, 2011 Share Posted May 30, 2011 Hello All, What's the best way to generate a unique image name? My initial thought was to use the time() but I'd rather use something more relevant to the actual image. I know you can use mysql_insert_id() but surely this means adding all information apart from the image name to the database, getting the insert id and then returning to the database again with the unique image name... Is there a way of using the current insert id? Thanks, Dan Quote Link to comment Share on other sites More sharing options...
fugix Posted May 30, 2011 Share Posted May 30, 2011 I don't fully understand the question. But if you are trying to create unique rows. You can add an Id field and set it to auto-increment primary key Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted May 30, 2011 Share Posted May 30, 2011 If the image name IS based on the auto-increment id, you don't need a separate column to hold the image name. The existing id column already contains the information you need. Quote Link to comment Share on other sites More sharing options...
dan2684 Posted May 30, 2011 Author Share Posted May 30, 2011 Again, one of those situations where I'm not thinking properly. Classic example of having all the tools but not knowing how to use them! PFMaBiSmAd - I can't believe I've never thought of that before. I've been using an "image name" column in my applications for about 3 years!!! Thanks a lot guys. Much appreciated! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.