MySQL select query

Question

I have a simple MySQL query that selects all columns from the table based off two requirements.

`$dbSearchRecords = mysql_query("SELECT * FROM booking WHERE BookingID = '$JobNo_search' AND Date BETWEEN '$DateFrom_search' AND '$DateTo_search'" )`

I am trying to get the query to search either one or both of the requirements. WHERE BookingID = '$JobNo_search' AND Date BETWEEN '$DateFrom_search' AND '$DateTo_search'

At the moment all parameters need to be present to get a result and I need to be able to search just the BookinID or just the date range as well.

Cheers guys.

willdanceforfun · Accepted Answer · 2010-12-03 00:37:19Z

1

What about...

$dbSearchRecords = mysql_query(

  "SELECT * FROM booking 
   WHERE BookingID = '$JobNo_search' 
   OR ( Date BETWEEN '$DateFrom_search' AND '$DateTo_search' ) 
   OR itemid = $itemID
   OR job_no = $job_no
   OR rego = $rego
  "

)

The OR works as AND/OR.

edited Dec 3, 2010 at 0:37

answered Dec 3, 2010 at 0:30

willdanceforfun

11.3k31 gold badges87 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL select query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related