mysql_fetch_row(): error!!

[Adamthenewbie]

I am getting this error
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

Here is the code:

$db = 'database'; // mySQL database name
$user = 'adam'; // mySQL username
$pw = 'password'; // mySQL password
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);
$query = mysql_query("select date, id, interviewWith, name, type, news, interviewBy from interviewsNews order by time Desc limit 0, 99999999");
while($interviewsNews = mysql_fetch_row($query))
{
$date = $interviewsNews[0];
$id = $interviewsNews[1];
$interviewWith = $interviewsNews[2];
$name = $interviewsNews[3];
$type = $interviewsNews[4];
$news = $interviewsNews[5];
$newsBy = $interviewsNews[6];
....etc

I use mysql_fetch_row(); in other pages and it seems to work fine??? Any help would be great.

Adam

[ereptur]

When you get this message, it usually means that your query was invalid. Try adding "or die(mysql_error())" after the mysql_query (before the semi-colon). This should kill your script and display any error message returned by the MySQL server.

[Adamthenewbie]

thank you. That helped me find the error

Adam