当前位置: 动力学知识库 > 问答 > 编程问答 >

mysql - Query give zero output

问题描述:

I am trying to filter results with a drop down and have it displayed in a table. In theory my query below should pick up all data that is requested,but I get zero results. Maybe I am looking at this for way too long. What am I doing wrong.

SELECT ac.route, ac.page_number, ac.link_number, ac.address, di.type,

pa.file_code, pb.member_id

FROM digital di, ips_trans ip, members pa,

files ac, publication pb

WHERE Date_Format(di.date,'%Y-%m-%d') = Date_Format(ip.roll_date,'%Y-%m-%d')

AND Date_Format(di.date,'%Y-%m-%d') = Date_Format(pa.date,'%Y-%m-%d')

AND di.payment = pa.paymentnow

AND ac.page_number = ip.code_number

AND ac.phone_number = pb.cell_number

分享给朋友:
您可能感兴趣的文章:
随机阅读: