douken7402 2015-06-24 11:56
浏览 16
已采纳

php mysql得到2个表值

Now I would like to query data to do the newest get code.

Now I have 2 table,

this is t1.

+--------------+--------------------------+----------------------+
|    id        |  name                    | description          |
+--------------+--------------------------+----------------------+
| 1            | GG                       | GG is good           |
| 2            | ABC DEFG                 | ABC DDDDD            |
| 3            | CCARD                    | Gooooo               |
+--------------+--------------------------+----------------------+

this is t2

+---------+------------+-------------------+------------------+
| id      | kaid       | code              | timestamp        |
+---------+------------+-------------------+------------------+
| 1       | 2          | ZZZZAAAAA         | 123456789        |
| 2       | 2          | AAAZZADWWW        | 123344444        |
| 3       | 1          | ASFASDFFFF        | 123333333        |
| 4       | 2          | HHHHHFDFG         | 123222222        |
| 5       | 1          | ASDASDADDDD       | 123111111        |
+---------+------------+-------------------+------------------+

I want the data show like this:

ORDER BY timestamp desc limit 5

+--------+------------+------------------+------------------
| id     | kaid       | name             | time             |
+--------+------------+------------------+------------------+
| 1      | 1          | GG               | 123111111        |
| 2      | 2          | ABC DEFG         | 123222222        |
| 3      | 1          | GG               | 123333333        |
| 4      | 2          | ABC DEFG         | 123344444        |
| 5      | 2          | ABC DEFG         | 123456789        |
+--------+------------+------------------+------------------+

now my code is:

$querylist = mysql_query("SELECT * FROM t1 ORDER BY time desc limit 5");
while($rowlist = mysql_fetch_row($querylist)) {
    $idlist[] = $rowlist['id'];
    $user_list_latest[] = $rowlist;
}

how do I select the t2.name when t1.id = t2.kaid?

thank you very much!

  • 写回答

4条回答 默认 最新

  • doulanyan6455 2015-06-24 12:03
    关注
    SELECT t1.*,t2.name FROM t1,t2 where t1.id = t2.kaid  ORDER BY t1.time desc limit 5
    

    you can use like this

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

报告相同问题?

悬赏问题

  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能