WHERE in Ajax

jarg5487

Hi,

I have a new problem. I need get the data from Agent Table Where AccountStatus = "Paid". Where I can put the query "WHERE".
[code]
$aColumns = array("AgentID","ContactName","CompanyName","(SELECT StateName FROM StateOrProvince WHERE Agent.State = StateId)","RecurringBilling","Email","PhoneNumber");

$sIndexColumn = "AgentID";

$sTable = "Agent";
[/code]

Thanks

allan

Add it to the part of the script where the `WHERE` section is built up. Around line 100.

Allan