PHP Gurus please help...

[rusbel]

---

I found hard to distinguish what is the problem with this query:

$today = gmdate('2007-06-27 01:42:28'); //this is hardcoded based from the result $expire = gmdate('Y-m-d H:i:s'); echo $today;
$expire = gmdate('2007-06-27 23:59:59'); //this is hardcoded based from the result $expire = gmdate('Y-m-d 23:59:59'); echo $expire; 

$sql = "SELECT avatar_name FROM $table where avatar_group = 'Avatrian Central' AND dt_detection > '$today' AND dt_detection < '$expire' group by avatar_name";
$result1 = mysql_query($sql);
$numofrows1 = mysql_num_rows($result1);

it returns a correct ouput but when I changed something like this:

$today = gmdate('Y-m-d H:i:s');
$expire = gmdate('Y-m-d 23:59:59');

$sql = "SELECT avatar_name FROM $table where avatar_group = 'Avatrian Central' AND dt_detection > '$today' AND dt_detection < '$expire' group by avatar_name";
$result1 = mysql_query($sql);
$numofrows1 = mysql_num_rows($result1);

NOTE: The only difference is there gmdate parameters. Others are the same.

Can you explain to me...

[chronnus]

what was the error or the incorrect output?

[rusbel]

Well, the second one, output 0 always, while the first one output the correct answer. But in this case, this should be the same, because I am just hardcoded the result of gmdate('Y-m-d H:i:s') to the first one. Is it a bug with PHP and MySQL?. Please advised.

[silent-kill]

- what is the situation?
- what are you trying to do?.
- what is the problem?.


http://www.php.net/manual/en/function.gmdate.php

[morphian]

Well, the second one, output 0 always, while the first one output the correct answer. But in this case, this should be the same, because I am just hardcoded the result of gmdate('Y-m-d H:i:s') to the first one. Is it a bug with PHP and MySQL?. Please advised.

have tried to "echo" your query?

do this first and see if your "$today" is in a format acceptable to MySQL.

$today = gmdate('Y-m-d H:i:s');
$expire = gmdate('Y-m-d 23:59:59');

$sql = "SELECT avatar_name FROM $table where avatar_group = 'Avatrian Central' AND dt_detection > '$today' AND dt_detection < '$expire' group by avatar_name";

echo $sql . "<br/>";

//$result1 = mysql_query($sql);
//$numofrows1 = mysql_num_rows($result1);

[chronnus]

^^ Yeah, it would be helpful if you echoed both queries to see the difference. Post the echoed q's here.

[radj]

please tell us what is the datatype of dt_detection.