Drawing from Multiple Tables Problem

[imperium2335]

Hi,

 

I have a little script that shows a user or group of users' work based on branches and users.

 

I.e, I would like all the users of a given branch to be able to see all the other users' things who are in the same branch only.

 

But all I'm getting is far too many results (takes a long time to load!) not in any consistent format.

 

I have tried using GROUP BY etc but with no luck, I just get different crazy results.

 

$result = mysql_query("SELECT enquiries.*, users.*
					  FROM enquiries, users
					  WHERE enqState = 'New'
					  AND users.branch = '$userBranch'
					  AND enquiries.assignedToT = users.userName
					  OR enqState = 'New'
					  AND '$userLevel' > 4
					  ") ;

[Muddy_Funster]

Get rid of those SELECT * and explicitly name the fields that you want back.  You don't use SELECT * like that anyway.  Also, could you post your table strcture up, I'm pretty sure you should be using a JOIN in this.

[imperium2335]

Thanks, I know I'm just being lazy  , will optimise it once I have it working.

 

users has this structure:

 

id userName userPass     branch

 

Enquiries has:

 

id detail_sheetRef assignedToT enqState

 

I'm not to well versed on JOIN, how would that help in this case?

[Muddy_Funster]

ok, do the tables refference each other at all? and what field types are they all? 

[imperium2335]

enquiries.assignedToT references users.userName