Optimering af SQL udtræk
HejJeg har et site som laver følgende sql udtræk:
select fromdate from galleri where fromdate>'$xdate' group by fromdate order by fromdate desc
For hvert af disse resultater laver den så dette udtræk:
select galleri.itemno as ItemNo, Name, City from galleri,places,postnr where postnr.zip=places.zip and galleri.visible>=$accesslevel and galleri.PlaceNo=places.ItemNo and galleri.FromDate='$row_days[fromdate]' group by galleri.PlaceNo, galleri.Serie order by $orderby
I php ser det sådan her ud:
$days = mysql_query("select fromdate from galleri where fromdate>'$xdate' group by fromdate order by fromdate desc");
while($row_days = mysql_fetch_array($days))
{
$day=getdaystr($row_days['fromdate']);
print("$day");
$images = mysql_query("select galleri.itemno as ItemNo, Name, City from galleri,places,postnr where postnr.zip=places.zip and galleri.visible>=$accesslevel and galleri.PlaceNo=places.ItemNo and galleri.FromDate='$row_days[fromdate]' group by galleri.PlaceNo, galleri.Serie order by places.name asc");
while($row_images = mysql_fetch_array($images))
{
print("$row_images[ItemNo]");
print("$row_images[Name]");
print("$row_images[City]");
}
}
Spørgsmålet er så kan jeg lave alt dette i et udtræk???
