help with query

[derksj]

why does this query work

$resultgeffiateerd = mssql_query("select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = 412 order by lngPeriod Desc");

and this query not

$resultgeffiateerd = mssql_query("select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = '$persoonsid' order by lngPeriod Desc");

[bad76]

Hi,
try to output $persoonsid or the query:

$query="select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = '$persoonsid' order by lngPeriod Desc";
echo $query;
$resultgeffiateerd = mssql_query(); 
 

[Wynder]

$query="select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = '$persoonsid' order by lngPeriod Desc";

Do this:

$query="select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = '" . $persoonsid . "' order by lngPeriod Desc"; 

[Lars_Berg]

Since lngPersID is a numeric column you can't compare it to a character value.

$query="select distinct lngPeriod from dbo.vwPHPFaFiat where lngPersID = " . $persoonsid . " order by lngPeriod Desc";

[derksj]

many thanx
i solved the problem