if then statement trouble

[wickedneat]

I'm trying to say

If the username appears in the following list:

$sql = "SELECT * FROM authorize AS u_one INNER JOIN authorize AS u_all ON u_all.department IN ( u_one.department , u_one.department2 , u_one.department3 , u_one.department4 , u_one.department5 , u_one.department6 ) WHERE u_one.username = '$_SESSION[user_name]' AND NOT u_all.lockedstatus = 'LOCKED'";

and also in this

SELECT * FROM here

Then display all information from that user in the here table.

[_Steve_]

Very cryptic, does it work?

[wickedneat]

Well, If it did I wouldn't be asking for help now would I? :P

[CVPer]

could you explain the purpose of your sql statement?

[wickedneat]

The purpose of that sql statement is to weed out unwanted usernames..

[taliesinnz]

If you are trying to find users in
SELECT * FROM here

which are also in

SELECT * FROM authorize AS u_one INNER JOIN authorize AS u_all ON u_all.department IN ( u_one.department , u_one.department2 , u_one.department3 , u_one.department4 , u_one.department5 , u_one.department6 ) WHERE u_one.username = '$_SESSION[user_name]' AND NOT u_all.lockedstatus = 'LOCKED'

You could try and use a LEFT JOIN, so something like

SELECT * FROM here LEFT JOIN authorize ON here.username=authorize.username WHERE authorize.username IS NOT NULL

[wickedneat]

So this?


SELECT * FROM authorize AS u_one INNER JOIN authorize AS u_all ON u_all.department IN ( u_one.department , u_one.department2 , u_one.department3 , u_one.department4 , u_one.department5 , u_one.department6 ) WHERE u_one.username = '$_SESSION[user_name]' AND NOT u_all.lockedstatus = 'LOCKED' SELECT * FROM here LEFT JOIN authorize ON here.username=authorize.username WHERE authorize.username IS NOT NULL;

[_Steve_]

DELETE FROM tbl1,tbl2,tbl3,tbl4 WHERE username = 'username' ??

On the other hand, post your tables and what exactly you want to do.
Joining the same table is not a good option.