I have a database of 20 teams i would like to select 10 fixtures from my database where the home_team is not equal to the away_team and the away_team is not equal to the home_team in other words each team plays once.

can i do this? because it doesnt seem to be working!

PHP Code:

mysql_query("SELECT * FROM `manager__fixtures` WHERE `league` = '$league_id' && `home_team` != `away_team` && `away_team` != `home_team`"); 


Are you sure manager__fixtures should have 2 underscores?

Also, if away_team != home_team then the reverse is true and you don't need to say it.

I don't know sports and you didn't bother to share your database structure, so I'm not sure about this, but I think you'll need to consider joining the table with itself to cross reference the teams.

ye it shud have two _ as it groups them in the database under the main title manager.

DB Structure


id bigint(225) auto_increment
home_team int(225)
away_team int(225)
date varchar(225)
type varchar(225)
league int(225)
match_day int(225)

The query looks right. Are the ones with $ variables? Because in single quotes variable values aren't put in, the text it taken literally.

yep ' single quote for variables and ` for field names!

Sounds like you'll need a join. Here's an example with an INNER JOIN that may guide you on the right path:

PHP Code:

mysql_query("SELECT * FROM manager__fixtures home_table,manager__fixtures away_table WHERE home_table.league = '$league_id' && home_table.home_team != away_table.away_team");