$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");?>
語法錯了,{體內(nèi)不能有雙引號}
回復@POSCMS負責人 :要怎么修改?試過很多方法都沒辦法調(diào)出來
回復@POSCMS負責人
<?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' }
回復@POSCMS負責人
<?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ù)
回復@POSCMS負責人 select * from @#1_ad where yxfaggmd like '%"品宣"%' order by rand() LIMIT 0,3 這是輸出的語句
回復@POSCMS負責人 select * from @#1_ad where yxfaggmd like '%品宣%' order by rand() LIMIT 0,3 依舊沒有數(shù)據(jù)
回復@POSCMS負責人
<?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");?>
賦值錯了吧