comparison condition in php + mysql

[hazahafiz]

how can we count the total of row between two value that include both fields of value ($input1<=startDate>=$input2 not $input1<startDate>$input2!!)

here is my code,is that true?

$query = "SELECT * FROM excomplaint WHERE startDate BETWEEN '$input1' AND '$input2'";

[ronverdonk]

That query should give the correct results.

Ronald :cool:

[hazahafiz]

so,how to differentiate between both query..is that true if both condition using the same query?

[ronverdonk]

I am not quite sure what you asking for. Hope this is it: the select for the second condition

$query = "SELECT * FROM excomplaint 
   WHERE startDate > '$input1' 
     AND startDate < '$input2'";

Ronald :cool:

[hazahafiz]

I am not quite sure what you asking for. Hope this is it: the select for the second condition

$query = "SELECT * FROM excomplaint 
   WHERE startDate > '$input1' 
     AND startDate < '$input2'";

Ronald :cool:

i get the true output..thanks..
but,can or not php support when i have declare for startDate datatype is varchar because it include '/'?

[ronverdonk]

A MySQL date field with data type DATE always has format 'YYYY-MM-DD'. When you are using another format you will most likely run into problems when trying to perform MySQL date calculations.

So when you are using a MySQL date field of which the stored value must be e.g. 'DD/MM/YYYY' you cannot store that into a MySQL DATE type field, but e.g. in a MySQL char type field. Then you cannot perform date calculations.

I would suggest that you always store a date in MySQL in the standard DATE format (YYYY-MM-DD) and convert any external fields into that format when storing and reformat back to your own format after retrieving and displaying.

Ronald :cool:

[hazahafiz]

A MySQL date field with data type DATE always has format 'YYYY-MM-DD'. When you are using another format you will most likely run into problems when trying to perform MySQL date calculations.

So when you are using a MySQL date field of which the stored value must be e.g. 'DD/MM/YYYY' you cannot store that into a MySQL DATE type field, but e.g. in a MySQL char type field. Then you cannot perform date calculations.

I would suggest that you always store a date in MySQL in the standard DATE format (YYYY-MM-DD) and convert any external fields into that format when storing and reformat back to your own format after retrieving and displaying.

Ronald :cool:

But i want the output of startDate is '1/2/2007'..if i use DATE datatype, the output is '2007/2/1'.so how can i solve this problem?

[gauravgmbhr]

But i want the output of startDate is '1/2/2007'..if i use DATE datatype, the output is '2007/2/1'.so how can i solve this problem?

I am not sure bout what u r asking

i think when u r passing two inputs to the query and having a between clause in ur querythen ur query will get the job done

if u wanna count the rows try mysql_num_rows($result_handle);

[ronverdonk]

I am not sure bout what u r asking
i think when u r passing two inputs to the query and having a between clause in ur query
then ur query will get the job done
if u wanna count the rows try mysql_num_rows($result_handle);

gauravgmbhr: why don't you read the entire thread before replying? This is not what was asked, doesn't come close.

Ronald :cool: