MySQL - Select Specific Row Based On Unique IDMar 7, 2007
I am building a photography website in html, and have a pre-formated table in which i want to put a thumbnail pic, the date of the pic, the name, and links to different sizes of the image. In a MYSQL database i have a table with four columns: ID (INT, auto-increment), ImageName (VARCHAR), FileName (VARCHAR), Date (VARCHAR).
I'm just getting started with PHP, and i want to either:
have the information automatically inserted into my pre-made table via a php loop command
write a script which will allow me to only enter the id# and will subsequently insert the name and the date into my table, and which might display the image of the filename.
I hope this is clear enough, I've bought quite a large book on PHP and have been browsing forums in an attempt to learn, but i can't find an example that inserts it into a pre-existing table.