Bekmurod, Bunda faqat boshida turgan so'zni oladimi barchasini olishni iloji yo'qmi?

DjHuSo, Barchasini oladi!

DjHuSo, Misol
$qidirsoz = 'test';
mysql_query("SELECT * FROM `news` WHERE `nomi` LIKE '%".$qidirsoz."%'");
Endi natichani siklda (while) chiqarasiz.
.
Shunda news ustunidagi nomi ustunini tanladik undan like yordamida news nomida test sözi bor barcha newslar chiqadi.

ATOYAT, Tushundim buni chiqdi faqat boshida salom bor so'slarni topyapti

#1064 faqat o'zidagi yangilik chiqyapti!

DjHuSo, # DjHuSo (12.04.2018 / 22:44)
#1064 faqat o'zidagi yangilik chiqyapti!$qidirsoz ni filtirlab html teglarni qirib sinab ko'ring. Lekin menimcha LIKE so'zma so'z qidiradi.

Bekmurod, Unchalik tushunmadim!

Bekmurod, qilsam barcelona qatnashgan newslarni topyapti
qilsam faqat o'z yangiligini topyapti!

DjHuSo, qilib ko'ring.

Bekmurod, Barbir bo'ldi!

Bekmurod, Nima qilsa bo'ladi!

Help me!

DjHuSo, avalambor siz bazangizni o`zini qidiruvga moslab indesklashingiz kerak bo`ladi!
Buning uchun bazaga

yuborasiz!
Chiqarish:

Download da papka dagi fayllarni 5tasini file.php ga chiqarish kodi bo'lsa berilar. Iltimos

Ajalbek, File php ga chiqarib nima qilasz ?

Users balansini qanday qoshiladi bazaga '.$user[balans].' bunday qilsam chiqmayabdi

Bahh, ' .$user['balans']. '

Bahh, bazaga yuboring

Akalar ukalar shuni tugirlab beringlar eng pasida ung tomonida 123...7>> bulib chiqsin
Limitga 15 ta mp3 chiqishi kerak

<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"> <center><b> Yangi Mp3lar</b></center></div>';
echo '<div class="fobar"><table cellspacing="0" cellpadding="0" border="0" width="100%"><tr><td><a href="/download/dir_31.html"><div style="font-size:15px;">Uzbek</div></a></td><td><a href="/download/dir_33.html"><div style="font-size:15px;">Yosh Ijodkorlar</div></a></td><td><a href="/download/dir_32.html"><div style="font-size:15px;">Zarubej</div></a></td></tr></table></div>';
$cat ='2';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){
$cat_inf = mysql_fetch_assoc($cat_inf);
}else{
$cat_inf = array('way' => '');
}
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT 15");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="menu">' : '<div class="menu">';
$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0);
echo "<img src='/images/mp3.png' width='16' height='16' align='middle'/> <a href='/download/" . str_replace(' ', '_', $ok['name']) . "_".$ok['id'].".html'>".$ok['name']."</a>";
if($new > 0){
echo '<span class="red"><img src="/new.gif"></span>';
}else{
echo '';
}

if($ok['count'] > 50){
echo '<img src="xit.gif">';
}else{
echo '';
}

echo "</div>";
}

if ($total > $kmess){
echo '<p>' . functions::display_pagination('?', $start, $total, $kmess) . '</p>';
}
echo '<div class="menu"><img src="/images/davomi.png"><a href="/download/dir_2.html"> <font color="FA0000">Barchasini Kurish »» </font></a></div>';
?>

Saytim tez-tez shunday bo'lib qolyapti.
FLOOD: exceeded limit of allowed requests