Query Advice

[rcoursey]

I have the query below. I created one record which fits within the range I want to query on.

The below variables are defined as follows:
$currentdt=date();
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));

This is the actual select statement in the query:

SELECT * , UNIX_TIMESTAMP( stopdate ) AS killdate
FROM table1
WHERE field1 > 0 AND ( ' $currentdt'
BETWEEN '$startdt' AND UNIX_TIMESTAMP(stopdate) )
ORDER BY stopdate DESC;

It does not return the record.

[barand]

$currentdt=date();

should give an error " wrong number of parameters for date() function.

[man]date/man returns a string (formatted date/time).

If you want the current timestamp value, use

$currentdt = time();

Also, in the where clause, you need a condition

"... WHERE fieldname BETWEEN $avalue AND $ahighervalue ...