A php- mysql problem- date formats problem

[Aji]

Hi all,

I have a simple problem, I tried it but getting error, still trying to solve but thought will get the help from some experts too.

Database(mysql) date format :yyyy-mm-dd 00:00:00
client site query date is : dd/mm/yyyy

I have seprated the client side date into different portions like (dd) and (mm) and (yyyy). I can get them

My problems
------------------
(1) I want to query between two dates say 21/04/2004 to 23/04/2004 , how to do that ??
(2) I want yyyy-mm-dd 00:00:00 , to seprate month , date , year , time from this format using php, how can I do that, I know its easy but I am not an expert on php and mysql.

I am using the following query, but the problem is with the date format ,
$sql1="select * from TblUsers1,TblUserInfo1 where TblUserInfo1.FldUserID=TblUsers1.FldUserID and (TblUsers1.FldDateSubscribed BETWEEN '$StartDate' AND '$EndDate')";


HELP HELP HELP

Thank you
Aji

[Andy]

Hi Aji,

It seems like your main problem is how to translate from dd/mm/yyyy to yyyy-mm-dd 00:00:00

Since you already seperated out the dd mm yyy bits, it should be easy.

What I suspect you should study is the sprintf function which is copied from the C programming language. The other one is printf (for printing to a printer). These functions let you insert data into a string very easily.

<url>http://www.php.net/manual/en/function.sprintf.php</url>

[lostingermany]

Hi Aji

It sounds like the structure of your table column is wrong. If you use date instead of datetime() for your column type all you will have is the date and not the linux time stamp.
Then the next thing to do is to put the date string together from the input. You can do that like this:

If you use post:

$startdate = $_POST['startyear']."-".$_POST['startmonth']."-".$_POST['startday'];
$enddate = $_POST['endyear']."-".$_POST['endmonth']."-".$_POST['endday'];

If you use get:
$startdate = $_GET['startyear']."-".$_GET['startmonth']."-".$_GET['startday'];
$enddate = $_GET['endyear']."-".$_GET['endmonth']."-".$_GET['endday'];

Now you can use these variables in your SQL query.

$sql1="select * from TblUsers1,TblUserInfo1 where TblUserInfo1.FldUserID=TblUsers1.FldUserID and (TblUsers1.FldDateSubscribed BETWEEN '$startdate' AND '$enddate')";

Have fun with it

lostingermany