/// lista diadromon
$query = "SELECT dia_id, dia_order, dia_name_".$_SESSION["interface_lang"]." as dia_name FROM ".$db_prefix."douknow_titles ORDER BY dia_order";
$result = mysql_query($query);
$i = 0;
$ii = 1;
WHILE ($i = mysql_fetch_array($result))
{
$dia_id = $i["dia_id"];
$dia_order = $i["dia_order"];
$dia_name = $i["dia_name"];
?>
|
}?>
|
|
/// naidem 1 diadromi
if (!isset($_GET["dia_id"]) || intval($_GET["dia_id"]) < 0 )
$query_first = "SELECT dia_id, dia_name_".$_SESSION["interface_lang"]." as dia_name, dia_text_".$_SESSION["interface_lang"]." as dia_text FROM ".$db_prefix."douknow_titles where dia_order=1";
else
$query_first = "SELECT dia_id, dia_name_".$_SESSION["interface_lang"]." as dia_name, dia_text_".$_SESSION["interface_lang"]." as dia_text FROM ".$db_prefix."douknow_titles where dia_id=".intval($_GET["dia_id"]);
$result_first = mysql_query($query_first) or die (mysql_error());
$row = mysql_fetch_array($result_first);
$dia_id_first = $row["dia_id"];
$dia_name_first = $row["dia_name"];
$dia_text_first = $row["dia_text"];
?>
// naidem vse fotki v etom kyrse
$result2 = mysql_query("SELECT * FROM ".$db_prefix."douknow_photos where id_dia = '".$dia_id_first."' order by photo_ord");
$n=0;
while ($i = mysql_fetch_array($result2))
{
$id_photo = $i["id"];
$img_photo = $i["photo"];
$descr_photo = $i["descr"];
?>
|
$n++;
}?>
|
|
|
|