I have 4 CPGs and this code works on 3 of them. The only difference with the 4'th Gallery is it's bridged with phpBB2 and this code doesn't work at all.
<?php
define('IN_COPPERMINE', true);
require('include/init.inc.php');
$result = mysql_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE filename LIKE '%.jpg' ORDER BY RAND() LIMIT 5");
while ($row = mysql_fetch_array($result))
{
$type = max($row['pwidth'], $row['pheight']);
$list .= get_pic_url($row, $type) . "<br>";
}
echo $list;
?>
Just trying to pull out and display 5 random relative pic links. Any [obvious] reason it doesn't work with a bridged gallery or do I have another issue?
Solved - changed 'mysql_query' to 'cpg_db_query'.