SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views<br />FROM pp_photos p<br />LEFT JOIN pp_categories c ON c.id=p.cat<br />WHERE c.password = ''<br />ORDER BY RAND()";<br />break;<br />}<br /><br />It seems to be the RAND() that is causing the problem. Also, it is not picking up the correct prefix for the database name.<br /><br />If I hard code those, then we start to see something working, but rather than thumbs I get links to the pictures, but then it tries to link to Chucks website at reef.<br /><br />See at
www.bm3w.co.uk<br /><br />So now I have no idea why its trying to goto Chucks site, and is not displaying the thumbs...