php database search



<div class="container">
<div class="row">
<?php
$sql="SELECT a.*,b.* FROM `fc_desksol` a left join fc_desksol_data  b on a.id=b.id WHERE url in(select url from fc_desk where catid=".$catid." and islink=1) and a.catid not in(52) order by a.listorder ASC limit 0,20";
$query=mysql_query($sql);
$i=0;
while($row=mysql_fetch_array($query)){?>
<?php $pic=string2array($row['solpic']);?>

{if $i==0}
<div class="col-sm-5">
  <div class="media">
 <a href="{$row['url']}"> <img src="{$pic[0][url]}" class="media-object img-responsive"/></a>
  <div><h4><a href="{$row['url']}">{$row['title']}</a></h4></div>
  <p>{$row['description']}</p>
  </div>
</div>
<div class="col-sm-7">
<div class="row">
{else}
 <div class="col-sm-6 border-down-g">
 <a href="{$row['url']}"><h3>{$row['title']}</h3></a>
  <p>{$row['description']}</p>
</div>
{/if}

<?php
$i++;
}
?>
</div>
</div>
</div>
</div>