Search Problem

[whitebread]

Hi,

I have an input page that uses a hard coded date, as below.

$sql_query = "insert into accounts (General_Date, First_Name, Last_Name, Account_Number, Total, Account_Status, Account_Type, Forwarded, Date_Sent, Notes) Values ('" . date("m/d/Y") . "', '{$_POST['First_Name']}', '{$_POST['Last_Name']}', '{$_POST['Account_Number']}', '{$_POST['Total']}', '{$_POST['Account_Status']}', '{$_POST['Account_Type']}', '{$_POST['Forwarded']}', '{$_POST['Date_Sent']}', '{$_POST['notes']}')";

As you can see from the code the '" . date("m/d/Y") is inserted into the General_Date field of the MySQL database in the format MM/DD/YYYY. I however have no idea how to create a PHP query to search for certain Months, Days or date ranges (i.e. 01/01/2000 to 01/07/2000). I know I need some sort of array but I'm unsure on how to code it.

Thanks in advance........

[LordShryku]

That obviously isn't a date type field, so what type of field is it? I'll take a guess at varchar, and my first reaction would be to change it to a date type field. That would make your life a lot easier in this situation since then you could do all of those conditionals in the SQL.

Sometimes you can't do that though, so you would have to pull every record and split it using [man]explode[/man]. You could maybe get away with a string type comparison or regex in the SQL query, but it would be painful.