i need help to select command

Expand Post »

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...

Similar Threads

A mysql select question. in MySQL
Windows will not start... help please. in Troubleshooting Dead Machines
how do i update to Access db? in C#
win98: had no product key now can't uninstall in Windows 95 / 98 / Me
Please Help...Connecting 2 Laptops in Networking

aep91

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Feb 2006

Permalink

Feb 28th, 2006

Re: i need help to select command

Hi,

Use 'sysdate' - without the quotes.

example:

select sysdate from dual
/

Kate

Kate Albany

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

71 posts
since Jun 2005

Permalink

Mar 1st, 2006

It's work well

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

(--^^--)

aep91

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Feb 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: resultset updatable

Next Thread in Oracle Forum Timeline: sql help

DaniWeb Message

Cancel Changes

User Name
Password