السلام عليكم ورحمة اللة وبركاتة
ما هو افضل حل لتقليل هذة الأستعلامات
ارجو من محترفين sql افادتى
الجدوال :-
table -> sections_makal
-> id
-> date
-> name
------------------------
table -> makal
-> id
-> date
-> name
-> details
------------------------
table -> sections_mobile
-> id
-> date
-> name
------------------------
table -> mobile
-> id
-> date
-> name
-> details
------------------------
table -> sections_photos
-> id
-> date
-> name
------------------------
table -> photos
-> id
-> date
-> name
-> details
<?
$sql_a = mysql_query("select * from `sections_makal` order by id desc");
while($row_a = mysql_fetch_array($sql_a)){
$sql_makal = mysql_query("select from `makal` where id='$row_a[id]' order by id desc");
while($row = mysql_fetch_array($sql_makal)){
echo $row[id]." - "$row[name];
}
echo "\n".'<br />'."\n";
}
$sql_b = mysql_query("select * from `sections_mobile` order by id desc");
while($row_b = mysql_fetch_array($sql_b)){
$sql_mobile = mysql_query("select from `mobile` where id='$row_b[id]' order by id desc");
while($row = mysql_fetch_array($sql_mobile)){
echo $row[id]." - "$row[name];
}
echo "\n".'<br />'."\n";
}
$sql_c = mysql_query("select * from `sections_photos` order by id desc");
while($row_c = mysql_fetch_array($sql_c)){
$sql_photos = mysql_query("select from `photos` where id='$row_c[id]' order by id desc");
while($row = mysql_fetch_array($sql_photos)){
echo $row[id]." - "$row[name];
}
echo "\n".'<br />'."\n";
}
?>