i need help to select command

[aep91]

i try to make a select table with condition now such as;
<?
...

$res = $conn->Execute("SELECT ID_SKENARIO,DATE_I FROM T_SCENARIO WHERE DATE_I = NOW");
While(!$res ->EOF)
{
echo $res->fields[0];
}
...

?>

what is the right synta for condition date is now ?
please help me...
:sad:

[Kate Albany]

Hi,

Use 'sysdate' - without the quotes.

example:

select sysdate from dual
/

Kate

[aep91]

thank's very greatfull for Kate Albany
for U're solution..
it's work well

(--^^--)