Hi,

I can usualy test, try and correct but I haven't got a clue how to perform that query!

I have 2 date: $date1 and $date2 (y-m-d)
How do I send a query to MySQL to get all rows within those 2 dates?

Cut down of my current SQL Query:
$query = "SELECT * FROM Table_Article WHERE Article_ID LIKE '$Searchtitle'";

Which I'm assuming should look something like:
$query = "SELECT * FROM Table_Article WHERE Article_ID LIKE '$Searchtitle' FROM '$date1' to '$date2'";

but I guess its going to be harder than that.

Thanks.

SELECT * FROM Table_Article
WHERE Article_ID LIKE '$Searchtitle'
AND date_column_name BETWEEN '$date1' AND '$date2'

I'm not sure about the single quotes for a date.

Thanks - do you know if the BETWEEN is inclusive or exclusive ?

If it's not pulling back what you want try:

AND date_column_name >= $date1
AND date_column_name <= $date2

Thanks :)
Will check this one over the week-end :)

Works great - Thank you again!
The selection is inclusive which is fine by me.

up stu9820