[Resolved] table doesn't exist error

[kdog_x]

I'm trying to insert data into a table called "intro" in a database called "test", but I keep getting an error. I edited my code so it would display the error it was getting. It shows

Table 'test.intro' doesn't exist when I access the page

The table is there though, I can see it in PHPmyAdmin. I echoed the INSERT query to the screen and tried pasting it in PHPmyAdmin and it works fine, it just wont work from my page.

<?php
// connect to the database
$conn = mysql_connect("localhost","chicago_admin","go");
$db = mysql_select_db("test", $conn) or die("Couldn't Select DB");

$sql = 'INSERT INTO `intro` (`id`, `last_name`, `first_name`) VALUES("","Men","The")' ;

$run = mysql_query($sql) or die(mysql_error());
?>

Any ideas why it would say that the table doesn't exist?

[dalecosp]

Don't believe you want those ticks (quotes, apostrophes, whatever), around the tablename ... but I could be wrong.

I never post in the database forum, 'cause I'm an SQL idiot. 😃

[nemonoman]

Your code should work, but since it isn't working, you need to trouble shoot:

Try this and post results:
$conn = mysql_connect("localhost","chicago_admin","go");
$db = mysql_select_db("test", $conn) or die("Couldn't Select DB");

$sql = 'SHOW TABLES()' ;

$result = mysql_query($sql) or die(mysql_error());

while($row=$mysql_fetch_array($result)){
$tables[]=$row[0];
}
print_r($tables);

[kdog_x]

I found my problem. I made two databases, one named chicago_test and one named just test. Guess which one I was trying to add information to. I must have wasted at least two hours trying to find the problem. Thanks for all the help!