Jump to content


Photo

MSSQL - Query Last 30 Days


  • Please log in to reply
1 reply to this topic

#1 djed

djed
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 02 July 2006 - 01:21 AM

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

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



#2 argoSquirrel

argoSquirrel
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts

Posted 12 September 2006 - 03:41 AM

AND " . $daysPast . " > DATEDIFF(d, date_added, GETDATE())




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users