this is my code, and the error is this,
Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ‘SINN’. (severity 15) in D:myprogsxampphtdocsrhyanjesonlist.php on line 215
Warning: mssql_query() [function.mssql-query]: message: Unclosed quotation mark before the character string ’ AND GL30000.ACTINDX = ’ GROUP BY PM00200.VENDNAME, PM00200.VENDORID, GL30000.ORMSTRNM, GL30000.ACTINDX’. (severity 15) in D:myprogsxampphtdocsrhyanjesonlist.php on line 215
Warning: mssql_query() [function.mssql-query]: Query failed in D:myprogsxampphtdocsrhyanjesonlist.php on line 215
Query Error
this is the line 215
$sql = "SELECT PM00200.VENDNAME, PM00200.VENDORID, GL30000.ORMSTRNM, GL30000.ACTINDX, sum(GL30000.CRDTAMNT) as cretotal, sum(GL30000.DEBITAMT) as debtotal FROM PM00200 INNER JOIN GL30000 ON PM00200.VENDORID = GL30000.ORMSTRID WHERE PM00200.VENDORID = '$myvendorid' AND GL30000.ACTINDX = '$lnedx' GROUP BY PM00200.VENDNAME, PM00200.VENDORID, GL30000.ORMSTRNM, GL30000.ACTINDX";
[code]<?
$hr_q=mssql_query("SELECT VENDNAME, VENDORID FROM PM00200 ORDER BY VENDNAME",$cs);
while ($data=mssql_fetch_array($hr_q)){
$myvendor=$data['VENDNAME'];
$myvendorid=$data['VENDORID'];
$sql = "SELECT PM00200.VENDNAME, PM00200.VENDORID, GL30000.ORMSTRNM, GL30000.ACTINDX, sum(GL30000.CRDTAMNT) as cretotal, sum(GL30000.DEBITAMT) as debtotal FROM PM00200 INNER JOIN GL30000 ON PM00200.VENDORID = GL30000.ORMSTRID WHERE PM00200.VENDORID = '$myvendorid' AND GL30000.ACTINDX = '$lnedx' GROUP BY PM00200.VENDNAME, PM00200.VENDORID, GL30000.ORMSTRNM, GL30000.ACTINDX";
$r = mssql_query ( $sql, $cs ) or die ( 'Query Error' );
while ( $row = mssql_fetch_array ( $r ) ){
$mydebfew=$row['debtotal'];
$mycrefew=$row['cretotal'];
}
echo ‘
’.$myvendorid.’ | ’.$mydebfew.’ | ’.$mycrefew.’ |
}
?>[/code]