[SOLVED] DateTime QueryString Problems

[selliott]

I'm not real familiar with PHP, so I can quite get this querystring to work.  Anyone see what I'm doing wrong?

 

$date='DateTime.Now.ToString("yyyyMMdd")';

$QueryString="SELECT Top 5 * FROM red.apples WHERE Terminate > '$date' ORDER BY ViewCount DESC";

[ratcateme]

where did u get

$date='DateTime.Now.ToString("yyyyMMdd")';

from

try

$QueryString="SELECT Top 5 * FROM red.apples WHERE Terminate > NOW() ORDER BY ViewCount DESC";

 

Scott.

[selliott]

When I try that, an error says 'NOW' is not a recognized function name

 

I'm on a windows server if that makes a difference. 

[bubbasheeko]

NOW() works on a MySQL server, are you using MySQL or MSQL?

[selliott]

  Quote

NOW() works on a MySQL server, are you using MySQL or MSQL?

 

MSSQL

[bubbasheeko]

NOW() does not work on MSSQL.

 

Substitute NOW() with GETDATE() in the above provided example.

[selliott]

  Quote

NOW() does not work on MSSQL.

 

Substitute NOW() with GETDATE() in the above provided example.

 

That did it! THANKS!

[bubbasheeko]

No problem....glad I could help!