Select within a Select

[snivek]

This query is blowing up and I do not know why
[code]
<?php
$sql = "SELECT DateDiff(\"d\", (SELECT TOP 1 dhcp_log_date FROM dhcp_log ORDER BY dhcp_log_date ASC), GetDate())";
$result = mssql_query($sql);
?>
[/code]


Here is the query PRINTED, and the error.
SELECT DateDiff("d", (SELECT TOP 1 dhcp_log_date FROM dhcp_log ORDER BY dhcp_log_date ASC), GetDate())
Warning: mssql_query() [function.mssql-query]: message: Invalid parameter 1 specified for datediff. (severity 15) in E:\DHCPLogs\index.php on line 48

The same query works fine from SQL Mgmt Studio.

Also - the following query executes without any prob from php.
[code]
<?php
$sql = "SELECT TOP 1 dhcp_log_date FROM dhcp_log ORDER BY dhcp_log_date ASC"
?>
[/code]

[MCP]

try this maybe?
[code]
<?php
$sql = "SELECT DateDiff('d', (SELECT TOP 1 dhcp_log_date FROM dhcp_log ORDER BY dhcp_log_date ASC), GetDate())";
$result = mssql_query($sql);
?>
[/code]