MySQL Not Displaying Outputs

[SP8600]

Can anyone see anything wrong with this code because it will not display any data from the database.

$sqlquery = "SELECT * FROM properties WHERE country = '$country' AND ((price>= $_GET[minval]) AND (price <= $_GET[maxval]))";
$result = mysql_query($sqlquery, $connection);
$num = mysql_num_rows($result);
include("incs/templates/thumbs/header.php");
for ($i=0; $i<$num; $i++) {
	$row = mysql_fetch_assoc($result);
    	echo("


<td width=\"50%\"  align=\"center\">\n<a href=\"property.php?id=".$row["id"]."\"><img src=\"".$row["thumbnail"] ."\" width=\"150\" height=\"90\" border=\"0\"></a><br>\nLocation: ".$row["location"]. "<br>\nPrice: ". $row["currency"]. "". $row["price"]."\n</td>


");
if (($i % 2) == 1) echo "</tr>\n";
}
// Close table row if odd number of rows
if (($num % 2) == 1) echo '<td width=\"50%\">&nbsp;</td></tr>';
mysql_free_result($result);
	include("incs/allpagesfooter.txt");
	echo("


</table><h4><br>
  </h4>
</div>
</body>
</html>


");

[matto]

does your query give any results?

after this line:
$sqlquery = "SELECT * FROM properties WHERE country = '$country' AND ((price>= $GET[minval]) AND (price <= $GET[maxval]))";

add:
echo $sqlquery."<br>";

re-run script, check if the query is valid (I think you may have problems encapsulating array values like this ... instead of:

$bla = "bla bla $GET[minval] bla";
you should do:
$bla = "bla bla ".$GET['minval']." bla";

) - then, if you have the possibility, paste it into the mysql shell and look if any results are given. If not, the query is the problem.

[SP8600]

yes it shows all the rows, but not the first one.