Help With Invalid query "usertable doesn't exist"

Discussion in 'Databases' started by Mikelangelo, Jan 15, 2010.

  1. #1
    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
     
    Mikelangelo, Jan 15, 2010 IP
  2. duben

    duben Active Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #2
    In table where you are running this query doesn't exists table with name 'usertable'.
     
    duben, Jan 15, 2010 IP
  3. cahya77

    cahya77 Member

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #3
    hi..
    please tell us the detail of your database structure...
    include table's name...
    thanks
     
    cahya77, Jan 15, 2010 IP
  4. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #4
    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.
     
    plog, Jan 15, 2010 IP