duanbogan5878 2015-01-15 06:39
浏览 240
已采纳

MySQL:获取重复查询字段的重复数据

I am new to mySQL and PHP, so bear with me.

How can I make it so that if my query has duplicate fields, the data retrieved would have repeated data for the repeated query fields.

An example would be like:

query for id = 34, 54, 21, 21, 50 (already in the order I want them to be in)

I want the database to return

user_icon for id = 34, user_icon for id = 54, user_icon for id = 21, user_icon for id = 21, and user_icon for id = 50.

And not just one data returned for the duplicate id 21.

Here is the code I am using at the moment:

 $thumb = "SELECT thumbnail from users WHERE id IN (".$idsearch.") ORDER BY FIELD(id , ".$idsearch.")";
   $search = $con->prepare($thumb);
   $search -> execute();

   $pics = $search->fetchAll();
   foreach($pics as $pic) {
     $thumbnail[] = $pic['thumbnail'];
  }

Thank you for the help!

  • 写回答

2条回答 默认 最新

  • dongsu3138 2015-01-15 07:04
    关注

    I am not able to think of a MYSQL query right now. But if perfomance is not of a concern, you can use some thing like

    $thumb = "SELECT thumbnail from users WHERE id = ?";
    $search = $con->prepare($thumb);
    
    foreach($idsearch as $id) {
       $search->execute(array($id));
       $pics = $search->fetch(PDO::FETCH_ASSOC);
       $search->closeCursor();
       $thumbnail[] = $pic['thumbnail'];
    }
    

    PDO will compile the SQL Query and the execution will be faster than a normal sql query.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥30 dbLinq最新版linq sqlite
  • ¥20 对D盘进行分盘之前没有将visual studio2022卸载掉,现在该如何下载回来
  • ¥15 完成虚拟机环境配置,还有安装kettle
  • ¥15 2024年全国大学生数据分析大赛A题:直播带货与电商产品的大数据分析 问题5. 请设计一份优惠券的投放策略,需要考虑优惠券的数量、优惠券的金额、投放时间段和投放商品种类等因素。求具体的python代码
  • ¥15 有人会搭建生鲜配送自营+平台的管理系统吗
  • ¥15 用matlab写代码
  • ¥30 motoradmin系统的多对多配置
  • ¥15 求组态王串口自定义通信配置方法或代码?
  • ¥15 实验 :UML2.0 结构建模
  • ¥20 用vivado写数字逻辑实验报告撰写,FPGA实验