[glazzaro]

Chuck

I am sure its maybe the way I am formating the line, however it still does not work. I have changed every occurrence I could find in that function. Here is what I have done:

function display_gallery($q_switch, $showuser="", $showcat="", $overcol=0, $overnum=0, $ispal=0) {

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 AND storecat=0 ORDER BY date DESC LIMIT $grabnum";

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 AND storecat=0 $userq $catquery ORDER BY date DESC LIMIT $grabnum";

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 AND storecat=0 ORDER BY views DESC LIMIT $grabnum";

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 AND storecat=0
$userq $catquery ORDER BY views DESC LIMIT $grabnum";

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width, id*0+RAND() as rand_col FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 ORDER BY rand_col DESC LIMIT $grabnum";

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,height,width, id*0+RAND() as rand_col FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat != 528 $userq $catquery ORDER BY rand_col DESC LIMIT $grabnum";