Help With Invalid query "usertable doesn't exist"

Hope somebody can help..

I keep getting this error "Invalid query -- SELECT * FROM `usertable` WHERE userid = 1156644879 -- Table 'mydispl1_test.usertable' doesn't exist"

// Database Settings
$dbhost = 'localhost';
$dbuser = 'mydispl1_mikel';
$dbpass = 'password';
$dbname = 'mydispl1_test';

thanks in advance

 

In table where you are running this query doesn't exists table with name 'usertable'.

 

hi..
please tell us the detail of your database structure...
include table's name...
thanks

 

Run this query to show all the tables in your database:

SHOW TABLES FROM mydispl1_test;

PHP:

Either post the error or results you get and we can help further.