Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Cat Details From Database  (Read 2334 times)

0 Members and 1 Guest are viewing this topic.

ian ditch

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Cat Details From Database
« on: December 05, 2005, 01:34:48 am »

Sorry for reffering to an old post but I've hit a brick wall and I need your help.

I asked a question HERE and was given the answer which did help me out, however, what I want to do now is to show the same info (user_name etc) but on the 'Home > User galleries' page.

In the address bar this is a 'cat=' and not 'album="

Previous Answer
Quote
$aid = (int) $_GET['album'];
$result = db_query("SELECT u.* FROM {$CONFIG['TABLE_USERS']} AS u INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.category - " . FIRST_USER_CAT . " = u.user_id AND a.aid = '$aid'");
$user = mysql_fetch_assoc($result);
print_r($user);

Please help
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.