[Resolved] Need new set of eyes for error

[rgermain]

I sorta have a problem. Now why I say sorta is cause the function I made does what I want it to and works fine only at the end it throws an error.

Code:

<?
include('../connection.php');
function featuredHomes()
{
$table = "story_tbl";
$high_array = array();
 $q = "SELECT * FROM $table where id <= 4";
 $r = mysql_query($q) or die("Error: " . mysql_error());
while($row = mysql_fetch_array($r))
{
array_push($high_array,$row['id']);
}

srand((double)microtime() * 1000000);
shuffle($high_array);
for($i=0;$i <= count($high_array);$i++)
{
$q2 = "SELECT head FROM $table WHERE id = $high_array[$i]";
$r2 = mysql_query($q2);
//-The line  below is line 26, where the error claims to be.
$rows = mysql_fetch_array($r2);
$head = $rows['head'];
echo "<a href=\"fullstory.php?id=". $high_array[$i] . " \" target=\"blank\">". $head ."</a>";
echo "<BR>";
}
}
?>

Error Reads:

Warning: Supplied argument is not a
valid MySQL result resource in 
home/dlonline/public_html/testing/testing.php on line 26

[YappyDog]

Try freeing the results of your first query before you do your second query.

mysql_free_result($r);

http://us3.php.net/manual/en/function.mysql-free-result.php

[rgermain]

Ok, neither of those ideas were the problem, thanx for the help though. I did however figure out the problem.

I just added in an extra if statement saying if the $high_array is empty do the output other wise for get it.

Cleaned the little error up nicely for me.

Thanx for all your help and suggestions.

[YappyDog]

You should also break apart your second query so that it parses the array value correctly.

$q2 = "SELECT head FROM $table WHERE id = " . $high_array[$i];