MySQL Assist MySQL Assist
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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'.