doyz51819 2010-05-01 14:20
浏览 22
已采纳

从[php / Mysql]中选择多个表来获取内容

i want to get the latest threads/messages i made my code then i made function that calls the code to show last messages in specific board it works great now i want to get latest messages from 2 boards or more in the same function this is the part that chooses the board

     AND b.id_board = t.id_board' . (empty($vars) ? '' : '
     AND b.id_board = ' . $vars . ''). '

i tried to use functionname(1.2.3); but he says no board with id 1.2.3 i tried ("1,2,3") same i wish i made it clear for you i apreciate your help

  • 写回答

1条回答 默认 最新

  • dongyi9484 2010-05-01 17:18
    关注

    I think instead of b.id_board = ' . $vars . ' you need b.id_board in (' . $vars . '), then $var would be a comma separated list of ids as a string "1,2,3". (leaving all security issues aside :) )

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集