I have a mysql database that has these fields id picfile piclink approved
Normally I do every thing using the id. I am looking to randomly get four images that are marked approved being that approved is true. I want the four picfile or piclink one being the file on my server the other being an http:// reference. I want the four random images or picfile, piclink to be placed in four variables
each time I call the routine... I do not want to unapproved ones and of course I need to stay with in the maxium number that the id is up to. Basically I am looking to grab four fields from a column not a row and assign them to a variable if the corresponding row approved field is true...
Any help would is thanked in advance.