Hi there, I'm trying to do the folowing in PHP 4 on Windows NT 4.0 connecting to a MSSql database....
$sql = "SELECT * FROM siterank order by ranking desc, DestHost WHERE logTime >= '2001-11-08 00:00:00'";
and I get....
Warning: MS SQL message: Incorrect syntax near the keyword 'WHERE'. (severity 15) in e:\Inetpub\wwwroot\temp.php on line 57
Warning: MS SQL: Query failed in e:\Inetpub\wwwroot\temp.php on line 57
Couldn't execute query.
If I take out the WHERE clause the query runs fine.....this is the right way to do it isn't it?
