$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
{list action=sql sql='select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3' }
$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3");?>
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%\"品宣\"%' order by rand() LIMIT 0,3");?>
{list action=sql module=ad sql='$sql' }
{/list}
{$error} {$sql} 看這里輸出
$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3");?>
語(yǔ)法錯(cuò)了,{體內(nèi)不能有雙引號(hào)}
開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@POSCMS負(fù)責(zé)人 :要怎么修改?試過(guò)很多方法都沒(méi)辦法調(diào)出來(lái)
回復(fù)@POSCMS負(fù)責(zé)人
<?php
$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
{list action=sql sql='select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3' }
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%\"品宣\"%' order by rand() LIMIT 0,3");?> {list action=sql module=ad sql='$sql' }開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@POSCMS負(fù)責(zé)人
<?php
$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3");?>
{list action=sql module=ad sql='$sql' }
依舊調(diào)不出數(shù)據(jù)
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%\"品宣\"%' order by rand() LIMIT 0,3");?> {list action=sql module=ad sql='$sql' } {/list} {$error} {$sql} 看這里輸出開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@POSCMS負(fù)責(zé)人 select * from @#1_ad where yxfaggmd like '%"品宣"%' order by rand() LIMIT 0,3 這是輸出的語(yǔ)句
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%品宣%' order by rand() LIMIT 0,3");?>開源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@POSCMS負(fù)責(zé)人 select * from @#1_ad where yxfaggmd like '%品宣%' order by rand() LIMIT 0,3 依舊沒(méi)有數(shù)據(jù)
回復(fù)@POSCMS負(fù)責(zé)人
<?php
$da_arr = $ci->db->query("SELECT xingye,szcs,tgfs,guanggaomude FROM dr_1_form_znggtffaxt where uid=$member[uid] ORDER BY inputtime DESC LIMIT 0,1")->row_array();
$ggmd= $da_arr[guanggaomude];
?>
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%$ggmd%' order by rand() LIMIT 0,3");?>
{list action=sql module=ad sql='$sql' }
<tr>
<td style="width: 440px"><div class="mediapart">
<label class="fl"> <a href="{$t.url}" target="_blank"><img src="{dr_get_file($t[thumb])}" class="mtimg" alt="{$t.title}"></a> </label>
<div class="grp fl">
<div class="pb2"> <b class="account_name"> <a href="{$t.url}" target="_blank">{$t.title}</a> </b> </div>
<div class="desc">{$t.description}</div>
</div>
</div></td>
<td style="width: 101px" class="tdpadd"><span>{dr_cat_value('1-ad', $t.catid, 'name')}</span></td>
<td style="width: 101px" class="tdpadd"><span class="red now_money"> ¥ {$t.order_price} </span></td>
<td style="width: 100px; text-align:center;"><p><a href="{$t.url}" class="xsca" target="_blank">查看詳情</a></p></td>
</tr>
{/list}{$error} {$sql}
這是完整的代碼
<?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%".$ggmd."%' order by rand() LIMIT 0,3");?>
賦值錯(cuò)了吧