Jump to content

mysql help


scarface83

Recommended Posts

AND a_users.Level='0'

 

You do not have a join to the table a_users, that and it is not in the from statement.

 

would this do it ?

 

$team_names = mysql_query("SELECT a_team.TeamRef,a_team.Teamname FROM a_team LEFT JOIN a_users WHERE a_team.In_use='Y' AND a_team.Area='1' AND a_users.Level='0' ORDER BY Teamname	")

Link to comment
https://forums.phpfreaks.com/topic/46486-mysql-help/#findComment-226155
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.