MySQL query to return users and categories MySQL query to return users and categories
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

MySQL query to return users and categories

Started by dquelhas, September 02, 2006, 07:44:00 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

dquelhas

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

Nibbler


dquelhas