error with If statement

[BlackRaven]

hi my script works however i am having displaying the adsense banner when there are no results found in the mysql query, is something wrong with my if statment?

$sql = "SELECT
*
FROM
ads
WHERE
cat_id = '" . $forum_id . "'
ORDER BY
weight DESC";

$query=mysql_query($sql);
If ($query){
$adview='';
while($row = mysql_fetch_array( $query ))
{
$adview=$adview.'<td>'.$row[2].'</td>';
}
}
else
{
$adview='<script type="text/javascript">google_ad_client = "pub-XXXXXXXXXX";google_ad_width =160;google_ad_height =600;google_ad_format = "160x600_as";google_ad_type = "text";google_ad_channel ="";google_color_border = "FFFFFF";google_color_bg = "FFFFFF";google_color_link = "006699";google_color_url = "333333";google_color_text = "333333";</script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>';
}

[jatar_k]

just because 0 rows were returned doesn't mean the query failed.

try using mysql_num_rows to find out if anything was returned.

$returnedrows = mysql_num_rows($query);
if ($returnedrows > 0) {

[BlackRaven]

thnx jatar_k