Jump to content

djed

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

djed's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
×
×
  • Create New...

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.