query problem

[leena]

Hello everyone,

I'm not sure what's going on. Everything worked fine a few days ago.

I have a query that looks like this:

SELECT team.TeamID, team.TeamName, member.StandingGames,
member.DivisionMemberSub
FROM ITDivisionMember as member, ITTeam as team
WHERE member.DivisionID = 1
AND member.TeamID = team.TeamID
ORDER BY DivisionMemberSub, StandingPoints DESC, StandingGF_GA DESC, team.TeamName

This will not give me results, and it should. It worked yesterday. However, this query below will work:

SELECT team.TeamID, team.TeamName, member.StandingGames,
member.StandingWins, member.StandingLosses, member.StandingTies, member.StandingDefaults,
member.StandingGF, member.StandingGA, member.StandingGF_GA, member.StandingPoints, member.DivisionMemberSub
FROM ITDivisionMember as member, ITTeam as team
WHERE member.DivisionID = 1
AND member.TeamID = team.TeamID

All I did to this second query was take out the "ORDER BY ... " statement.

It really doesn't make any sense, because it worked yesterday and it is not working today. I haven't changed anything with my code or my database.

Any help is greatly appreciated. Thanks for your time.

Sincerely,
Lena

[rgermain]

Just out of curosity after that query do you have something to help debug it?

Example:

<?
$query ="SELECT team.TeamID, team.TeamName, member.StandingGames,
member.DivisionMemberSub
FROM ITDivisionMember as member, ITTeam as team
WHERE member.DivisionID = 1
AND member.TeamID = team.TeamID
ORDER BY DivisionMemberSub, StandingPoints DESC, StandingGF_GA DESC, team.TeamName";

$result = mysql_query($query) or die("Error: " . mysql_error());
?>

If not I would suggest trying to add that and seeing if it outputs any errors and then if you can't figure out the problem from the error post the error here.