Quantcast

mySql craziness

Kyle's picture

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?

Juice10's picture

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

User login

Partner With Us













Latest critique

Fin-Tek