ok, here's what i'm trying to do:
I have a field in my database for storing an image name to be pulled out with PHP to display that image on a website.
the syntax for each value will be 'pets_1.jpg' the next will be pets_2.jpg and so on up until 'pets_301.jpg' or so then the suffix will change to 'hf', so the first will be 'hf_1.jpg' all the way up to 'hf_257.jpg' and then the suffix will change again, and so on....Does anybody know a way that I can run a query to automatically generate the filename rather than typing it in line by line?? obviously i would need to run a new query each time the suffix changes and put in the starting and ending value on each query. the primary key is a bog standard auto increment value.
Here's hoping somebody can point me in the right direction