TheLord_d

function tr($x,$y,$noesc=0) { if ($noesc) $a = $y; else { $a = htmlspecialchars($y); $a = str_replace("\n", "<br />\n", $a); } print("<tr><td class=\"heading\" valign=\"top\" align=\"right\">$x</td><td valign=\"top\" align=left>$a</td></tr>\n"); } това е Пробах да го направя така : $tnxres = mysql_query("SELECT uid,username FROM thanks WHERE torid = $id"); while ($arr = mysql_fetch_assoc($tnxres)) $tnx = "<a href=userdetails.php?id=" . $arr["uid"] . "><b>" . $arr["username"] . "</b></a>"; echo("<td><form method=\"post\" action=\"takethankyou.php?id=$id\"><input type=\"submit\" class=btn value=\"Thanks\" /></form></td><td>$tnx</td>"); но нз защо вади само последният запис

Здрвейте.Проблемът е следният: $tnxres = mysql_query("SELECT uid,username FROM thanks WHERE torid = $id"); while ($arr = mysql_fetch_assoc($tnxres)) tr("<form method=\"post\" action=\"takethankyou.php?id=$id\"><input type=\"submit\" class=btn value=\"Благодаря\" /></form>" ,"<a href=userdetails.php?id=" . $arr["uid"] . "><b>" . $arr["username"] . "</b></a>",1); Резултатите,които се извеждат са ред под ред,а аз искам да са един до друг.Моля помогнете.Благодаря предварително.

Мерси много точно това ми трябва и проработи

Това е структурата на таблица 'products' А това е на 'products_to_categories'

Мне..неработи.Резултатът е същият както преди...Вади си ми всички продукти , нищо че съм му казал да са само от категория = 8 примерно

Здравейте Имам следният проблем.Значи имам 2 таблици в базата данни - `products` и 'products_to_categories' .Искам да селектирам 2-те таблици ,но амо по ID на категорията ,към която спада продукта. function genrelist() { $ret = array(); $res = mysql_query("SELECT products_model,products_price FROM products,products_to_categories WHERE products_to_categories.categories_id = 9"); while ($row = mysql_fetch_array($res)) $ret[] = $row; return $ret; } Следва визуализацията : <select name="type" style="HEIGHT: 22px; WIDTH: 240px" onchange="ChangeSelection(this.form, 0)"> <option value=0>*****************************</option> <? $cats = genrelist(); $catdropdown = ""; foreach ($cats as $cat) { $catdropdown .= "<option value=\"" . $cat["products_price"] . "\""; if ($cat["products_price"] == $_GET["cat"]) $catdropdown .= " selected=\"selected\""; $catdropdown .= ">" . htmlspecialchars($cat["products_model"]) . "</option>\n"; } ?> <?= $catdropdown ?> </select> Проблемът е ,че ми показва всички продукти а не само от категория ID = 9 . В таблица 'products' имам следните полета : products_id , products_quantity , products_model , products_image , products_price products_date_added , products_last_modified , products_date_available , products_weight products_status , products_tax_class_id , manufacturers_id , products_ordered в 'products_to_categories' са : products_id и categories_id Значи идеята ми е такава.Имам таблица с 3 колони.Искам за всяка категория да отговаря продукт и след избирането на продукта в 3-тата колона да се визуализира стойността му. Ако някой има решение на въпроса,моля да пише.Благодаря предварително.

Това е кода за SnowSilver.css /* General page style. The scroll bar colours only visible in IE5.5+ */ body { background-image: url(images/snowflakes.gif); border: none; scrollbar-3dlight-color: #D1D7DC; scrollbar-arrow-color: #006699; scrollbar-darkshadow-color: #98AAB1; scrollbar-face-color: #DEE3E7; scrollbar-highlight-color: #FFFFFF; scrollbar-shadow-color: #DEE3E7; scrollbar-track-color: #EFEFEF } /* General font families for common tags */ font,th,td,p { font-family: Verdana, Arial, Helvetica, sans-serif } a:link,a:active,a:visited { color : #006699; } a:hover { text-decoration: underline; color : #DD6900; } hr { height: 0px; border: solid #D1D7DC 0px; border-top-width: 1px;} /* This is the border line & background colour round the entire page */ .bodyline { background-color: #FFFFFF; border: 1px #98AAB1 solid; } /* This is the outline round the main forum tables */ .forumline { background-color: #FFFFFF; border: 2px #006699 solid; } /* Main table cell colours and backgrounds */ td.row1 { background-color: #EFEFEF; } td.row2 { background-color: #DEE3E7; } td.row3 { background-color: #D1D7DC; } /* This is for the table cell above the Topics, Post & Last posts on the index.php page By default this is the fading out gradiated silver background. However, you could replace this with a bitmap specific for each forum */ td.rowpic { background-color: #FFFFFF; background-image: url(images/cellpic2.jpg); background-repeat: repeat-y; } /* Header cells - the blue and silver gradient backgrounds */ th { color: #FFA34F; font-size: 11px; font-weight : bold; background-color: #006699; height: 25px; background-image: url(images/cellpic3.gif); } td.cat,td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url(images/cellpic1.gif); background-color:#D1D7DC; border: #FFFFFF; border-style: solid; height: 28px; } /* Setting additional nice inner borders for the main table cells. The names indicate which sides the border will be on. Don't worry if you don't understand this, just ignore it :-) */ td.cat,td.catHead,td.catBottom { height: 29px; border-width: 0px 0px 0px 0px; } th.thHead,th.thSides,th.thTop,th.thLeft,th.thRight,th.thBottom,th.thCornerL,th.t CornerR { font-weight: bold; border: #FFFFFF; border-style: solid; height: 28px; } td.row3Right,td.spaceRow { background-color: #D1D7DC; border: #FFFFFF; border-style: solid; } th.thHead,td.catHead { font-size: 12px; border-width: 1px 1px 0px 1px; } th.thSides,td.catSides,td.spaceRow { border-width: 0px 1px 0px 1px; } th.thRight,td.catRight,td.row3Right { border-width: 0px 1px 0px 0px; } th.thLeft,td.catLeft { border-width: 0px 0px 0px 1px; } th.thBottom,td.catBottom { border-width: 0px 1px 1px 1px; } th.thTop { border-width: 1px 0px 0px 0px; } th.thCornerL { border-width: 1px 0px 0px 1px; } th.thCornerR { border-width: 1px 1px 0px 0px; } /* The largest text used in the index page title and toptic title etc. */ .maintitle,h1,h2 { font-weight: bold; font-size: 22px; font-family: "Trebuchet MS",Verdana, Arial, Helvetica, sans-serif; text-decoration: none; line-height : 120%; color : #000000; } /* General text */ .gen { font-size : 12px; } .genmed { font-size : 11px; } .gensmall { font-size : 10px; } .gen,.genmed,.gensmall { color : #000000; } a.gen,a.genmed,a.gensmall { color: #006699; text-decoration: none; } a.gen:hover,a.genmed:hover,a.gensmall:hover { color: #DD6900; text-decoration: underline; } /* The register, login, search etc links at the top of the page */ .mainmenu { font-size : 11px; color : #000000 } a.mainmenu { text-decoration: none; color : #006699; } a.mainmenu:hover{ text-decoration: underline; color : #DD6900; } /* Forum category titles */ .cattitle { font-weight: bold; font-size: 12px ; letter-spacing: 1px; color : #006699} a.cattitle { text-decoration: none; color : #006699; } a.cattitle:hover{ text-decoration: underline; } /* Forum title: Text and link to the forums used in: index.php */ .forumlink { font-weight: bold; font-size: 12px; color : #006699; } a.forumlink { text-decoration: none; color : #006699; } a.forumlink:hover{ text-decoration: underline; color : #DD6900; } /* Used for the navigation text, (Page 1,2,3 etc) and the navigation bar when in a forum */ .nav { font-weight: bold; font-size: 11px; color : #000000;} a.nav { text-decoration: none; color : #006699; } a.nav:hover { text-decoration: underline; } /* titles for the topics: could specify viewed link colour too */ .topictitle { font-weight: bold; font-size: 11px; color : #000000; } a.topictitle:link { text-decoration: none; color : #006699; } a.topictitle:visited { text-decoration: none; color : #5493B4; } a.topictitle:hover { text-decoration: underline; color : #DD6900; } /* Name of poster in viewmsg.php and viewtopic.php and other places */ .name { font-size : 11px; color : #000000;} /* Location, number of posts, post date etc */ .postdetails { font-size : 10px; color : #000000; } /* The content of the posts (body of text) */ .postbody { font-size : 12px;} a.postlink:link { text-decoration: none; color : #006699 } a.postlink:visited { text-decoration: none; color : #5493B4; } a.postlink:hover { text-decoration: underline; color : #DD6900} /* Quote & Code blocks */ .code { font-family: Courier, 'Courier New', sans-serif; font-size: 11px; color: #006600; background-color: #FAFAFA; border: #D1D7DC; border-style: solid; border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px } .quote { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #444444; line-height: 125%; background-color: #FAFAFA; border: #D1D7DC; border-style: solid; border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px } /* Copyright and bottom info */ .copyright { font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #444444; letter-spacing: -1px;} a.copyright { color: #444444; text-decoration: none;} a.copyright:hover { color: #000000; text-decoration: underline;} /* Form elements */ input,textarea, select { color : #000000; font: normal 11px Verdana, Arial, Helvetica, sans-serif; border-color : #000000; } /* The text input fields background colour */ input.post, textarea.post, select { background-color : #FFFFFF; } input { text-indent : 2px; } /* The buttons used for bbCode styling in message post */ input.button { background-color : #EFEFEF; color : #000000; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; } /* The main submit button option */ input.mainoption { background-color : #FAFAFA; font-weight : bold; } /* None-bold submit button */ input.liteoption { background-color : #FAFAFA; font-weight : normal; } /* This is the line in the posting page which shows the rollover help line. This is actually a text box, but if set to be the same colour as the background no one will know */ .helpline { background-color: #DEE3E7; border-style: none; }

Този код при мене работи ........ print("<link rel=\"stylesheet\" href=\"../snowSilver.css\" type=\"text/css\"> <script> // Set the number of snowflakes (more than 30 - 40 not recommended) var snowmax=35 // Set the colors for the snow. Add as many colors as you like var snowcolor=new Array(\"#aaaacc\",\"#ddddFF\",\"#ccccDD\") // Set the fonts, that create the snowflakes. Add as many fonts as you like var snowtype=new Array(\"Arial Black\",\"Arial Narrow\",\"Times\",\"Comic Sans MS\") // Set the letter that creates your snowflake (recommended:*) var snowletter=\"*\" // Set the speed of sinking (recommended values range from 0.3 to 2) var sinkspeed=2 // Set the maximal-size of your snowflaxes var snowmaxsize=30 // Set the minimal-size of your snowflaxes var snowminsize=10 // Set the snowing-zone // Set 1 for all-over-snowing, set 2 for left-side-snowing // Set 3 for center-snowing, set 4 for right-side-snowing var snowingzone=1 /////////////////////////////////////////////////////////////////////////// // CONFIGURATION ENDS HERE /////////////////////////////////////////////////////////////////////////// // Do not edit below this line var snow=new Array() var marginbottom var marginright var timer var i_snow=0 var x_mv=new Array(); var crds=new Array(); var lftrght=new Array(); var browserinfos=navigator.userAgent var ie5=document.all&&document.getElementById&&!browserinfos.match(/Opera/) var ns6=document.getElementById&&!document.all var opera=browserinfos.match(/Opera/) var browserok=ie5||ns6||opera function randommaker(range) { rand=Math.floor(range*Math.random()) return rand } function initsnow() { if (ie5 || opera) { marginbottom = document.body.clientHeight marginright = document.body.clientWidth } else if (ns6) { marginbottom = window.innerHeight marginright = window.innerWidth } var snowsizerange=snowmaxsize-snowminsize for (i=0;i<=snowmax;i++) { crds = 0; lftrght = Math.random()*15; x_mv = 0.03 + Math.random()/10; snow=document.getElementById(\"s\"+i) snow.style.fontFamily=snowtype[randommaker(snowtype.length)] snow.size=randommaker(snowsizerange)+snowminsize snow.style.fontSize=snow.size snow.style.color=snowcolor[randommaker(snowcolor.length)] snow.sink=sinkspeed*snow.size/5 if (snowingzone==1) {snow.posx=randommaker(marginright-snow.size)} if (snowingzone==2) {snow.posx=randommaker(marginright/2-snow.size)} if (snowingzone==3) {snow.posx=randommaker(marginright/2-snow.size)+marginright/4} if (snowingzone==4) {snow.posx=randommaker(marginright/2-snow.size)+marginright/2} snow.posy=randommaker(2*marginbottom-marginbottom-2*snow.size) snow.style.left=snow.posx snow.style.top=snow.posy } movesnow() } function movesnow() { for (i=0;i<=snowmax;i++) { crds += x_mv; snow.posy+=snow.sink snow.style.left=snow.posx+lftrght*Math.sin(crds); snow.style.top=snow.posy if (snow.posy>=marginbottom-2*snow.size || parseInt(snow.style.left)>(marginright-3*lftrght)){ if (snowingzone==1) {snow.posx=randommaker(marginright-snow.size)} if (snowingzone==2) {snow.posx=randommaker(marginright/2-snow.size)} if (snowingzone==3) {snow.posx=randommaker(marginright/2-snow.size)+marginright/4} if (snowingzone==4) {snow.posx=randommaker(marginright/2-snow.size)+marginright/2} snow.posy=0 } } var timer=setTimeout(\"movesnow()\",50) } for (i=0;i<=snowmax;i++) { document.write(\"<span id='s\"+i+\"' style='position:absolute;top:-\"+snowmaxsize+\"'>\"+snowletter+\"</span>\") } if (browserok) { window.onload=initsnow } </script>");