[Resolved] Query Error, can't figure out.

[Sonic_Rage]

I keep getting this query error but can't seem to figure out what I'm doing wrong here. I basically just need it to retrieve data from the db, simple.

  $conn = db_connect();
  $query = "SELECT * FROM donors";
  $result = mysql_query($query);
  $num_results = mysql_num_rows($result); // Keeps saying that this line has an error, but I have used this same code in other applications just fine.
   for ($i=0; $i <$num_results; $i++)
    {
      $row = mysql_fetch_array($result);
      $name = stripslashes($row['primary_first']);
      echo"<P>$name";
    }

[laserlight]

$conn = db_connect()
	OR die("connection error"); //for debugging
//NB: does db_connect() select the database?
//otherwise check that DB selected correctly
$query = "SELECT * FROM donors";
$result = mysql_query($query)
	OR die(mysql_error()); //for debugging
$num_results = mysql_num_rows($result);

//use while instead of for loop to avoid using an index
while ($row = mysql_fetch_array($result))
{
	$name = stripslashes($row['primary_first']);
	echo"<P>$name";
}

[Sonic_Rage]

Ok, it is working now, for some reason it wasn't connectiing to the db, but rewrote the code over and it now works, thank you.