MySQL Assist MySQL Assist
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

MySQL Assist

Started by rphMedia, March 30, 2007, 03:34:53 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

rphMedia

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?

rphMedia

Solved - changed 'mysql_query' to 'cpg_db_query'.