SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views
FROM pp_photos p
LEFT JOIN pp_categories c ON c.id=p.cat
WHERE c.password = ''
ORDER BY RAND()";
break;
}
It seems to be the RAND() that is causing the problem. Also, it is not picking up the correct prefix for the database name.
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.
See at
www.bm3w.co.ukSo now I have no idea why its trying to goto Chucks site, and is not displaying the thumbs...