";
// interest
$sql2 = "SELECT * FROM zlo_interest ORDER BY `common` DESC";
$result2 = mysql_query($sql2) or die(mysql_error());
$total=mysql_affected_rows();
if ($total!=0) { $i=0;
echo"
";
$col=3;
$perCol=ceil($total/$col);
$one=0;$two=0;
$j=0;
// êîíâåðòèðóåì
$interestMass=explode(":",$userInfo['interest']);
while ($interest=mysql_fetch_assoc($result2)) {
if($interest['common']==1) { $j++;
if($one==0){
echo"
".SS1."
".SS2."";
$one=1;
}
echo"
".(($lang=='ukr')?$interest['title_ukr']:$interest['title'])."
";
}
if($interest['common']==0) { $i++;
if($one==1) {
echo"
"; $one=2;
}
if($two==0) {
echo"
".SS3."
".SS4."";
$two=1;
}
if ($i==1 || $i==$perCol+1 || $i==2*$perCol+1 ) { echo"
"; }
if (in_array($interest['id'], $interestMass)) {$checked="checked='checked'";} else {$checked='';}
echo"
".(($lang=='ukr')?$interest['title_ukr']:$interest['title'])."
";
if ($i==$perCol || $i==2*$perCol || $i==$total-$j) { echo"
"; }
}
}
echo"
";
}
echo"