duanlidi1051 2016-07-17 02:19
浏览 21

MySQL,如何使用不同的ID从两个表中获取一次又一次?

I have two tables and post.

Tables are paper, subject, some post content saved and opened in subject page.

Here issue is paper ID is Common but Subject ID changes for multiple posts.

$stmt = mysql_query("SELECT *  FROM tut_blog_posts WHERE paper_name='".$results_paper["id"]."' AND subject_name='".$results_subject["id"]."' ORDER BY postID DESC");

Sometime data works and other times the same paper ID and Subject ID don't work.

How to fix this?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)