$sql="SELECT * from categories ORDER by cat_name"; $query=db_query($sql, $cn); $row = array(); while ($cat = mysql_fetch_array($query)) { $row[] = $cat; } $flimit = floor(count($row) / 2); ?>