speedblog

thank u, my problem solved...i never tought sql is very case sensistive to table name...

Every information lead to this problem is as above...Damn, I feel dizzy right now, its almost 20 hours I've been thinking about this problem...

@tomcat how am i supposed to check on that...before i created the user, the user has been set up to have all previleges.

Hello everyone, I have a mystery problem I have a script run well in my local machine. Everything was okay until I uploaded the scripts into a web hosting. The script supposed to select field in a table. User geekprog_sistem already granted all privilege to the database but it reporting to display. SELECT command denied to user 'geekprog_sistem'@'localhost' for table 'SUBJEK' Below is my query <?php $result = mysql_query ("SELECT * FROM GEEKPROG_MYPELAJAR.SUBJEK WHERE idpelajar = $idpelajar") or die (mysql_error()); while ($row = mysql_fetch_array ($result)) { } mysql_close ($conn); ?> This query is executed right after I logged in. The mystery was, SELECT command to pick user and password was success, but when It come to the logged page to another SELECT command, it displayed as above error. I hope anyone here can help me to solve the matters....Thanks.