SELECT
count(a.UserID)
FROM Users a,DisabledEntries b
WHERE a.UserID<>b.ID
This always produces 0.
By the way, field ID in table DiabledEntries HAS to named ID and not UserID since the id in the DisabledEntries can be a userid or picid or some other id.
Im trying to return all rows except those that are disabled by the admin in the DisabledEntries table. I didn't want to enter a separate field in User table called Disabled because in most cases it'll be no. Only rarely will a user will disabled so I thought of having disabled users in a separate table. Same applies for info like text content, pic etc etc.
Guess I'll have to do it from PHP side ?
Last edited by anjanesh on Thu Jul 29, 2004 11:30 am, edited 1 time in total.