Notice: Table doesn't exist

Question

I am trying to create a script to display my MYSQL db info and I keep getting these errors:

Notice: Table 'head1sta_news.news' doesn't exist in /home/head1sta/public_html/index.php on line 103

And:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/head1sta/public_html/index.php on line 104

It has varied as I have tweaked the code here and there trying to figure out what I am messing up on. This is the script:

<?
mysql_connect("localhost", "****_news", "****");
mysql_select_db("****_news");
$query = "SELECT * FROM news ORDER BY id DESC";
$result = mysql_query($query) or trigger_error(mysql_error());
while($data = mysql_fetch_row($result)){
  echo("$data[1] , $data[0] , $data[3]");
}
?>

Error message is so clear. **Table 'head1sta_news.news' doesn't exist** — Can Geliş, Jun 24 '13 at 20:22
verify your `mysql_connect` is working my guess is there is a problem in the connection. — Pitchinnate, Jun 24 '13 at 20:24
@deceze: Actually, that error doesn't appear on the reference page. I guess "Table doesn't exist" was assumed to intuitively mean that the "table doesn't exist" — AndyG, Apr 15 '14 at 02:18

exussum · Accepted Answer · 2013-06-24T20:30:02.870

1

You havent set up for database correctly it doesnt have the table / the user doesnt have permission to see the table

head1sta_news.news

By the table name above i assume your reading from a head first book ? If so PLEASE get a more recent version, If its suggesting mysql_connect its at least a few years out of date.

The second error is actually a result of the first not being handled correctly also.

edited Jun 24 '13 at 20:30

answered Jun 24 '13 at 20:23

exussum

18,275
8
32
65

Notice: Table doesn't exist

1 Answers1