Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: MySQL Assist  (Read 2698 times)

0 Members and 1 Guest are viewing this topic.

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
MySQL Assist
« on: March 30, 2007, 03:34:53 pm »

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. 

Code: [Select]
<?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?
« Last Edit: April 02, 2007, 08:39:41 am by GauGau »
Logged

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
Re: MySQL Assist
« Reply #1 on: March 30, 2007, 06:39:24 pm »

Solved - changed 'mysql_query' to 'cpg_db_query'.
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.