Hi,
I have a table with ads, and a table with offers for that add.
The link between them is the add ID whic is: BC_RequestID
I would like to display in column the number of offers received for that add:
$BC_RequestID=$this->BC_RequestID->ListViewValue();
$sql = "SELECT * FROM Requests_Basic_Offers WHERE BC_RequestID = '$BC_RequestID'";
$rs = ew_Execute($sql);
$offers=$rs->RecordCount();
$this->ListOptions->Items["addetail"]->Body = "
Offers received: $offers";
However, it seems impossible to find online how to do it, if I put the syntax from normal php and mysql is asking me to login again on mysql. Please help.
Thank you.
PS: Is there any post with how to add substract count etc, in phpmaker?