php and mysql problem

[pumpkinapo]

I have a php/mysql site setup but I'm having issues with mysql. What I'm trying to do is post the point results for our fantasy nascar league. I enter the racedate, member, and points. But when I do a select for that race it doens't return any records. This does work by the end of the week (Friday-ish), just not after entering.

I also have a running total of the points, that sql query works fine. It includes all races incuding the last entered race.

The site is located at:
http://tangentmotorsports.dyndns.org/tangentmotorsports/index.php

I have it showing the sql statemets at the moment to help troubleshoot.

Is there something i'm missing? Thanks.

It seems to be shorting the visual link. Here it is is parts:
http://tangentmotorsports.dyndns.org/
tangentmotorsports/index.php

[Wave]

repeat URL, please.

[Ph0eniX]

I see your queries when I hit the URL.

"SELECT Crew.Nickname, NascarFantasyPoints.Points FROM Crew INNER JOIN NascarFantasyPoints ON Crew.MemberNumber = NascarFantasyPoints.MemberNumber WHERE NascarFantasyPoints.RaceDate='2002-09-22' ORDER BY NascarFantasyPoints.Points DESC;"

😕 😕 😕

[pumpkinapo]

Yes, I have queries displayed to help me troubleshoot my issue. The queries are executing, except for the first one. It returns no records where there should be 7.