Need help

bengt

I have two tables

table 1
userid	name	
----------------------------------
1	Ozzy osbourne
2	Wham

table 2
id	userid	access	
----------------------------------
1	1	3
2	2	4

How can i display the entries in table 1 that ex is not listed with access 3 in table 2?

Bengt

Roger_Ramjet

WHERE access<>3

bengt

I would like to list the users in table 1 who does NOT have access level 3.
I don't think you understand my question...

Bengt

Roger_Ramjet

Originally posted by bengt
I would like to list the users in table 1 who does NOT have access level 3.
I don't think you understand my question...

Bengt

Yes I do. My where clause says 'all users whose access column is NOT EQUAL to 3': <> means 'not equal' in SQL. Simply add it to the end of your select query, or do you want me to write that for you as well?

bengt

You mean

SELECT table1.* FROM table1, table2 WHERE table2.access <> 3

???... Didn't work...

I am NOT experiences in MySQL...

Roger_Ramjet

Did not work because you have not specified the JOIN condition. Take the time to read the manual and you'll learn sql.

bengt

I've tried to read about join... And tried this

This is my real tables that I use...

Table1
id mediumint(5) NOT NULL auto_increment,
epost varchar(255) NOT NULL default '',
passord varchar(10) NOT NULL default '',
fornavn varchar(255) NOT NULL default '',
etternavn varchar(255) NOT NULL default '',
adresse varchar(255) NOT NULL default '',
postnr varchar(6) NOT NULL default '0',
poststed varchar(255) NOT NULL default '',
tlfhjem varchar(8) NOT NULL default '0',
tlfarb varchar(8) NOT NULL default '0',
tlfmob varchar(8) NOT NULL default '0',
verv varchar(255) NOT NULL default '',
gruppe int(2) NOT NULL default '0',
lag int(4) NOT NULL default '0',
region int(2) NOT NULL default '0',
fdato datetime NOT NULL default '0000-00-00 00:00:00',
medlemsnr int(8) NOT NULL default '0',
tilgang tinyint(1) NOT NULL default '0',
lastlogin datetime default NULL,
nyheter tinyint(1) NOT NULL default '0',
logins int(5) NOT NULL default '0',
online datetime default NULL,
loggedin tinyint(1) NOT NULL default '0',
varslingsplan int(1) NOT NULL default '0',
PRIMARY KEY (id,id),
UNIQUE KEY epost (epost)

Table2

id int(5) NOT NULL auto_increment,
ressursid int(5) NOT NULL default '0',
brukerid int(5) NOT NULL default '0',
lagid int(5) NOT NULL default '0',
PRIMARY KEY (id)

where table2.brukerid is the same as table1.id
and table2.ressursid is the same as access in my example.

Tried this sql:

$sql = "SELECT u.* FROM users AS u JOIN ressursgrupper AS r ON u.id = r.brukerid WHERE r.ressursid <> '$ressursid'";

But didn't work.
But if I replace <> with = i get all the entries from table1 that has table2.ressursid.

bengt

Table1 is users, and table 2 is ressursgrupper

Is there anyone who would write me the query to find all users un table1(users) that is not listed with ex ressursid = 3 from table2(ressursgrupper).

I have tried reading mysql manual about join, but i'm on a simple programming level, and I find it hard understanding the manual, sorry.

Roger_Ramjet

Remove the single quotes from around '$ressursid'. It is an integer value and so does not need them.