How on Earth to MySQL this....

listenmirndt

I have two tables

USERS
ID,USERNAME,OPTIONS

ENTRIES
ID,ENTRYID,USER

<?PHP
$table = ENTRIES;
$sqlcount = "SELECT count(Distinct USER) AS COUNTUSERS FROM $table";
$rescount = @($sqlcount);
$rowcount = @mysql_fetch_row($rescount);
?>

What I need to be able to do... is count the number of users in the ENTRIES table (distinct)

but ONLY where the USER table in ENTRIES matches the USERNAME table in USERS - AND - the OPTIONS table in USERS equals "1"

Phew...
I can't wrap my head around this one and I don't know about about MySQL...
can anybody help with this? if it's even possible..
thanks!

bradgrafelman

Sounds like a (very) simple inner join of ENTRIES with USERS based on the join condition you described. Add on a WHERE clause to only include users with the OPTIONS value of "1" as you described and you're all set.

What have you tried? (Also, have you tried finding some good articles/tutorials that teach the basics of SQL? Not being able to work out a simple JOIN is rather like purchasing a fancy new graphing calculator and not knowing how to use it for anything but addition and subtraction.)

dalecosp

listenmirndt;11015749 wrote:
count the number of users in the ENTRIES table (distinct)
but ONLY where the USER table in ENTRIES matches the USERNAME table in USERS - AND - the OPTIONS table in USERS equals "1"

Possible English to SQL Translation: "select count(distinct user) from entries as e, users as u where e.user=u.user and u.options=1" ?? 🙂