select date problem

[I-AM-OBODO]

Hi all.

In my code I use MySQL curdate() and now() to insert the current date and time in my db. and to get the date and time output I used a calender script I found on internet. the calendar inputs date in the format 12/10/2020 and MySQL date and time format is different (which I believe that's why my script isnt working)

I did a select * from table_name where user is boy and date  between $start and $end

 

but all I'm getting is blank page. I think I need to conver my form date to something MySQL will understand before I can get an output but I don't know how?

 

how can I achive a result

 

thanks

[Pikachu2000]

Without knowing anything about the calendar application, and seeing the code you're using, that question is impossible to answer.

[Barand]

Mysql uses yyyy-mm-dd format.

 

You need to convert your calendar dates to that for mat for comparisons

 

$ymd = date('Y-m-d', strtotime($calendardate));

[Barand]

PS

 

if your 12/10/2020 date is US mm/dd/yyyy then it should work. Unfortunately, PHP does not consider the European dd/mm/yyyy to be a valid date format, so if you're from my side of the pond it won't work so easily.

[I-AM-OBODO]

Mysql uses yyyy-mm-dd format.

 

You need to convert your calendar dates to that for mat for comparisons

 

$ymd = date('Y-m-d', strtotime($calendardate));

 

Thanks. It's working now

[I-AM-OBODO]

Thanks guys. It now working