i have set up a mysql db for storing news articles to be displayed within a flash website. i have now been asked if i could add an image upload function to this section.
i have created the upload page and i can upload the images to the db fine. the problem that i have is that when the image is uploaded it is put into its own row in the db. i need to be able to have the code find the last entry in the db and then update this entry with the image that is uploaded.
i would like to no if there is a function within mysql that can find the last entry. i have set the table up with an id which is auto incremented. i would like to no if i can find out what the last id number is and then update the row using the id number