Code: Select all
$result = mysql_query("SELECT * FROM `categories` ORDER BY `title` ASC LIMIT 0 , 1000000");
echo mysql_error();
if (mysql_num_rows($result) <> '') {
$categories_total = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
if($row['parent'] == $id){
$row["links_num"] = mysql_num_rows(mysql_query("SELECT * FROM links WHERE `visible` = '1' AND `category_id` = '".$row['id']."' LIMIT 0 , 3000000"));
$categories[] = $row;
$query_subs = "SELECT * FROM `categories` WHERE `parent` = ".$row['id']." ORDER BY `title` LIMIT 0 , 4";
$result_subs = mysql_query($query_subs);
echo mysql_error();
while ($row_subs = mysql_fetch_array($result_subs)) {
$sub_cats[] = $row_subs;
}
}
}
}