if () statement question

[micmac]

Hi Guys,
Can anyone tell me why this if/else statement is not working?

<?
$row = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM cat1 WHERE CatParent = $id"));
if($row[0] > 0){
	$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id  AND active='yes' ORDER BY pref, CatName");
	while($row = mysql_fetch_array($result)){

    if ( $row['description'] == "") {

	if( $new_id == "2"){
	$flag_pic = "uk_flag.gif"
	} else if( $new_id == "3"){
	$flag_pic = "usa_flag.gif"
	} else if( $new_id == "4"){
	$flag_pic = "aus_flag.gif"
	}

	echo "<TR>";
	echo "<TD align=left vAlign=center width=\"29\"><a href=\"results.php?id={$row['CatID']}&new_id=$new_id\"><IMG align=center alt=\"LET'S GO MELBOURNE\" border=0 height=19  src=\"images/$flag_pic\" width=23></A>"; 
	echo "</TD>";
    echo "<TD align=left vAlign=center width=\"306\"><a href=\"results.php?id={$row['CatID']}&new_id=$new_id\">{$row['CatName']}</a></TD>";
    echo "<TD align=left vAlign=center width=\"100\">&lt; Click to view</TD>";
    echo "</TR>";



} else {

.....more php here

[kidsleep]

What error is it giving you?

have you tested to see if your first query is returning anything?

need more info and I'll try my best

[evildj]

Well, right off the bat, you are missing the closing } brackets for the while statement and the next if statement

[hand]

"elseif" instead of "else if"

http://www.php.net/manual/en/control-structures.elseif.php