if statement in loop

[vent]

have this if action but it doesn'y get looped like the $do_block and so only gives one answer. How can i get it to loop with the main block??
cheers.

$sql = mysql_query("SELECT * FROM monkey_clients WHERE cs='yes' ORDER BY title");
if($myrow = @mysql_fetch_array($sql)){
$i = 0;

	do{
       	$id = $myrow["id"];
        $title = $myrow["title"];
        $info = $myrow["info"];
        $link = $myrow["link"];
        $email = $myrow["email"];
        $cs = $myrow["cs"];
        $chart = $myrow["chart"];
	    $i++;

   if($chart = "both"){
   $chartb = "1";
   } else if($chart = "creative use of channels"){
   $chartb = "2";
   } else if($chart.= "communication strategy"){
   $chartb = "3";
   }

    $top ="<table width=\"100%\" height=\"174\" border=\"0\" cellpadding=\"0\" cellspacing=\"3\" dwcopytype=\"CopyTableRow\">";

$do_block .="<tr>
<td valign=\"top\"><span class=\"copytitle\">$title</span></td>
<td valign=\"top\"><span class=\"copy\">$info</span></td>
<td valign=\"top\">$chartb</td>
<td valign=\"top\"><a href=\"$link\" target =\"_blank\">$link</a></td>
</tr>";

	}while($myrow = mysql_fetch_array($sql));
}

print"$top$do_block </table>";

[YappyDog]

Not sure if this is what your questioni is or not.........

But, your if statements in this section are all wrong. You need to use double equal signs to get them to work.

if($chart == "both"){
$chartb = "1";
} else if($chart == "creative use of channels"){
$chartb = "2";
} else if($chart == "communication strategy"){
$chartb = "3";
}