phpmyadmin and PHP sql

[asfaw]

I spent more than two hours to find out why the following query runs in phpmyadmin and not using a php script.

phpmysql (returns one record)

SELECT conditionofpayment,paymentduedate,amountdue,invoiceappdate,amountpaid, contractID FROM tbl_conditionofpayments, tbl_paymentschedules,tbl_contracts


WHERE (tbl_paymentschedules.conditionofpaymentid=tbl_conditionofpayments.conditionofpaymentid  )
AND
(tbl_contracts.contractNumber=tbl_paymentschedules.contractNumber)
AND
(contractID='6')

PHP Script (returns no 0 record)

$query = "SELECT tbl_conditionofpayments.conditionofpayment,tbl_paymentschedules.contractNumber,
paymentduedate,amountdue,invoiceappdate,amountpaid, contractID
 FROM tbl_conditionofpayments, tbl_paymentschedules,tbl_contracts
WHERE (tbl_paymentschedules.conditionofpaymentid=tbl_conditionofpayments.conditionofpaymentid  )
AND (tbl_contracts.contractNumber=tbl_paymentschedules.contractNumber)
AND (tbl_contracts.contractID=6)";

Your help is very much appreciated.

Regards,

Asfaw

[devinemke]

well, i suppose the obvious answer is you are getting two different results because you are running two different queries. actually, your php script doesn't run a query at all, it simply creates a string (perhaps this is not the entire script?).

[asfaw]

I am sorry. The entire PHP script is:

$query = "SELECT tbl_conditionofpayments.conditionofpayment,tbl_paymentschedules.contractNumber,
paymentduedate,amountdue,invoiceappdate,amountpaid, contractID
 FROM tbl_conditionofpayments, tbl_paymentschedules,tbl_contracts
WHERE (tbl_paymentschedules.conditionofpaymentid=tbl_conditionofpayments.conditionofpaymentid  )
AND (tbl_contracts.contractNumber=tbl_paymentschedules.contractNumber)
AND (tbl_contracts.contractID=6)";

$rs_payments = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
$row_rs_payments = mysql_fetch_assoc($rs_payments);

Regards,

Asfaw