Новости
Документация
Download
Webboard
Поиск
FAQ/ЧаВо
Обратная связь




MySQL.RU - Webboard



Вернуться
Запутался с запросом PHP для MySql (v_OK) 09/04/2007 - 11:53:14
      Re: Запутался с запросом PHP для MySql (v_OK) 09/04/2007 - 13:17:34

> Original message text:
> From: v_OK - 09/04/2007 - 11:53:14
> Subject:Запутался с запросом PHP для MySql
> -----------------
> Есть таблица subtype с категориями товаров (создание, редактирование, удаление)
>
> // ----table subtype ----
>
> <?php
>
> $lang = "ru";
> include("adminlib.inc.php");
> include("sys/datepicker.lib.php");
> include("../sys/lib/magic_quotes.inc.php");
> include("../sys/lib/str.lib.php");
> include("../sys/wares/wares.def.php");
>
> checkAdminLogin();
> dbConnect();
>
> // --- GET VARS ---
> $action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
> $id = @$HTTP_GET_VARS['id'];
> $id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
>
> // --- POST VARS ---
> $title_ru = trim(@$HTTP_POST_VARS['title_ru']); if(!$title_ru) $title_ru = "-";
> $prev = @$HTTP_POST_VARS['prev']; $prev_file = @$HTTP_POST_FILES['prev_file']['tmp_name'];
> $title_lv = trim(@$HTTP_POST_VARS['title_lv']); if(!$title_lv) $title_lv = "-";
> //$title_en = trim(@$HTTP_POST_VARS['title_en']); if(!$title_en) $title_en = "-";
> $title = $title_ru . "##" . $title_lv . "##" . $title_en;
> $ord = @$HTTP_POST_VARS['ord'];
>
> // ------------------------------ DELETE RECORD ------------------------------
> if($action == "delete" && $id) {
> $result = deleteRecord("subtypes", $id);
> if($result == "ok") {
> $query = "DELETE FROM wares WHERE id_subtype='$id'";
> mysql_query($query);
> }
> $action = "index";
> unset($id);
> }
> // ------------------------------ ADD NEW RECORD ------------------------------
> elseif($action == "add") {
> // kodiruem dannie
> $title = convHEX2Letters($title);
> $variables = array("title");
> magic_quotes_encode();
> $query = "INSERT INTO subtypes SET id_type='$id_type', title='$title', ord='$ord'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ UPDATE RECORD ---------------------------------------------------
> elseif($action == "update" && $id) {
> // kodiruem dannie
> $title = convHEX2Letters($title);
> $variables = array("title");
> magic_quotes_encode();
> $query = "UPDATE subtypes SET title='$title', ord='$ord' WHERE id='$id'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ NEW/EDIT FORM ------------------------------
> if($action == "new" || ($action == "edit" && $id)) {
> if($action == "new") {
> $title_ru = "-";
> $title_lv = "-";
> $title_en = "-";
> $ord = 0;
> }
> if($action == "edit") {
> $query = "SELECT title, ord FROM subtypes WHERE id='$id'";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_errno() . ": " . mysql_error());
> }
> else {
> list($title, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title");
> magic_quotes_decode();
> list($title_ru, $title_lv, $title_en) = explode("##", $title);
> }
> }
>
> displayAdminHeader(strtoupper($action) . " - CATEGORY IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
> if($action == "new") $cAction = "add"; else $cAction = "update";
> echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id=$id\">\n";
> echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
> insertText("Title (Russian)", "title_ru", 80, 80);
> insertText("Title (Latvian)", "title_lv", 80, 80);
> //insertText("Title (English)", "title_en", 80, 80);
> insertText("Order Tag", "ord", 6, 6);
> insertButtons($action);
> echo "</table>\n";
> echo "</form>\n";
>
> displayMenu();
> displayAdminFooter();
> }
> // ------------------------------ INDEX -----------------------------------------------------
> if($action == "index") {
> $orderby = @$HTTP_GET_VARS['orderby'];
> if($orderby) $q_ord = "ORDER BY $orderby";
> else $q_ord = "ORDER BY ord";
> $query = "SELECT id, title, ord FROM subtypes WHERE id_type='$id_type' $q_ord";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_error());
> }
> else {
> displayAdminHeader("LIST OF CATEGORIES IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
>
> $nAffected = mysql_affected_rows();
> if(!$nAffected) {
> printLN();
> echo "<h4>No records in <b>SUBTYPES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
> printLN();
> }
> else {
> echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
> echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
> printTableHdr();
>
> for($i = 1; $i <= $nAffected; $i++) {
> list($id, $title, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title");
> magic_quotes_decode();
> list($title_ru, $title_lv, $title_en) = explode("##", $title);
>
> $cl_data = $i % 2 == 0 ? "gray" : "dgray";
>
> echo "<tr>\n";
> echo "<td class=$cl_data>" . $id . "</td>\n";
> echo "<td class=ops align=center><a href=\"?lang=$lang&action=edit&id_type=$id_type&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
> echo "<td class=\"$cl_data\">" . $title_ru . "</td>\n";
> echo "<td class=\"$cl_data\">" . $title_lv . "</td>\n";
> echo "<td class=\"$cl_data\">" . $title_en . "</td>\n";
> echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
> echo "</tr>\n";
> }
> printTableHdr();
> echo "</table><br><br></div>\n";
> }
> }
> displayMenu();
> displayAdminFooter();
> }
>
> // --------------------------------- MENU --------------------------------------------------
> function displayMenu()
> {
> global $lang, $id_type;
>
> echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\n";
> echo "<tr>\n";
> echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
> echo "<a href=\"?lang=$lang&id_type=$id_type&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
> echo "<a href=\"?lang=$lang&id_type=$id_type\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
> echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
> echo "</tr>\n";
> echo "</table>\n";
> }
>
> function printTableHdr()
> {
> global $lang, $id_type, $DEF;
>
> echo "<tr>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=id>ID</a></td>\n";
> echo " <td class=head>Ops</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=title>TITLE (RUSSIAN)</a></td>\n";
> echo " <td class=head>TITLE (LATVIAN)</td>\n";
> //echo " <td class=head>TITLE (ENGLISH)</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=ord>ORDER</a></td>\n";
> echo "</tr>\n";
> }
> ?>
> // ----end table subtype ----
>
>
>
> есть таблица wares для добавления в выбранную категорию товаров (создание, редактирование, удаление)
>
>
> // ----start table wares ----
>
> <?php
>
> include("adminlib.inc.php");
> include("sys/datepicker.lib.php");
> include("../sys/lib/magic_quotes.inc.php");
> include("../sys/lib/str.lib.php");
> include("../sys/wares/wares.def.php");
> include("../sys/foto/foto.def.php");
> include("sys/htmlarea/htmlarea.lib.php");
>
> checkAdminLogin();
> dbConnect();
>
> // --- GET VARS ---
> $action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
> $id = @$HTTP_GET_VARS['id'];
> $id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
> $id_subtype = @$HTTP_GET_VARS['id_subtype'];
> $id_foto = @$HTTP_GET_VARS['id_foto'];
> $DEF_PATH = "res/wares";
>
> // --- POST VARS ---
> $title = trim(@$HTTP_POST_VARS['title']);
> $spopup = @$HTTP_POST_VARS['spopup']; $spopup_file = @$HTTP_POST_FILES['spopup_file']['tmp_name'];
> $prev1 = @$HTTP_POST_VARS['prev1']; $prev1_file = @$HTTP_POST_FILES['prev1_file']['tmp_name'];
> $popup1 = @$HTTP_POST_VARS['popup1']; $popup1_file = @$HTTP_POST_FILES['popup1_file']['tmp_name'];
> $prev2 = @$HTTP_POST_VARS['prev2']; $prev2_file = @$HTTP_POST_FILES['prev2_file']['tmp_name'];
> $popup2 = @$HTTP_POST_VARS['popup2']; $popup2_file = @$HTTP_POST_FILES['popup2_file']['tmp_name'];
> $prev3 = @$HTTP_POST_VARS['prev3']; $prev3_file = @$HTTP_POST_FILES['prev3_file']['tmp_name'];
> $popup3 = @$HTTP_POST_VARS['popup3']; $popup3_file = @$HTTP_POST_FILES['popup3_file']['tmp_name'];
> $prev4 = @$HTTP_POST_VARS['prev4']; $prev4_file = @$HTTP_POST_FILES['prev4_file']['tmp_name'];
> $popup4 = @$HTTP_POST_VARS['popup4']; $popup4_file = @$HTTP_POST_FILES['popup4_file']['tmp_name'];
> $prev5 = @$HTTP_POST_VARS['prev5']; $prev5_file = @$HTTP_POST_FILES['prev5_file']['tmp_name'];
> $popup5 = @$HTTP_POST_VARS['popup5']; $popup5_file = @$HTTP_POST_FILES['popup5_file']['tmp_name'];
> $prev6 = @$HTTP_POST_VARS['prev6']; $prev6_file = @$HTTP_POST_FILES['prev6_file']['tmp_name'];
> $popup6 = @$HTTP_POST_VARS['popup6']; $popup6_file = @$HTTP_POST_FILES['popup6_file']['tmp_name'];
> $prev7 = @$HTTP_POST_VARS['prev7']; $prev7_file = @$HTTP_POST_FILES['prev7_file']['tmp_name'];
> $popup7 = @$HTTP_POST_VARS['popup7']; $popup7_file = @$HTTP_POST_FILES['popup7_file']['tmp_name'];
> $prev8 = @$HTTP_POST_VARS['prev8']; $prev8_file = @$HTTP_POST_FILES['prev8_file']['tmp_name'];
> $popup8 = @$HTTP_POST_VARS['popup8']; $popup8_file = @$HTTP_POST_FILES['popup8_file']['tmp_name'];
> $prev9 = @$HTTP_POST_VARS['prev9']; $prev9_file = @$HTTP_POST_FILES['prev9_file']['tmp_name'];
> $popup9 = @$HTTP_POST_VARS['popup9']; $popup9_file = @$HTTP_POST_FILES['popup9_file']['tmp_name'];
> $prev10 = @$HTTP_POST_VARS['prev10']; $prev10_file = @$HTTP_POST_FILES['prev10_file']['tmp_name'];
> $popup10 = @$HTTP_POST_VARS['popup10']; $popup10_file = @$HTTP_POST_FILES['popup10_file']['tmp_name'];
> $prev11 = @$HTTP_POST_VARS['prev11']; $prev11_file = @$HTTP_POST_FILES['prev11_file']['tmp_name'];
> $popup11 = @$HTTP_POST_VARS['popup11']; $popup11_file = @$HTTP_POST_FILES['popup11_file']['tmp_name'];
> $prev_foto = @$HTTP_POST_VARS['prev_foto']; $prev_foto_file = @$HTTP_POST_FILES['prev_foto_file']['tmp_name'];
> $popup_foto = @$HTTP_POST_VARS['popup_foto']; $popup_foto_file = @$HTTP_POST_FILES['popup_foto_file']['tmp_name'];
> $descr = trim(@$HTTP_POST_VARS['descr']);
> $price = @$HTTP_POST_VARS['price'];
> $made = @$HTTP_POST_VARS['made'];
> $price2 = @$HTTP_POST_VARS['price2'];
> $size = @$HTTP_POST_VARS['size'];
> $date = getDateFromPicker("d", @$HTTP_POST_VARS['date']);
> $ord = @$HTTP_POST_VARS['ord'];
>
> // ------------------------------ UPLOADING PICTURES -------------------------
> $spopup = moveUploadedFile($spopup_file, $DEF_PATH, "spopup_file", $spopup); if($spopup == $DEF_PATH . "/") $spopup = "";
> $prev1 = moveUploadedFile($prev1_file, $DEF_PATH, "prev1_file", $prev1); if($prev1 == $DEF_PATH . "/") $prev1 = "";
> $popup1 = moveUploadedFile($popup1_file, $DEF_PATH, "popup1_file", $popup1); if($popup1 == $DEF_PATH . "/") $popup1 = "";
> $prev2 = moveUploadedFile($prev2_file, $DEF_PATH, "prev2_file", $prev2); if($prev2 == $DEF_PATH . "/") $prev2 = "";
> $popup2 = moveUploadedFile($popup2_file, $DEF_PATH, "popup2_file", $popup2); if($popup2 == $DEF_PATH . "/") $popup2 = "";
> $prev3 = moveUploadedFile($prev3_file, $DEF_PATH, "prev3_file", $prev3); if($prev3 == $DEF_PATH . "/") $prev3 = "";
> $popup3 = moveUploadedFile($popup3_file, $DEF_PATH, "popup3_file", $popup3); if($popup3 == $DEF_PATH . "/") $popup3 = "";
> $prev4 = moveUploadedFile($prev4_file, $DEF_PATH, "prev4_file", $prev4); if($prev4 == $DEF_PATH . "/") $prev4 = "";
> $popup4 = moveUploadedFile($popup4_file, $DEF_PATH, "popup4_file", $popup4); if($popup4 == $DEF_PATH . "/") $popup4 = "";
> $prev5 = moveUploadedFile($prev5_file, $DEF_PATH, "prev5_file", $prev5); if($prev5 == $DEF_PATH . "/") $prev5 = "";
> $popup5 = moveUploadedFile($popup5_file, $DEF_PATH, "popup5_file", $popup5); if($popup5 == $DEF_PATH . "/") $popup5 = "";
> $prev6 = moveUploadedFile($prev6_file, $DEF_PATH, "prev6_file", $prev6); if($prev6 == $DEF_PATH . "/") $prev6 = "";
> $popup6 = moveUploadedFile($popup6_file, $DEF_PATH, "popup6_file", $popup6); if($popup6 == $DEF_PATH . "/") $popup6 = "";
> $prev7 = moveUploadedFile($prev7_file, $DEF_PATH, "prev7_file", $prev7); if($prev7 == $DEF_PATH . "/") $prev7 = "";
> $popup7 = moveUploadedFile($popup7_file, $DEF_PATH, "popup7_file", $popup7); if($popup7 == $DEF_PATH . "/") $popup7 = "";
> $prev8 = moveUploadedFile($prev8_file, $DEF_PATH, "prev8_file", $prev8); if($prev8 == $DEF_PATH . "/") $prev8 = "";
> $popup8 = moveUploadedFile($popup8_file, $DEF_PATH, "popup8_file", $popup8); if($popup8 == $DEF_PATH . "/") $popup8 = "";
> $prev9 = moveUploadedFile($prev9_file, $DEF_PATH, "prev9_file", $prev9); if($prev9 == $DEF_PATH . "/") $prev9 = "";
> $popup9 = moveUploadedFile($popup9_file, $DEF_PATH, "popup9_file", $popup9); if($popup9 == $DEF_PATH . "/") $popup9 = "";
> $prev10 = moveUploadedFile($prev10_file, $DEF_PATH, "prev10_file", $prev10);if($prev10 == $DEF_PATH . "/") $prev10 = "";
> $popup10 = moveUploadedFile($popup10_file, $DEF_PATH, "popup10_file", $popup10); if($popup10 == $DEF_PATH . "/") $popup10 = "";
> $prev11 = moveUploadedFile($prev11_file, $DEF_PATH, "prev11_file", $prev11);if($prev11 == $DEF_PATH . "/") $prev11 = "";
> $popup11 = moveUploadedFile($popup11_file, $DEF_PATH, "popup11_file", $popup11); if($popup11 == $DEF_PATH . "/") $popup11 = "";
> $prev_foto = moveUploadedFile($prev_foto_file, $DEF_PATH, "prev_foto_file", $prev_foto);if($prev_foto == $DEF_PATH . "/") $prev_foto = "";
> $popup_foto = moveUploadedFile($popup_foto_file, $DEF_PATH, "popup_foto_file", $popup_foto); if($popup_foto == $DEF_PATH . "/") $popup_foto = "";
>
> // ------------------------------ DELETE RECORD ------------------------------
> if($action == "delete" && $id) {
> deleteRecord("wares", $id);
> $action = "index";
> unset($id);
> }
> // ------------------------------ ADD NEW RECORD ------------------------------
> elseif($action == "add") {
> // kodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_encode();
> $query = "INSERT INTO wares SET lang='$lang', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev1='$prev1', spopup='$spopup', popup1='$popup1', prev2='$prev2', popup2='$popup2', prev3='$prev3', popup3='$popup3', prev4='$prev4', popup4='$popup4', prev5='$prev5', popup5='$popup5', prev6='$prev6', popup6='$popup6', prev7='$prev7', popup7='$popup7', prev8='$prev8', popup8='$popup8', prev9='$prev9', popup9='$popup9', prev10='$prev10', popup10='$popup10', prev11='$prev11', popup11='$popup11', descr='$descr', pdf='$pdf', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ UPDATE RECORD ---------------------------------------------------
> elseif($action == "update" && $id) {
> // kodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_encode();
> $query = "UPDATE wares SET lang='$lang', id_type='$id_type', id_subtype='$id_subtype', title='$title', prev1='$prev1', spopup='$spopup', popup1='$popup1', prev2='$prev2', popup2='$popup2', prev3='$prev3', popup3='$popup3', prev4='$prev4', popup4='$popup4', prev5='$prev5', popup5='$popup5', prev6='$prev6', popup6='$popup6', prev7='$prev7', popup7='$popup7', prev8='$prev8', popup8='$popup8', prev9='$prev9', popup9='$popup9', prev10='$prev10', popup10='$popup10', prev11='$prev11', popup11='$popup11', descr='$descr', pdf='$pdf', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord' WHERE id='$id'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ NEW/EDIT FORM ------------------------------
> if($action == "new" || ($action == "edit" && $id)) {
> if($action == "new") {
> $spopup = $DEF_PATH . "/";
> $prev1 = $DEF_PATH . "/";
> $popup1 = $DEF_PATH . "/";
> $prev2 = $DEF_PATH . "/";
> $popup2 = $DEF_PATH . "/";
> $prev3 = $DEF_PATH . "/";
> $popup3 = $DEF_PATH . "/";
> $prev4 = $DEF_PATH . "/";
> $popup4 = $DEF_PATH . "/";
> $prev5 = $DEF_PATH . "/";
> $popup5 = $DEF_PATH . "/";
> $prev6 = $DEF_PATH . "/";
> $popup6 = $DEF_PATH . "/";
> $prev7 = $DEF_PATH . "/";
> $popup7 = $DEF_PATH . "/";
> $prev8 = $DEF_PATH . "/";
> $popup8 = $DEF_PATH . "/";
> $prev9 = $DEF_PATH . "/";
> $popup9 = $DEF_PATH . "/";
> $prev10 = $DEF_PATH . "/";
> $popup10 = $DEF_PATH . "/";
> $prev11 = $DEF_PATH . "/";
> $popup11 = $DEF_PATH . "/";
> $prev_foto = $DEF_PATH . "/prev/";
> $popup_foto = $DEF_PATH . "/";
> //$pdf = $DEF_PATH . "/";
> $date = date("Y-m-d");
> $ord = 0;
> }
> if($action == "edit") {
> $query = "SELECT title, title_foto, prev1, spopup, popup1, prev2, popup2, prev3, popup3, prev4, popup4, prev5, popup5, prev6, popup6, prev7, popup7, prev8, popup8, prev9, popup9, prev10, popup10, prev11, popup11, prev_foto, popup_foto, descr, pdf, price, made, price2, size, date, ord FROM wares WHERE id='$id'";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_errno() . ": " . mysql_error());
> }
> else {
> list($title, $title_foto, $prev1, $spopup, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $prev_foto, $popup_foto, $descr, $pdf, $price, $made, $price2, $size, $date, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_decode();
> }
> }
>
> displayAdminHeader(strtoupper($action) . " - WARE IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
> if($action == "new") $cAction = "add"; else $cAction = "update";
> echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id_subtype=$id_subtype&id=$id\" enctype=\"multipart/form-data\">\n";
> echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
> insertButtons($action);
> insertText("Title", "title", 255, 100);
> insertFile("Главная картинка (" . $DEF['WARE_PREV_W'] . "x" . $DEF['WARE_PREV_H'] . ")", "prev1", 180);
> insertFile("Средняя картинка (450 х 312)", "spopup", 100);
> insertHTMLArea("Description", "descr", "800", 200);
> insertFile("Картинка мал. 1 - 125x74 ", "prev2", 100);
> insertFile("Картинка бол. 1 - 800x600", "popup2", 100);
> insertFile("Картинка мал. 2 - 125x74 ", "prev3", 100);
> insertFile("Картинка бол. 2 - 800x600", "popup3", 100);
> insertFile("Картинка мал. 3 - 125x74 ", "prev4", 100);
> insertFile("Картинка бол. 3 - 800x600", "popup4", 100);
> insertFile("Картинка мал. 4 - 125x74 ", "prev5", 100);
> insertFile("Картинка бол. 4 - 800x600", "popup5", 100);
> insertFile("Картинка мал. 5 - 125x74 ", "prev6", 100);
> insertFile("Картинка бол. 5 - 800x600", "popup6", 100);
> insertFile("Картинка мал. 6 - 125x74 ", "prev7", 100);
> insertFile("Картинка бол. 6 - 800x600", "popup7", 100);
> insertFile("Картинка мал. 7 - 125x74 ", "prev8", 100);
> insertFile("Картинка бол. 7 - 800x600", "popup8", 100);
> insertFile("Картинка мал. 8 - 125x74 ", "prev9", 100);
> insertFile("Картинка бол. 8 - 800x600", "popup9", 100);
> insertFile("Картинка мал. 9 - 125x74 ", "prev10", 100);
> insertFile("Картинка бол. 9 - 800x600", "popup10", 100);
> insertFile("Картинка мал. 10 - 125x74 ", "prev11", 100);
> insertFile("Картинка бол. 10 - 800x600", "popup11", 100);
> insertText("Производитель", "made", 50, 50);
> insertText("Цена", "price", 50, 50);
> insertText("Название элемента", "title_foto", 255, 100);
> insertFile("Картинка мал. (" . $LNG['FOTO_PREV_W'] . "x" . $LNG['FOTO_PREV_H'] . ")", "prev_foto", 100);
> insertFile("Картинка бол.", "popup_foto", 100);
> insertText("Размеры", "size", 50, 50);
> insertText("Цена элемента", "price2", 50, 50);
> insertDate("Date", "d", $date);
>
> insertText("Order Tag", "ord", 6, 6);
> insertButtons($action);
> echo "</table>\n";
> echo "</form>\n";
>
> displayMenu();
> displayAdminFooter();
> }
> // ------------------------------ INDEX -----------------------------------------------------
> if($action == "index") {
> displayAdminHeader("LIST OF WARES IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
>
> echo "<table width=100% border=0 cellpadding=5 cellspacing=0>\n";
> echo "<tr>\n";
> echo "<td bgcolor=#EEEEEE valign=top style='border-right: 1px solid #CCCCCC'>\n";
> $query = "SELECT id, title FROM subtypes WHERE id_type='$id_type' ORDER BY ord";
> if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
> for($i = 0; $i < $iAff; $i++) {
> list($id, $title) = mysql_fetch_row($r);
>
> $variables = array("title");
> magic_quotes_decode();
> $title = splitTextIntoLang($title, "##", $lang);
> if($id == $id_subtype) {
> echo "<li><b>" . $title . "</b>";
> }
> else {
> echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id>" . $title . "</a>";
> // echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id>" . $title . "</a>";
> }
>
> }
> }
> echo "</td>\n";
>
> echo "<td valign=top>\n";
> $orderby = @$HTTP_GET_VARS['orderby'];
> if($orderby) $q_ord = "ORDER BY $orderby";
> else $q_ord = "ORDER BY ord";
> $query = "SELECT id, title, title_foto, spopup, prev1, popup1, prev2, popup2, prev3, popup3, prev4, popup4, prev5, popup5, prev6, popup6, prev7, popup7, prev8, popup8, prev9, popup9, prev10, popup10, prev11, popup11, prev_foto, popup_foto, MID(descr, 1, 32), price, made, price2, size, DATE_FORMAT(date, '%d.%m.%Y'), ord FROM wares WHERE lang='$lang' && id_type='$id_type' && id_subtype='$id_subtype' && id_foto='$id_foto' $q_ord";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_error());
> }
> else {
> $nAffected = mysql_affected_rows();
> if(!$nAffected) {
> printLN();
> //echo "<h4>No records in <b>WARES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
> printLN();
> }
> else {
> echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
> echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
> printTableHdr();
>
> for($i = 1; $i <= $nAffected; $i++) {
> list($id, $title, $spopup, $prev1, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $elemprev, $elempopup, $descr, $pdf, $price, $price2, $size, $date, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_decode();
>
> $prev1 = (file_exists("../$prev1") && $prev1 ? "<img src=\"../" . $prev1 . "\" border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>" : "x<br>$prev1");
> $prev2 = (file_exists("../$prev2") && $prev2 ? "<img src=\"../" . $prev2 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev2");
> $prev3 = (file_exists("../$prev3") && $prev3 ? "<img src=\"../" . $prev3 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev3");
> $prev4 = (file_exists("../$prev4") && $prev4 ? "<img src=\"../" . $prev4 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev4");
> $prev5 = (file_exists("../$prev5") && $prev5 ? "<img src=\"../" . $prev5 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev5");
> $prev6 = (file_exists("../$prev6") && $prev6 ? "<img src=\"../" . $prev6 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev6");
> $prev7 = (file_exists("../$prev7") && $prev7 ? "<img src=\"../" . $prev7 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev7");
> $prev8 = (file_exists("../$prev8") && $prev8 ? "<img src=\"../" . $prev8 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev8");
> $prev9 = (file_exists("../$prev9") && $prev9 ? "<img src=\"../" . $prev9 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev9");
> $prev10 = (file_exists("../$prev10") && $prev10 ? "<img src=\"../" . $prev10 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev10");
> $prev11 = (file_exists("../$prev11") && $prev11 ? "<img src=\"../" . $prev11 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev11");
> //$elemprev = (file_exists("../$elemprev") && $elemprev && substr($elemprev, -1) != "/" ? "<img src=\"../" . $elemprev . "\" border=1 width=40 height=30 alt=''>" : "x<br>$elemprev");
> //$pdf = (file_exists("../$pdf") && $pdf && substr($pdf, -1) != "/" ? "<a href='../$pdf' target=_blank>$pdf</a>" : "<font color=red>Bad file link</font><br>$pdf");
> $cl_data = $i % 2 == 0 ? "gray" : "dgray";
>
> echo "<tr>\n";
> echo "<td class=$cl_data>" . $id . "</td>\n";
> echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
> //echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit_foto&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit Foto></a> | <a href=\"?lang=$lang&action=delete_foto&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete Foto></a></td>\n";
> echo "<td class=\"$cl_data\">" . $title . "</td>\n";
> echo "<td class=\"$cl_data\" align=center>" . $prev1 . "</td>\n";
> //echo "<td class=\"$cl_data\"><a href='../" . $spopup . "' target=_blank>" . $spopup . "</a><br><a href='../" . $popup1 . "' target=_blank>" . $popup1 . "</a><br><a href='../" . $popup2 . "' target=_blank>" . $popup2 . "</a><br><a href='../" . $popup3 . "' target=_blank>" . $popup3 . "</a><br><a href='../" . $popup4 . "' target=_blank>" . $popup4 . "</a><br><a href='../" . $popup5 . "' target=_blank>" . $popup5 . "</a><br><a href='../" . $popup6 . "' target=_blank>" . $popup6 . "</a><br><a href='../" . $popup7 . "' target=_blank>" . $popup7 . "</a><br><a href='../" . $popup8 . "' target=_blank>" . $popup8 . "</a><br><a href='../" . $popup9 . "' target=_blank>" . $popup9 . "</a><br><a href='../" . $popup10 . "' target=_blank>" . $popup10 . "</a></td>\n";
> echo "<td class=\"$cl_data\">" . strip_tags($descr) . "...</td>\n";
> echo "<td class=\"$cl_data\">" . $price . "</td>\n";
> //echo "<td class=\"$cl_data\">" . $made . "</td>\n";
> echo "<td class=\"$cl_data\">" . $date . "</td>\n";
> echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
> echo "</tr>\n";
> }
> printTableHdr();
> echo "</table><br><br></div>\n";
> }
> }
>
> echo "</td>\n";
> echo "</tr>\n";
> echo "</table>\n";
> displayMenu();
> displayAdminFooter();
> }
>
> // --------------------------------- MENU --------------------------------------------------
> function displayMenu()
> {
> global $lang, $id_type, $id_subtype;
>
> echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
> echo "<tr>\n";
> echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
> echo ($lang == "ru" ? "<b>Russian</b>" : "<a href=?lang=ru&id_type=$id_type&id_subtype=$id_subtype>RU</a>") . " | \n";
> echo ($lang == "lv" ? "<b>Latvian</b>" : "<a href=?lang=lv&id_type=$id_type&id_subtype=$id_subtype>LV</a>") . " | \n";
> if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
> // if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&action=new_foto\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Elements</a> |\n";
> if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
> echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
> echo "</tr>\n";
> echo "</table>\n";
> }
>
> function printTableHdr()
> {
> global $lang, $id_type, $id_subtype, $DEF;
>
> echo "<tr>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=id>ID</a></td>\n";
> echo " <td class=head>Ops</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=title>TITLE</a></td>\n";
> echo " <td class=head>FOTO</td>\n";
> echo " <td class=head>POPUPS</td>\n";
> //echo " <td class=head>MADE</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=descr>DESCR</a></td>\n";
> //echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=pdf>MADE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=price>PRICE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=date>DATE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=ord>ORDER</a></td>\n";
> echo "</tr>\n";
> }
>
> //start foto
>
> //end foto
> ?>
> // ----end table wares ----
>
>
>
> есть таблица wares2 для добавления в выбранную категорию дополнительного ассортимента товаров
>
>
>
> //----table wares2-----
> <?php
>
> include("adminlib.inc.php");
> include("sys/datepicker.lib.php");
> include("../sys/lib/magic_quotes.inc.php");
> include("../sys/lib/str.lib.php");
> include("../sys/wares/wares.def.php");
> include("../sys/foto/foto.def.php");
> include("sys/htmlarea/htmlarea.lib.php");
>
> checkAdminLogin();
> dbConnect();
>
> // --- GET VARS ---
> $action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
> $id = @$HTTP_GET_VARS['id'];
> $id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
> $id_subtype = @$HTTP_GET_VARS['id_subtype'];
> $id_foto = @$HTTP_GET_VARS['id_foto'];
> $DEF_PATH = "res/wares2";
>
> // --- POST VARS ---
> $title = trim(@$HTTP_POST_VARS['title']);
> $prev_foto = @$HTTP_POST_VARS['prev_foto']; $prev_foto_file = @$HTTP_POST_FILES['prev_foto_file']['tmp_name'];
> $popup_foto = @$HTTP_POST_VARS['popup_foto']; $popup_foto_file = @$HTTP_POST_FILES['popup_foto_file']['tmp_name'];
> $descr = trim(@$HTTP_POST_VARS['descr']);
> $price = @$HTTP_POST_VARS['price'];
> $made = @$HTTP_POST_VARS['made'];
> $price2 = @$HTTP_POST_VARS['price2'];
> $size = @$HTTP_POST_VARS['size'];
> $date = getDateFromPicker("d", @$HTTP_POST_VARS['date']);
> $ord = @$HTTP_POST_VARS['ord'];
>
> // ------------------------------ UPLOADING PICTURES -------------------------
> $prev_foto = moveUploadedFile($prev_foto_file, $DEF_PATH, "prev_foto_file", $prev_foto);if($prev_foto == $DEF_PATH . "/") $prev_foto = "";
> $popup_foto = moveUploadedFile($popup_foto_file, $DEF_PATH, "popup_foto_file", $popup_foto); if($popup_foto == $DEF_PATH . "/") $popup_foto = "";
>
> // ------------------------------ DELETE RECORD ------------------------------
> if($action == "delete" && $id) {
> deleteRecord("wares2", $id);
> $action = "index";
> unset($id);
> }
> // ------------------------------ ADD NEW RECORD ------------------------------
> elseif($action == "add") {
> // kodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_encode();
> $query = "INSERT INTO wares2 SET lang='$lang', id='$id', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev_foto='$prev_foto', popup_foto='$popup_foto', descr='$descr', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ UPDATE RECORD ---------------------------------------------------
> elseif($action == "update" && $id) {
> // kodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_encode();
> $query = "UPDATE wares2 SET lang='$lang', id='$id', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev_foto='$prev_foto', popup_foto='$popup_foto', descr='$descr', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord' WHERE id='$id'";
> if(!mysql_query($query)) printMySqlError();
> else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&PHPSESSID=$PHPSESSID");
> exit;
> }
> // ------------------------------ NEW/EDIT FORM ------------------------------
> if($action == "new" || ($action == "edit" && $id )) {
> if($action == "new") {
> $spopup = $DEF_PATH . "/";
> $prev1 = $DEF_PATH . "/";
> $popup1 = $DEF_PATH . "/";
> $prev_foto = $DEF_PATH . "/prev/";
> $popup_foto = $DEF_PATH . "/";
> //$pdf = $DEF_PATH . "/";
> $date = date("Y-m-d");
> $ord = 0;
> }
> if($action == "edit") {
> $query = "SELECT title, title_foto, prev_foto, popup_foto, descr, price, made, price2, size, date, ord FROM wares2 WHERE id='$id'";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_errno() . ": " . mysql_error());
> }
> else {
> list($title, $title_foto, $prev_foto, $popup_foto, $descr, $price, $made, $price2, $size, $date, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_decode();
> }
> }
>
> displayAdminHeader(strtoupper($action) . " - WARE IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
> if($action == "new") $cAction = "add"; else $cAction = "update";
> echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto\" enctype=\"multipart/form-data\">\n";
> echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
> insertButtons($action);
> //insertText("Title", "title", 255, 100);
> //insertText("Производитель", "made", 50, 50);
> //insertText("Цена", "price", 50, 50);
> insertText("Название элемента", "title", 255, 100);
> insertFile("Картинка мал. (" . $LNG['FOTO_PREV_W'] . "x" . $LNG['FOTO_PREV_H'] . ")", "prev_foto", 100);
> insertFile("Картинка бол.", "popup_foto", 100);
> insertText("Размеры", "size", 50, 50);
> insertText("Цена элемента", "price2", 50, 50);
> insertDate("Date", "d", $date);
>
> insertText("Order Tag", "ord", 6, 6);
> insertButtons($action);
> echo "</table>\n";
> echo "</form>\n";
>
> displayMenu();
> displayAdminFooter();
> }
> // ------------------------------ INDEX -----------------------------------------------------
> if($action == "index") {
> displayAdminHeader("LIST OF wares2 IN " . $DEF['WARES_TYPES'][$id_type]);
> displayMenu();
>
> echo "<table width=100% border=0 cellpadding=5 cellspacing=0>\n";
> echo "<tr>\n";
> echo "<td bgcolor=#EEEEEE valign=top style='border-right: 1px solid #CCCCCC'>\n";
> $query = "SELECT id, id_subtype, id_foto, title FROM wares WHERE id_type='$id_type' ORDER BY ord";
> if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
> for($i = 0; $i < $iAff; $i++) {
> list($id, $id_subtype, $id_foto, $title) = mysql_fetch_row($r);
>
> $variables = array("title");
> magic_quotes_decode();
> $title = splitTextIntoLang($title, "##", $lang);
> if($id == $id_subtype ) {
> echo "<li><b>" . $title . "</b>";
> }
> else {
> echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id>" . $title . "</a>";
> //echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id>" . $title . "</a>";
> // echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id>" . $title . "</a>";
> }
>
> }
> }
> echo "</td>\n";
>
> echo "<td valign=top>\n";
> $orderby = @$HTTP_GET_VARS['orderby'];
> if($orderby) $q_ord = "ORDER BY $orderby";
> else $q_ord = "ORDER BY ord";
> $query = "SELECT id, title, title_foto, prev_foto, popup_foto, MID(descr, 1, 32), price, made, price2, size, DATE_FORMAT(date, '%d.%m.%Y'), ord FROM wares2 WHERE lang='$lang' && id='$id' && id_type='$id_type' && id_subtype='$id_subtype' && id_foto='$id_foto' $q_ord";
> if(!($result = mysql_query($query))) {
> displayAdminError(mysql_error());
> }
> else {
> $nAffected = mysql_affected_rows();
> if(!$nAffected) {
> printLN();
> //echo "<h4>No records in <b>WARES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
> printLN();
> }
> else {
> echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
> echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
> printTableHdr();
>
> for($i = 1; $i <= $nAffected; $i++) {
> list($id, $title, $prev_foto, $popup_foto, $descr, $price, $price2, $size, $date, $ord) = mysql_fetch_row($result);
> // dekodiruem dannie
> $variables = array("title", "descr");
> magic_quotes_decode();
>
> $prev_foto = (file_exists("../$prev_foto") && $prev_foto ? "<img src=\"../" . $prev_foto . "\" border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>" : "x<br>$prev_foto");
> $cl_data = $i % 2 == 0 ? "gray" : "dgray";
>
> echo "<tr>\n";
> echo "<td class=$cl_data>" . $id . "</td>\n";
> echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
> echo "<td class=\"$cl_data\">" . $title . "</td>\n";
> echo "<td class=\"$cl_data\" align=center>" . $prev_foto . "</td>\n";
> echo "<td class=\"$cl_data\">" . strip_tags($descr) . "...</td>\n";
> echo "<td class=\"$cl_data\">" . $price . "</td>\n";
> echo "<td class=\"$cl_data\">" . $date . "</td>\n";
> echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
> echo "</tr>\n";
> }
> printTableHdr();
> echo "</table><br><br></div>\n";
> }
> }
>
> echo "</td>\n";
> echo "</tr>\n";
> echo "</table>\n";
> displayMenu();
> displayAdminFooter();
> }
>
> // --------------------------------- MENU --------------------------------------------------
> function displayMenu()
> {
> global $lang, $id, $id_type, $id_subtype, $id_foto;
>
> echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
> echo "<tr>\n";
> echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
> echo ($lang == "ru" ? "<b>Russian</b>" : "<a href=?lang=ru&id_type=$id_type&id_subtype=$id_subtype>RU</a>") . " | \n";
> echo ($lang == "lv" ? "<b>Latvian</b>" : "<a href=?lang=lv&id_type=$id_type&id_subtype=$id_subtype>LV</a>") . " | \n";
> if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
> // if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&action=new_foto\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Elements</a> |\n";
> if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&id_foto=$id_foto\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
> echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
> echo "</tr>\n";
> echo "</table>\n";
> }
>
> function printTableHdr()
> {
> global $lang, $id, $id_type, $id_subtype, $id_foto, $DEF;
>
> echo "<tr>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=id>ID</a></td>\n";
> echo " <td class=head>Ops</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=title>TITLE</a></td>\n";
> //echo " <td class=head>FOTO</td>\n";
> echo " <td class=head>POPUPS</td>\n";
> //echo " <td class=head>MADE</td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=descr>DESCR</a></td>\n";
> //echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=pdf>MADE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=price>PRICE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=date>DATE</a></td>\n";
> echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=ord>ORDER</a></td>\n";
> echo "</tr>\n";
> }
>
> ?>
> //----end table wares2-----
>
>
> не могу создать запрос с выводом дополнительного ассортимента товаров
>
>
>
> //----страница вывода запросов-----
>
>
> <?php
>
> $id = @$HTTP_GET_VARS['id']; if(!$id) return;
>
> $query = "SELECT wares.id, wares.id_subtype, wares.title, wares.title_foto, wares.prev1, wares.spopup, wares.popup1, wares.prev2, wares.popup2, wares.prev3, wares.popup3, wares.prev4, wares.popup4, wares.prev5, wares.popup5, wares.prev6, wares.popup6, wares.prev7, wares.popup7, wares.prev8, wares.popup8, wares.prev9, wares.popup9, wares.prev10, wares.popup10, wares.prev11, wares.popup11, wares.prev_foto, wares.popup_foto, wares.descr, wares.price, wares.size, wares.price2, subtypes.title, DATE_FORMAT(wares.date, '%d.%m.%Y') " .
> "FROM wares, subtypes " .
> "WHERE wares.lang='$lang' && wares.id='$id' && wares.id_subtype=subtypes.id ";
>
> if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
> list($id, $id_subtype, $title, $stitle, $prev1, $spopup, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $prev_foto, $popup_foto, $descr, $pdf, $price, $price2, $size, $stitle, $date) = mysql_fetch_row($r);
> $variables = array("title", "stitle", "descr");
> magic_quotes_decode();
> $stitle = splitTextIntoLang($stitle, "##", $lang);
> if(fileExists($prev1)) {
> $prev1 = "<img src='" . $prev1 . "' border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>";
> }
> else {
> $prev1 = "";
> }
>
> if(fileExists($prev2)) {
> $prev2 = "<img src='" . $prev2 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev2 = "";
> }
>
> if(fileExists($prev3)) {
> $prev3 = "<img src='" . $prev3 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev3 = "";
> }
> if(fileExists($prev4)) {
> $prev4 = "<img src='" . $prev4 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev4 = "";
> }
> if(fileExists($prev5)) {
> $prev5 = "<img src='" . $prev5 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev5 = "";
> }
> if(fileExists($prev6)) {
> $prev6 = "<img src='" . $prev6 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev6 = "";
> }
> if(fileExists($prev7)) {
> $prev7 = "<img src='" . $prev7 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev7 = "";
> }
> if(fileExists($prev8)) {
> $prev8 = "<img src='" . $prev8 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev8 = "";
> }
> if(fileExists($prev9)) {
> $prev9 = "<img src='" . $prev9 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev9 = "";
> }
> if(fileExists($prev10)) {
> $prev10 = "<img src='" . $prev10 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev10 = "";
> }
> if(fileExists($prev11)) {
> $prev11 = "<img src='" . $prev11 . "' border=1 width=\"125\" height=\"74\" alt=''>";
> }
> else {
> $prev11 = "";
> }
> if(fileExists($prev_foto)) {
> $prev_foto = "<img src='" . $prev_foto . "' border=1 width=\"100\" height=\"80\" alt=''>";
> }
> else {
> $prev_foto = "";
> }
>
>
> //start new
> echo " <br>\n";
> echo " <tr>\n";
> echo " <td class=\"producttitle\" colspan=\"3\"><span class=\"featureYourPrice\">      " . $LNG['WARES_TYPES'][$id_type] . " /  <a href=index.php?lang=$lang&p=$p&id_type=$id_type&id_subtype=$id_subtype>" . $LNG['WARES_BACK'] . "</a></span><br /></td>\n";
> echo " </tr>\n";
> echo "<table cellspacing=\"0\" cellpadding=\"0\" width=\"760\" border=\"0\" align=center>\n";
> echo " <tbody>\n";
> echo "<p><br></p>\n";
> echo " <div class=\"producttitle\" colspan=\"3\" align=center><span class=\"ch\">$title\n";
> if($price > 0) {
> echo "<div style=''>\n";
> echo $LNG['WARES_PRICE'] . " : Ls " . sprintf("%0.2f", $price) . "</b>";
> echo "</div>\n";
> echo " </span></div>\n";
> }
> echo " <tr>\n";
> echo " <td valign=\"center\" colspan=2 height=328 align=top><p align=\"center\"><span style=\"FONT-WEIGHT: 100\">\n";
> echo " <img height=\"312\"\n";
> echo " src=$spopup\n";
> echo " width=\"450\" border=\"0\" /></a></span></p></td>\n";
> echo " <td width=\"289\" height=\"454\" rowspan=\"2\" valign=\"top\"><table id=\"AutoNumber2\"\n";
> echo " style=\"BORDER-COLLAPSE: collapse\"\n";
> echo " bordercolor=\"#111111\" cellspacing=\"3\" cellpadding=\"5\"\n";
> echo " width=\"100%\" border=\"0\">\n";
> echo " <tbody>\n";
> echo " <tr>\n";
>
> //pic1
> echo "<p><br></p>\n";
> echo " <TD vAlign=top align=top>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev2) {
> if(fileExists($popup2)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup2) . "','450','312','0');\">";
> $prev2 = $sLink . $prev2 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev2) {
> echo "<div style='margin-bottom: 2px;'>\n";
> echo $prev2;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 2px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //pic2
> echo " <TD vAlign=top align=top>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev3) {
> if(fileExists($popup3)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup3) . "','450','350','0');\">";
> $prev3 = $sLink . $prev3 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev3) {
> echo "<div style='margin-bottom: 2px;'>\n";
> echo $prev3;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 2px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> // end pic2
> echo " </tr>\n";
> echo " <tr>\n";
> //pic3
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev4) {
> if(fileExists($popup4)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup4) . "','450','350','0');\">";
> $prev4 = $sLink . $prev4 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev4) {
> echo "<div style='margin-bottom: 2px;'>\n";
> echo $prev4;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 2px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //end pic3
> //pic4
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev5) {
> if(fileExists($popup5)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup5) . "','450','350','0');\">";
> $prev5 = $sLink . $prev5 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev5) {
> echo "<div style='margin-bottom: 2px;'>\n";
> echo $prev5;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 2px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //end pic4
> echo " </tr>\n";
> echo " <tr>\n";
> //pic5
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev6) {
> if(fileExists($popup6)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup6) . "','450','350','0');\">";
> $prev6 = $sLink . $prev6 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev6) {
> echo "<div style='margin-bottom: 5px;'>\n";
> echo $prev6;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 5px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //end pic5
> //pic6
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev7) {
> if(fileExists($popup7)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup7) . "','450','350','0');\">";
> $prev7 = $sLink . $prev7 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev7) {
> echo "<div style='margin-bottom: 5px;'>\n";
> echo $prev7;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 5px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //end pic6
> echo " </tr>\n";
> echo " <tr>\n";
> //pic7
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev8) {
> if(fileExists($popup8)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup8) . "','450','350','0');\">";
> $prev8 = $sLink . $prev8 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> if($prev8) {
> echo "<div style='margin-bottom: 5px;'>\n";
> echo $prev8;
> echo "</div>\n";
> }
> else {
> echo "<div style='margin-bottom: 5px;'>\n";
> //echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
> echo "</div>\n";
> }
>
> echo " </TBODY></TABLE></TD>\n";
> //end pic7
> //pic8
> echo " <TD vAlign=top align=middle>\n";
> echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
> echo " border=0>\n";
> echo " <TBODY>\n";
> echo " <TR>\n";
> echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
> if($prev9) {
> if(fileExists($popup9)) {
> $sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup9) . "','450','350','0');\">";
> $prev9 = $sLink . $prev9 . "</a>";
> //$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
>
> }
> }
> i
>


From: v_OK - 09/04/2007 - 13:17:34
Subject:Запутался с запросом PHP для MySql
-----------------
Не влезло
Продолжаю
//----страница вывода запросов-----
<?php

$id = @$HTTP_GET_VARS['id']; if(!$id) return;

$query = "SELECT wares.id, wares.id_subtype, wares.title, wares.title_foto, wares.prev1, wares.spopup, wares.popup1, wares.prev2, wares.popup2, wares.prev3, wares.popup3, wares.prev4, wares.popup4, wares.prev5, wares.popup5, wares.prev6, wares.popup6, wares.prev7, wares.popup7, wares.prev8, wares.popup8, wares.prev9, wares.popup9, wares.prev10, wares.popup10, wares.prev11, wares.popup11, wares.prev_foto, wares.popup_foto, wares.descr, wares.price, wares.size, wares.price2, subtypes.title, DATE_FORMAT(wares.date, '%d.%m.%Y') " .
"FROM wares, subtypes " .
"WHERE wares.lang='$lang' && wares.id='$id' && wares.id_subtype=subtypes.id ";

if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
list($id, $id_subtype, $title, $stitle, $prev1, $spopup, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $prev_foto, $popup_foto, $descr, $pdf, $price, $price2, $size, $stitle, $date) = mysql_fetch_row($r);
$variables = array("title", "stitle", "descr");
magic_quotes_decode();
$stitle = splitTextIntoLang($stitle, "##", $lang);
if(fileExists($prev1)) {
$prev1 = "<img src='" . $prev1 . "' border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>";
}
else {
$prev1 = "";
}

if(fileExists($prev2)) {
$prev2 = "<img src='" . $prev2 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev2 = "";
}

if(fileExists($prev3)) {
$prev3 = "<img src='" . $prev3 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev3 = "";
}
if(fileExists($prev4)) {
$prev4 = "<img src='" . $prev4 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev4 = "";
}
if(fileExists($prev5)) {
$prev5 = "<img src='" . $prev5 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev5 = "";
}
if(fileExists($prev6)) {
$prev6 = "<img src='" . $prev6 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev6 = "";
}
if(fileExists($prev7)) {
$prev7 = "<img src='" . $prev7 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev7 = "";
}
if(fileExists($prev8)) {
$prev8 = "<img src='" . $prev8 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev8 = "";
}
if(fileExists($prev9)) {
$prev9 = "<img src='" . $prev9 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev9 = "";
}
if(fileExists($prev10)) {
$prev10 = "<img src='" . $prev10 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev10 = "";
}
if(fileExists($prev11)) {
$prev11 = "<img src='" . $prev11 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev11 = "";
}
if(fileExists($prev_foto)) {
$prev_foto = "<img src='" . $prev_foto . "' border=1 width=\"100\" height=\"80\" alt=''>";
}
else {
$prev_foto = "";
}


//start new
echo " <br>\n";
echo " <tr>\n";
echo " <td class=\"producttitle\" colspan=\"3\"><span class=\"featureYourPrice\">      " . $LNG['WARES_TYPES'][$id_type] . " /  <a href=index.php?lang=$lang&p=$p&id_type=$id_type&id_subtype=$id_subtype>" . $LNG['WARES_BACK'] . "</a></span><br /></td>\n";
echo " </tr>\n";
echo "<table cellspacing=\"0\" cellpadding=\"0\" width=\"760\" border=\"0\" align=center>\n";
echo " <tbody>\n";
echo "<p><br></p>\n";
echo " <div class=\"producttitle\" colspan=\"3\" align=center><span class=\"ch\">$title\n";
if($price > 0) {
echo "<div style=''>\n";
echo $LNG['WARES_PRICE'] . " : Ls " . sprintf("%0.2f", $price) . "</b>";
echo "</div>\n";
echo " </span></div>\n";
}
echo " <tr>\n";
echo " <td valign=\"center\" colspan=2 height=328 align=top><p align=\"center\"><span style=\"FONT-WEIGHT: 100\">\n";
echo " <img height=\"312\"\n";
echo " src=$spopup\n";
echo " width=\"450\" border=\"0\" /></a></span></p></td>\n";
echo " <td width=\"289\" height=\"454\" rowspan=\"2\" valign=\"top\"><table id=\"AutoNumber2\"\n";
echo " style=\"BORDER-COLLAPSE: collapse\"\n";
echo " bordercolor=\"#111111\" cellspacing=\"3\" cellpadding=\"5\"\n";
echo " width=\"100%\" border=\"0\">\n";
echo " <tbody>\n";
echo " <tr>\n";

//pic1
echo "<p><br></p>\n";
echo " <TD vAlign=top align=top>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev2) {
if(fileExists($popup2)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup2) . "','450','312','0');\">";
$prev2 = $sLink . $prev2 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev2) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev2;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//pic2
echo " <TD vAlign=top align=top>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev3) {
if(fileExists($popup3)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup3) . "','450','350','0');\">";
$prev3 = $sLink . $prev3 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev3) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev3;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
// end pic2
echo " </tr>\n";
echo " <tr>\n";
//pic3
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev4) {
if(fileExists($popup4)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup4) . "','450','350','0');\">";
$prev4 = $sLink . $prev4 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev4) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev4;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic3
//pic4
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev5) {
if(fileExists($popup5)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup5) . "','450','350','0');\">";
$prev5 = $sLink . $prev5 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev5) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev5;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic4
echo " </tr>\n";
echo " <tr>\n";
//pic5
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev6) {
if(fileExists($popup6)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup6) . "','450','350','0');\">";
$prev6 = $sLink . $prev6 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev6) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev6;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic5
//pic6
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev7) {
if(fileExists($popup7)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup7) . "','450','350','0');\">";
$prev7 = $sLink . $prev7 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev7) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev7;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic6
echo " </tr>\n";
echo " <tr>\n";
//pic7
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev8) {
if(fileExists($popup8)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup8) . "','450','350','0');\">";
$prev8 = $sLink . $prev8 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev8) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev8;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic7
//pic8
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev9) {
if(fileExists($popup9)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup9) . "','450','350','0');\">";
$prev9 = $sLink . $prev9 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev9) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev9;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic8
echo " </tr>\n";
echo " <tr>\n";
//pic9
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev10) {
if(fileExists($popup10)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup10) . "','450','350','0');\">";
$prev10 = $sLink . $prev10 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev10) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev10;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic9
//pic10
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev11) {
if(fileExists($popup11)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup11) . "','450','450','0');\">";
$prev11 = $sLink . $prev11 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if($prev11) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev11;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}

echo " </TBODY></TABLE></TD>\n";
//end pic10
//echo " border=\"0\" /></a></span></td>\n";
echo " </tr>\n";
echo " </tbody>\n";
echo " </table>\n";
//echo " <p> </p>\n";
//echo " <p> </p></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"25\" height=\"126\"><p align=\"center\"> </p>\n";
echo " <p align=\"center\"> </p></td>\n";
echo " <td width=\"446\" height=\"126\"><span\n";
echo " style=\"FONT-WEIGHT: 100\">$descr\n";
//echo " <p> </p>\n";
echo " <p align=\"left\">возможные цвета: клен\n";
echo " Страсбург</p>\n";
echo " <p align=\"left\"><span\n";
echo " style=\"FONT-WEIGHT: 700\">материалы: </span>фасады\n";
echo " МДФ, корпуса ламинированная\n";
echo " ДСП.</p>\n";
echo " </span></td>\n";
echo " </tr>\n";
echo " </tbody>\n";
echo "</table>";
//end new
echo "<br>\n";
echo " <p align=\"center\">" . $LNG['MM_ele'] . " <b>$title<b></p>\n";
//echo " <p align=\"left\"><span\n";



//start elements 2
echo "<table width=700 table border=0 cellpadding=1 cellspacing=1 align=center>\n";

// --- elements ---

$query = "SELECT wares2.id, wares2.id_foto, wares2.title, wares2.prev_foto, wares2.popup_foto, wares2.price2, wares2.made, wares2.size, subtypes.title " .
"FROM wares2, subtypes " .
"WHERE wares2.lang='$lang' && wares2.id='$id' && wares2.id_type='$id_type' && wares2.id_subtype='$id_subtype' && wares2.id_foto='$id_foto' && wares2.id_foto='$id' " .
"ORDER BY wares2.ord, wares2.date DESC";

if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
for($i = 0; $i < $iAff; $i++) {
list($id, $id_type, $id_subtype, $id_foto, $title, $prev_foto, $popup_foto, $price2, $made, $size, $stitle) = mysql_fetch_row($r);
$variables = array("title", "stitle");
magic_quotes_decode();
$stitle = splitTextIntoLang($stitle, "##", $lang);
//$sLink = "<a href=index.php?lang=$lang&p=$p&p2=read&id_type=$id_type&id_subtype=$id_subtype&id=$id>";

if($prev_foto) {
if(fileExists($popup_foto)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup_foto) . "','450','600','0');\">";
//$prev11 = $sLink . $prev11 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";

}
}
if(fileExists($prev_foto)) {
$prev_foto = "<img src='" . $prev_foto . "' border=1 width=" . $DEF['WARE_PREV_FOTO_W'] . " height=" . $DEF['WARE_PREV_FOTO_H'] . " alt=''>";

}
// else {
// $prev_foto = "";
// }
//
// if($i == 0) {
// title
// echo "<div style='margin: 20px 20px;'>\n";
//echo "<div style='margin: 1px; padding: 2px; background=#EEEEEE'>\n";
//echo "<div class=title>      " . $LNG['WARES_TYPES'][$id_type] . " / " . $stitle . "</div>";
//echo "<div class=title>" . $IMAGES['BTN'] . " <a href=index.php?lang=$lang&p=$p&id_type=$id_type>" . $LNG['WARES_TYPES'][$id_type] . "</a></div>";
//echo "<div class=subtitle>" . $size . "</div>";
// echo "</div>\n";


echo "<table width=100% border=0 cellspacing=10 cellpadding=10 align=center>\n";
// }


if($i % 4 == 0) echo "<tr>\n";
echo "<td width=250 bgcolor=#EEEDE0 align=center>\n";
if($prev_foto) {
$prev_foto = $sLink . $prev_foto . "</a>";
}
if($prev_foto) echo $prev_foto;
else echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=" . $DEF['WARE_PREV_FOTO_W'] . " height=" . $DEF['WARE_PREV_FOTO_H'] . " alt=''><br>";
echo "<div style=''align=\"center\">\n";
echo $sLink . "<b>" . $title . "</a></b><br>\n";
echo "<FONT color=gray>" .$LNG['MM_size']. "<br>\n";
echo $size . "</FONT><br>\n";
//echo "<FONT color=blue>" .$LNG['MM_price']. "<b>" . $price2 . "</b></FONT><br>\n";
//echo "<A href=\"#\"><IMG src=img/basket3.gif alt=Заказать width=75 height=17 border=0></A>\n";
echo "</div>\n";

if($price2 > 0) {
echo "<div style='margin: 5px 10px 5px;'align=\"center\">\n";
echo "<font color=\"red\"</>" .$LNG['WARES_PRICE'] . " : <b> Ls " . sprintf("%0.2f", $price2) . "</b><br>\n";
echo "<br>\n";
// echo "$sLink<b><u><font color=\"blue\">" .$LNG['MM_pod']. "</font></u></a>\n";
echo "<A href=\"#\"><IMG src=img/basket3.gif alt=Заказать width=75 height=17 border=0></A>\n";
echo "</div>\n";
}


}
echo "</table>\n";
echo "<br> \n";
}
echo " <br/>\n";
//end elemenets
echo "<table width=100% border=0 cellpadding=5 cellspacing=0>\n";
echo "<tr>\n";
echo "<td bgcolor=#EEEEEE valign=top style='border-right: 1px solid #CCCCCC'>\n";
$query = "SELECT id, id_subtype, id_foto, title FROM wares2 WHERE id_type='$id_type' ORDER BY ord";
if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
for($i = 0; $i < $iAff; $i++) {
list($id, $id_subtype, $id_foto, $title) = mysql_fetch_row($r);

$variables = array("title");
magic_quotes_decode();
$title = splitTextIntoLang($title, "##", $lang);
if(wares2.id == $id_foto ) {
echo "<li><b>" . $title . "</b>";
}
else {
echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id>" . $id . "</a>";
//echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id>" . $title . "</a>";
// echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id>" . $title . "</a>";
}

}
}
echo "</td>\n";
//start back

echo " <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo " <tr>\n";
//echo " <th width=\"41%\" scope=\"row\"><div align=\"right\"><img src=\"img/back.jpg\" width=\"16\" height=\"16\" /> </div></th>\n";
echo " <th width=\"100%\" valign=\"top\" scope=\"row\"><div align=\"center\" class=\"menu\"> <a href=\"javascript:history.back();\"><<<  " . $LNG['WARES_BACK'] . "</a> </div></th>\n";
echo " </tr>\n";
echo " </table>\n";
echo "<br>\n";
//echo " </div></td>\n";
echo " </tr>\n";
echo " </tbody>\n";
echo "</table>\n";

//echo "<br>\n";
}
?>
//----end

Мне кажется чтото с ID

Жду помощи - что то запарился - кончилось масло в мозгах :)



[Это сообщение - спам!]

Последние сообщения из форума

Уважаемые посетители форума MySQL.RU!
Убедительная просьба, прежде чем задавать свой вопрос в этом форуме, обратите внимание на разделы:
- ответы на наиболее часто задаваемые вопросы - FAQ
- раздел документация
- раздел поиск по сообщениям форума и документации
Также, старайтесь наиболее подробно указывать свою ситуацию (версию операционной системы, версию MySQL, версию программного обеспечения, по которому возникает вопрос, текст возникающих ошибок, и др.)
Помните, чем конкретнее Вы опишете ситуацию, тем больше шансов получить реальную помощь.
 Имя:
 E-mail:
 Тема:
 Текст:
Код подтверждения отправки: Code
31249



РЕКЛАМА НА САЙТЕ
  Создание сайтов | |