Jump to content

Archived

This topic is now archived and is closed to further replies.

djed

MSSQL - Query Last 30 Days

Recommended Posts

Hi:

The following code worked fine in Mysql (Note: Already changed mysql to mssql).  It queries a table for songs added in the last 30 days (today - 30).

[i]$sqlconnect=mssql_connect($server,$username,$password);
$sqldb=mssql_select_db("xx",$sqlconnect);
$dayspast = 30;
$result = mssql_query("
SELECT date_added, artist, title, album
FROM songlist
WHERE (songtype='S')
AND date_added > (SUBDATE(NOW(),INTERVAL '".$dayspast."' DAY))
ORDER BY date_added DESC, artist,title,album", $sqlconnect);[/i]

I am getting an error saying NOW is not a recognized function name.

Can someone help me code this correctly for a MS SQL DB?

It would be GREATLY appreciated.

Thanks

Ed

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.