[Resolved] Warning: mysql_fetch_array(): supplied Problem

dynamiteRW

I inserted the following coding to create a movie database:

<?
$connection = mysql_connect('localhost', 'username', 'password');

mysql_select_db('wu_wrestleinfo_com', $connection);

$query = mysql_query("SELECT * FROM movie WHERE id='$id' ");
$content = mysql_fetch_array($query);

mysql_close($connection);
?>
<html>
<head>
<title>Movie displays</title>
</head>
<body>
ID : <? echo $content[id];?> 
Name : <? echo $content[name];?> 
Year : <? echo $content[year];?> 
Director(s) : <? echo $content[directors];?> 
Cast : <? echo $content[cast];?> 
Description : <? echo $content[description];?> 
</body>
</html>

I entered the right username and password, but took them off for security reasons.

I get the following error on my page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site11/fst/var/www/html/display.php on line 7

I would really appreciate help on this topic.

matt_4013

Change $content = mysql_fetch_array($query); to

$content = mysql_fetch_array($query) or die(mysql_error());

This will return the mysql error message so you can see the problem with the mysql_query (You're getting this error because the mysql_query() function failed).

dynamiteRW

When I added that, it said this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site11/fst/var/www/html/display.php on line 7
Table 'wu_wrestleinfo_com.movie' doesn't exist

See, with my MySQL database, I only have one account but I can add multiple tables under it.

But I get this problem...do you or anyone know how this could be solved?

dynamiteRW

I found the problem!

lol, I spelled the table name wrong...should be movies, not movie.

sorry about that...heh...:o

matt_4013

Well, in your database, the table 'movie' doesn't exist. You'll need to create it before you can refer to it in your program.

matt_4013

heh, fair enough 🙂 Remember to mark the thread resolved!

dynamiteRW

how would I do that?

matt_4013

There's a little link down the bottom that says: Mark thread resolved. Just click that.

It just makes it easier for us when we're helping people out, so we don't have to look into a thread that's already been fixed 🙂