ppypp伦理天堂,91手机在线视频,免费在线观看黄色毛片,夜夜穞天天穞狠狠穞AV美女按摩

聯系官方銷售客服

1835022288

028-61286886

投訴 解決中 / 官方已回 語句查詢不出數據;數據庫字段的值是品宣注冊漲粉招商門店推廣 11 0

{list action=sql module=ad sql='select * from @#1_ad where yxfaggmd like '%\"品宣\"%' order by rand() LIMIT 0,3' }語句查詢不出數據;

數據庫字段yxfaggmd的值是["品宣","注冊","漲粉","招商","門店推廣"]

解決方案
  • 語法錯了,{體內不能有雙引號}

  • 回復@POSCMS負責人 :要怎么修改?試過很多方法都沒辦法調出來

  • 回復@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' }

  • <?php $sql=urlencode("select * from @#1_ad where yxfaggmd like '%\"品宣\"%' order by rand() LIMIT 0,3");?>
    {list action=sql module=ad sql='$sql' }
  • 回復@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' }

    依舊調不出數據

  • <?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} 看這里輸出
  • 回復@POSCMS負責人 select * from @#1_ad where yxfaggmd like '%"品宣"%' order by rand() LIMIT 0,3 這是輸出的語句

  • <?php $sql=urlencode("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 依舊沒有數據

  • 回復@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");?>

    賦值錯了吧