problem with php mysql query

Posted on 16th Feb 2014 07:03 pm by admin

Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab record using BETWEEN startdate and enddate since existing record are stored using this format datetime(dd/mm/yyyy hh:mm:ss) but my supplied $startdate and my $enddate are in this format date(dd/mm/yyyy) only....hope someone will shed me some light on this...is it possible to grab those record...??

Code: //example of my query..

$sqlquery = "SELECT * FROM sometable WHERE OFFENCE_NOTICE_STATUS = 'A' AND CREATED_DATE BETWEEN ".$start_date." AND ".$end_date;

//can't run this query because of the stored record in database are in different format datetime(dd/mm/yyyy hh:mm:ss)

//my supplied variable in date(dd/mm/yyyy) format...


Any help are appreciated TQ..

Your Answer:

Login to answer

Other forums

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

Strange php code found on my website
I got hacked and the following code was placed within my files:

Code: [Select]<?
/*

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

how to configure ADS in ABAP instance
Hi All,

I am working on r/3 4.7 ABAP system.Can we configure ADS(adobe document services)

Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha