Multiple WHERE with dates ...

Discussion in 'PHP' started by pepe_lepew1962, Mar 6, 2011.

0
  1. #1
    Hello:

    I am trying to get my mysql query working and it says it is empty, which is impossible because I am picking information that I KNOW is in the table. What I am trying to do is to get 2 date variables from my form and to search my table within those dates. I do not know if it matters, but my table fields also have h:m:s while my date variables don't. I have tried many variances but continue to fail. Can anyone help me please.
    //
    //
    $frmQuery1101 = "SELECT tblTable1.fldField00, tblTable1.fldField19, tblTable1.fldField27, tblTable2.fldField00, tblTable2.fldField01, tblTable2.fldField02, tblTable2.fldField03, tblTable2.fldField04, tblTable2.fldField05 FROM tblTable1, tblTable2 WHERE (tblTable1.fldField00 = tblTable2.fldField00) AND WHERE tblTable2.fldField02 BETWEEN $frmDate01 AND $frmDate02 ORDER BY tblTable1.fldField19,tblTable1.fldField00";
     
    pepe_lepew1962, Mar 6, 2011 IP
  2. n3r0x

    n3r0x Well-Known Member

    Messages:
    257
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    120
    #2

    TRY
    
$frmQuery1101 = "SELECT tblTable1.fldField00, tblTable1.fldField19,  tblTable1.fldField27, tblTable2.fldField00, tblTable2.fldField01,  tblTable2.fldField02, tblTable2.fldField03, tblTable2.fldField04,  tblTable2.fldField05 
FROM tblTable1, tblTable2 
WHERE  (tblTable1.fldField00 = tblTable2.fldField00) AND (tblTable2.fldField02 BETWEEN $frmDate01 AND $frmDate02)
ORDER BY  tblTable1.fldField19,tblTable1.fldField00";
    PHP:

    you can only have one WHERE in SQL =) but you can still use AND or OR in the WHERE clause http://www.w3schools.com/sql/sql_and_or.asp
     
    n3r0x, Mar 6, 2011 IP