include "conf.php"; if ( $id == "" ) { echo "?";exit; }; $hostname = "localhost"; $username = "vva"; $password = "olis34x"; $dbName = "uz_vva"; $userstable = "crimea_photo"; MYSQL_CONNECT($hostname,$username,$password) OR DIE("Не могу создать соединение "); @mysql_select_db("$dbName") or die("Не могу выбрать базу данных "); #$query = "SELECT * FROM $userstable WHERE id = \"$id\""; #$query = "SELECT * FROM crimea_photo, crimea_photo_autor WHERE crimea_photo.id = \"$id\" and crimea_photo.user=crimea_photo_autor.user and crimea_photo.razdel = \"$razdel\""; $query = "SELECT * FROM crimea_photo WHERE id = \"$id\" and razdel = \"$razdel\""; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); if ( $k == 0 ) { echo "Нет такого id$id$razdel$result";exit; }; include "head.html"; $photo_name = mysql_result($result,0,"photo_name"); $photo_comm = mysql_result($result,0,"photo_comm"); $x = mysql_result($result,0,"x"); $y = mysql_result($result,0,"y"); $user_filename = mysql_result($result,0,"user_filename"); $user = mysql_result($result,0,"user"); $query = "SELECT * FROM crimea_photo_autor WHERE user = \"$user\""; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); $autor = mysql_result($result,0,"autor"); $town = mysql_result($result,0,"town"); $email = mysql_result($result,0,"email"); $url = mysql_result($result,0,"url"); $query = "SELECT id FROM $userstable WHERE p > 0 and razdel = \"$razdel\" order by id ASC"; $result = MYSQL_QUERY($query); $k = MYSQL_NUMROWS($result); $i=1; while ( $i < $k - 1 ) { $idn = mysql_result($result,$i,"id"); if ( $id == $idn ) { $id_next = mysql_result($result,$i - 1,"id"); $id_prev = mysql_result($result,$i + 1,"id"); }; $i++; }; #where i в начало назад вперед"; echo ' '; echo "Автор фотографии: $autor "; if ( $town != "" ) { echo "город: $town "; }; echo "email: $email"; if ( $url != "" ) { echo " URL: $url"; }; echo ''; if ( $photo_comm != "" ) { echo "Коментарий: $photo_comm"; }; if ( $photo_comm == "" ) { echo "Коментарий: $photo_name"; }; echo ''; mysql_close(); include "tail.html"; ?>