SELECT COUNT(*) Suddenly Stopped Working - I Have NO Idea Why!

[sintax63]

I have this mysql_query in a good portion of my pages that counts to see how many states a user has been in by comparing entries from three separate tables. It has been working just fine until this morning when I pulled up the site to do some work on it.

 

If anyone can offer some suggestions I would be greatly appreciative!

 

$AL = mysql_result(mysql_query("SELECT COUNT(*) FROM users, tracking, profiles WHERE tracking.placeID = profiles.id AND tracking.userID = users.id AND tracking.userID = '$profileID' AND state='AL'"),0);

 

the $profileID does return a valid variable so I know that isn't the issue. 

[kickstart]

Hi

 

When you say it no longer works, do you mean it fails or that it just brings back 0?

 

All the best

 

Keith

[sintax63]

Sorry about that - I know better:

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in state-count.php on line 3

 

And it gives that error 50 times - one for each state...

[sintax63]

Well after countless rewrites I got it working again. I am not sure why it worked all this time and then just stopped this morning. Yeah, yeah... I know it doesn't happen like that. 

 

$AL = mysql_result(mysql_query("SELECT COUNT(*) FROM users, tracking, profiles WHERE users.id='$profileID' AND tracking.userID='$profileID' AND profiles.id=tracking.placeID AND profiles.state='AK'"),0);