Unknown error?

[lukeurtnowski]

I'm trying to outtput records from a mysql table and I get an error here

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/scaspco/public_html/testing/reviews.php on line 41
in

  <?php 
 $i = 0;
while ($result = mysql_fetch_array($query)) {
    if($i++ % 2) {
        $bgcolor = "category";
    } else {
        $bgcolor = "#DFE6EF";
    }
    print "<tr bgcolor=\"$bgcolor\">";
    print "<TD>".$result['ASP_Name']."</TD>";
    print "<TD>".$result['Username']."</TD>";
    print "<TD>".$result['R_Date']."</TD>";
    print "</TR>\n";
	} 
  ?>

Whats that about?

[Houdini]

Well is would not be a valid query if you never connected to the database and did not then select a database to query, and if the above is the entirety of your code then that is what you will get. There is more isn't there?

[lukeurtnowski]

Yes, here is the other stuff

$hostname = "localhost";
$username = " _ ";
$password = " ";
$database = "scaspco_reviews";
$connection = mysql_connect($hostname , $username , $password)
or die("cannot make connection");
$db = mysql_select_db($database , $connection)
or die("cannot find database");
$query = "SELECT DATE_FORMAT(R_Date, '%c/%e/%Y'), ASP_Name, Username FROM REVIEW"; 

[matt72]

It means your query is returning no results... Either it's invalid or no rows match.

You need to actually execute the query somewhere too, to make a result.

<?php
$real_result = mysql_query($query); //Do the query
if(mysql_num_rows($real_result ))// There are rows in the result
{
  $i = 0;
  while ($result = mysql_fetch_array($real_result )) {
    if($i++ % 2) { 
        $bgcolor = "category"; 
    } else { 
        $bgcolor = "#DFE6EF"; 
    } 
    print "<tr bgcolor=\"$bgcolor\">"; 
    print "<TD>".$result['ASP_Name']."</TD>"; 
    print "<TD>".$result['Username']."</TD>"; 
    print "<TD>".$result['R_Date']."</TD>"; 
    print "</TR>\n"; 
    }
}
  ?>