MySQL table exists on server but cannot access it from PHP

Question

I added to a database a new table using PHPMyAdmin; when trying to access it from a PHP page I get the dreaded MySQL error "table doesn't exist".
Database connection data are OK, they are used a few lines above on the same page to access another table in the same database. If I do SHOW TABLES in PHPMyAdmin the new table is listed; if I do it from a PHP page the new table does not appear in the list. Engine for the new table is MyISAM, like all other tables in the database. I can access the db server only via PHPMyAdmin.

Sorry, I forgot the code, here it is:

$db = mysql_connect ($db_host, $db_user, $db_password) or 
die("Error message here");
$db_select = mysql_select_db($db_name, $db)or die("Error message here");


$query = ("SELECT * FROM `old_table`");
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) 
{
// do stuff - here it works
}


$query = ("SELECT * FROM  `new_table`");
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) 
{
// do stuff - here it does not work
echo mysql_error();
}

Is the PHP script connecting with the same user as you are connecting via PMA? The user may not have access to the table. — Michael Berkowski
– Michael Berkowski, Commented Jan 19, 2013 at 13:57
try running "SHOW TABLES" from PHP and check if the new table is listed — Raj
– Raj, Commented Jan 19, 2013 at 14:20

Techie · Accepted Answer · 2013-01-19 13:59:27Z

4

On Unix, table names are case sensitive. On Windows, they are not. Fun, isn't it? Kinda like their respective file systems. Do you think it's a coincidence?

It probably depends on table type; MyISAM in your case.

Field names are case-insensitive regardless.

For database and table names, it depends on the underlying operating system. Identifier Case Sensitivity

answered Jan 19, 2013 at 13:59

Techie

45.2k45 gold badges164 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Techie Over a year ago

check whether the table names are correct and they are not mistakenly typed

Your Common Sense · Accepted Answer · 2013-01-19 14:00:06Z

2

The answer is simple: some typo or another silly mistake like this: you're connecting wrong server, editing wrong file or something of the kind. Just double check everything.
There is no particular error to cause this

answered Jan 19, 2013 at 14:00

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

1 Comment

Nickel Over a year ago

You are right: there is no reason for this. I am checking again everything but can't find anything wrong.

Walber · Accepted Answer · 2019-05-06 15:30:24Z

1

The answer is: the table name or at least one of the field names is a reserved word.

To solve it, you can enclose the fields and table name with grave accents (`), e.g:

SELECT `value` FROM `pivot`;

answered May 6, 2019 at 15:30

Walber

111 bronze badge

Collectives™ on Stack Overflow

MySQL table exists on server but cannot access it from PHP

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related