mySql craziness
Submitted by Kyle on Mon, 2005-06-27 18:18.
Well, I'm new here, I dont know exactly what these forums are supposed to be used for, but anyway... I'm making this little minisite, and I have a little snip of code goes like this ' SELECT count(*) FROM Deluxe WHERE ManagerID=5 ' and it will not work. if I change the 5 to a 1, it easily counts them. If it goes back to 5, it wont count the '5' ones, even though in the database there are clearly rows with ManageriD of 5... I don't understand at all. Its like it doesnt even exist . When I use the same php in the phpmyadmin sql, it returns exactly how I want it.. I dont understand at alll?? any ideas?
did you do
did you do this:
mysql_qeury("SELECT count(*) FROM Deluxe WHERE ManagerID='5'") or die (mysql_error());cause you should get an error if there is something wrong, if not then you should double check that Deluxe has entrys with ManagerID of 5