hatasını alıyorum kodlarım ;
<?php
include('db.php');
?>
<?php
if($_POST)
{
$q=$_POST['search'];
$sql = mysql_query('select * from kullanicilar');
$veri = mysql_fetch_assoc($sql);
$p_k=$veri["p_k"];
$sql_res=mysql_query("select id,f_unvan,y_p_k from m_kayit where y_p_k='$p_k' f_unvan like '%$q%' or y_p_k like '%$q%' order by f_unvan LIMIT 5");
while($row=mysql_fetch_array($sql_res))
{
$id=$row['id'];
$username=$row['f_unvan'];
$y_p_k=$row['y_p_k'];
$b_username='<strong>'.$q.'</strong>';
$b_bakiye='<strong>'.$q.'</strong>';
$final_username = str_ireplace($q, $b_username, $username);
$final_bakiye = str_ireplace($q, $b_bakiye, $y_p_k);
?>
<div class="show" align="left">
<span class="name"><?php echo $final_username; ?></span> <br/>Y.P.K : <?php echo $final_bakiye; ?>
</div>
<?php
}
}
?>nasıl düzentebilirim.
CEVAP : $result=mysql_query("select id,f_unvan,y_p_k from `m_kayit` where y_p_k='".$p_k."' and f_unvan like '%$q%' or y_p_k like '%$q%' order by y_p_k DESC LIMIT 5")or die(mysql_error());if (!$result) die("1. sorgu başarısız oldu");
