can anybody help me with below coding. There are data in the database but the record won't come out. What's wrong with this coding. I am very new in PHP...but I familiar with ASP...please..please


$sql="SELECT Acquirer_Master.Name, Fraud_Score.Score, Transaction_Master.* FROM ((Acquirer_Master INNER JOIN Merchant_Master ON Acquirer_Master.Merchant_Id = Merchant_Master.Merchant_Id) INNER JOIN Transaction_Master ON (Acquirer_Master.Acquirer_Id = Transaction_Master.AcquirerID) AND (Merchant_Master.Merchant_Id = Transaction_Master.Merchant_Id)) INNER JOIN Fraud_Score ON Transaction_Master.Trx_Id = Fraud_Score.Transaction_Id WHERE Transaction_Master.TimeStamp = #" .$TimeStampDate."#";
if ($merchant <> 0)
{
$sql=$sql . "WHERE MERCHANT_MASTER.MERCHANT_ID = '" .$merchant. "'";
}
if ($transdate <> "")
{
$sql=$sql . "AND TRANSACTION_MASTER.TIMESTAMP = #" .$transdate. "#";
}
if ($paymentmode <> 0)
{
$sql=$sql . "AND TRANSACTION_MASTER.PAYMENT_MODE = '" .$paymentmode. "'";
}
if ($status <> "")
{
$sql=$sql . "AND TRANSACTION_MASTER.STATUS = '" .$status. "'";
}
$rs=odbc_exec($conn,$sql);

if (!$rs)
{
exit("Error in SQL");
}

It looks like you are not separating the clauses with spaces, which may be causing problems. You should echo the SQL query to the screen so you can make sure it is correct, and then copy and paste the query into an alternative database tool (e.g psql for postgres) so you can see if there is actually any data.

thanks..this is after i change the statement. It seems like it does read the if statement.

$sql="SELECT Acquirer_Master.Name, Fraud_Score.Score, Transaction_Master.* FROM ((Acquirer_Master INNER JOIN Merchant_Master ON Acquirer_Master.Merchant_Id = Merchant_Master.Merchant_Id) INNER JOIN Transaction_Master ON (Acquirer_Master.Acquirer_Id = Transaction_Master.AcquirerID) AND (Merchant_Master.Merchant_Id = Transaction_Master.Merchant_Id)) INNER JOIN Fraud_Score ON Transaction_Master.Trx_Id = Fraud_Score.Transaction_Id WHERE Merchant_Master.Merchant_Id = Transaction_Master.Merchant_Id" ;
if ($merchant <> 0)
{
$sql=$sql . "AND MERCHANT_MASTER.MERCHANT_ID = '" .$merchant. "'";
}
if ($transdate <> "")
{
$sql=$sql . "AND TRANSACTION_MASTER.TIMESTAMP = #" .$transdate. "#";
}
if ($paymentmode <> 0)
{
$sql=$sql . "AND TRANSACTION_MASTER.PAYMENT_MODE = '" .$paymentmode. "'";
}
if ($status <> 0)
{
$sql=$sql . "AND TRANSACTION_MASTER.STATUS = '" .$status. "'";
}
echo $sql;
$rs=odbc_exec($conn,$sql);

sorry...it does not read the if statement

Please..anyone...help me..

hi..
I'll try to answer... (but sorry for my english before )
Like CroMagnon said that it seems you have to look at the strings at your SQL statement (it needs spaces after the quotes).

## if ($merchant <> 0)
## {
## $sql=$sql . "AND MERCHANT_MASTER.MERCHANT_ID = '" .$merchant. "'";
## }

it think you should add spaces so it looks like this..

if ($merchant <> 0)
{
$sql=$sql . " AND MERCHANT_MASTER.MERCHANT_ID = '" .$merchant. "' ";
}


I hope it help..

br,
Rizal

Thank you for all..It's work..thank you soo much