Print Page - MySQL query to return users and categories

Title: MySQL query to return users and categories
Post by: dquelhas on September 02, 2006, 07:44:00 PM

Hello,

i was looking for the link between the users table, categories table and albuns table without success.
I want to make a query to return the usernames and their categories. Something like:

array(
user1 => 10003,
user2 => 10007,
etc.
)

Can someone help me?

Thanks in advance,

Dinis

Title: Re: MySQL query to return users and categories
Post by: Nibbler on September 02, 2006, 07:52:13 PM

The category is numbered as 10000 + user_id.

Title: Re: MySQL query to return users and categories
Post by: dquelhas on September 02, 2006, 07:54:42 PM

Thanks mate,

it's solved :)

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: dquelhas on September 02, 2006, 07:44:00 PM