<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1254">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-9">
<META http-equiv="content-language" content="TR">
<link href="./ana.css" type="text/css" rel="stylesheet" />
<TITLE>XXXXXXXXXXXXXX XXXXXXXXXXXXXX</TITLE>
</HEAD>
<BODY BGCOLOR="white" topmargin="0" leftmargin="0">
<div align="center">
<?php
include("sabit/logoanddrop.php");
?>
<table border="0" cellpadding="0" cellspacing="0" width="1000">
<tr>
<td width="1000" valign="TOP" bgcolor="#f2f2f2" colspan="4" height="13">
</td>
</tr>
<tr>
<p align="left">
<td width="150" valign="TOP" bgcolor="#f2f2f2">
<?php
$index=0;
if(isset($_GET['id'])){
$index=$_GET['id']-150;
}
include("admin/dataconn.php");
$result = mysql_query("SELECT * FROM urun_bilgi where urun_ID=$index");
$row = mysql_fetch_array($result);
$urun_adi=$row['urun_adi'];
if(isset($_GET['id'])){
include("sabit/urun_sol_menu.php");
}
else {
include("sabit/sol_menu.php");
}
echo"</td>
<td width='630' valign='TOP'>";
if($index>0){
echo"<div align='left'>
<table border='0' width='630' id='table8' cellspacing='0' cellpadding='0'>
<tr>
<td width='630' valign='top' align='left' height='10' class=sayfabaslik>
<img border='0' src='resim/navright_home.gif' width='18' height='10' align='left' hspace='0'>:: Ürünün Sıkça Sorulan Soruları</td>
</tr>
</table>
</div>
<p>";
include("sabit/urun_header.php");
echo"</p>
<center>
<table border='0' width='600' id='table5'>
<tr>
<td colspan='3' width='630'>";
echo"<font face='Verdana' style='font-size: 10pt' color='#003399'><b>Bu Ürünün Soruları:</b></font><br><br>";
$result2 = mysql_query("SELECT * FROM sorular where urun_adi='$urun_adi'");
$count=0;
while( $row2 = mysql_fetch_array($result2) ){
$soru= str_replace("xy_z","'",$row2['soru']);
echo "<tr><td><img border='0' src='resim/kvkutu6.gif'><a href='sss.php?id=$_GET[id]#$count' class=sss_sorular> $soru<p></td></tr>" ;
$count++;
}
echo"<font face='Verdana' style='font-size: 10pt' color='#003399'><b>Soru ve Cevaplar:</b></font></td>
</tr>
<font face='Verdana' style='font-size: 9pt'>";
$result2 = mysql_query("SELECT * FROM sorular where urun_adi='$urun_adi'");
$count=0;
while( $row2 = mysql_fetch_array($result2) ){
$soru= str_replace("xy_z","'",$row2['soru']);
$cevap= str_replace("xy_z","'",$row2['cevap']);
echo"</font><tr>
<td colspan='3' width='630'>
<font face='Verdana' style='font-size: 9pt'>
<b><font color='#008080'> </font>
<font color='#CC0000'><a id='$count' name='Soru'>Soru:</a></font></b>
</font>
<font face='Tahoma' style='font-size: 9pt'>
$soru</font><font face='Verdana' style='font-size: 9pt'>
</font>
</td>
</tr>
<tr>
<td colspan='3' width='630'>
<font face='Verdana' style='font-size: 9pt'>
<b><font color='#008080'> </font>
<font color='#CC0000'>Cevap:</font></b></font><font face='Tahoma' style='font-size: 9pt'>$cevap
</font>
</td>
</tr>
<tr>
<td colspan='3' height='20' width='630'>
</td>
</tr>
<font face='Verdana' style='font-size: 9pt'>";
$count++;
}
if($count==0){
echo"</font><tr>
<td colspan='3' width='630'>
<font face='Verdana' style='font-size: 9pt'>Bu ürünle ilgili Soru Girişi henüz yapılmadı.</font></td>
</tr>
<font face='Verdana' style='font-size: 9pt'>";
}
echo"</font><tr>
<td colspan='3' width='630'>
<p align='right'>
<font color='#CC0000' face='Verdana' style='font-size: 9pt; font-weight:700'>
<a href='#TOP' style='text-decoration: none'>
<font color='#008080'>Başa Dön</font></a></a><a href='#TOP' style='text-decoration: none'>
<img border='0' src='resim/arrow_up.gif' width='20' height='20'>
</a> </td>
</tr>
</table>";
echo"<center> <table border='0' width='600' id='table5'>
<tr>
<td colspan='3' bgcolor='#E7E1DC'>
<font color='#003399' face='Tahoma' size='2'><b>
:: Aynı Kategorideki Diğer Ürünler :</b></td>
</tr>
<tr><td colspan='3'>";
$result = mysql_query("SELECT urun_adi,urun_ID FROM urun_bilgi where kategori='$row[kategori]'");
echo"<center><table border='0' width='100%' id='table7' bgcolor='#F7F7F7'>";
while($row = mysql_fetch_array($result)) {
$index = 150+ $row['urun_ID'];
echo"
<tr>
<td width='100%'>
<img border='0' src='resim/kvkutu1.gif' width='9' height='9'>
<a href='urun_detay.php?id=$index' class=sss>".$row['urun_adi']."</a>
</td>
</tr>";
}
echo "</table></center>
</td></tr>
</table></center>";
echo"</td><td width='20' valign='TOP' align='center' background='resim/dotv.gif'> </td>
<td width='200' valign='TOP' align='center'>";
include("sabit/urun_sag_menu.php"); }
else{
echo"<table border='0' width='630' id='table8' cellspacing='0' cellpadding='0'>
<tr>
<td width='630' valign='top' align='left' height='10' class=sayfabaslik>
<img border='0' src='resim/navright_home.gif' width='18' height='10' align='left' hspace='0'>:: Sıkça Sorulan Sorular
</tr>
<tr>
<td width='650' class=girisyazilari><br>
<p >
Bu bölümde Ürünlerin sıkça sorulan
soruları bulunmaktadır.<b> Siz de <a href='iletisim.php'>
<font color='#000000'>İletişim</font></a></b>
bölümünden sorularınızı
iletebilirsiniz. </p>
<p >
Uygun görülmesi durumunda sitemizde
yayınlanacaktır. </p><br>
</tr>
</table>";
$result = mysql_query("SELECT distinct urun_adi FROM sorular ");
echo"<center>
<table border='0' width='600' id='table7'>";
while($row = mysql_fetch_array($result)) {
$result2 = mysql_query("SELECT urun_ID FROM urun_bilgi where urun_adi='$row[urun_adi]'");
$row2 = mysql_fetch_array($result2);
$index = 150+ $row2['urun_ID'];
echo" <tr>
<td width='650' bgcolor='#F7F7F7'>
<img border='0' src='resim/kvkutu6.gif' width='9' height='9'>
<a href='sss.php?id=$index' class=sss>".$row['urun_adi']."</a>
</td></tr>";
}
echo "</table></center> ";
echo"</td><td width='20' valign='TOP' align='center' background='resim/dotv.gif'> </td>
<td width='200' valign='TOP' align='center'>";
include("sabit/sag_menu.php");
}
?>
</tr>
<tr>
<td width="1000" valign="TOP" height="7" colspan="4">
<img border="0" src="resim/navbottom_home.gif" width="150" height="7"></td>
</tr>
<tr>
<td width="1000" valign="TOP" colspan="4">
</td>
</tr>
</table>
<?php
include("./sabit/altkisim.php");
?>
</div>
</BODY>
</HTML> php hata? mysql'e atıyor ama sayfada göstermior.
3
●404
- 23-01-2009, 09:34:51Merhaba arkadaşlar.Panelden sss ye bir soru cevap gönderiorum bunu mysql e ilgili tabloya atıyor fakat.sss.php de göstermior bu sorun neden olabilir kodlar aşagıda.
- 24-01-2009, 09:25:18
Üyeliği durdurulduverdiğiniz kodlarının neresinin ne yaptigi konusunda fikriniz var mı? - 24-01-2009, 11:31:54$result = mysql_query("SELECT * FROM urun_bilgi where urun_ID=$index");
burada ' işaeritin kullanmaışın ondan olabilir
$result = mysql_query("SELECT * FROM urun_bilgi where urun_ID='".$index."'");
