I have a drop down in my home page and depending on that, a grid will be displayed on the next page. The code of my first page can be found here . As for grid.php file,

$sql=’SELECT CONCAT(issues.type,”0″,issues.kbid) as KBID,issue_tasks.PARENTID as Parent,issues.issuesummary as Summary,products.productdescription as Product,organizations.shortname as Organization,issue_priorities.description as Priority,date_format(issues.createddate, “%d/%m/%Y”) as Reported,date_format(issues.lastupdated, “%d/%m/%Y”) as Updated,issue_status.statusdescription as Status,issue_resolutions.resdescription as Resolution,users.logon as Assigned FROM issues
INNER JOIN issue_priorities ON issue_priorities.VALUE = issues.PRIORITY – 1
INNER JOIN issue_resolutions ON issue_resolutions.RESID = issues.RESOLUTION
INNER JOIN users ON users.ID = issues.ASSIGNEDUSERID
INNER JOIN products ON products.PRODUCTID = issues.PRODUCTID
INNER JOIN organizations ON organizations.orgid = issues.creatingorg
INNER JOIN issue_status ON issue_status.STATUSID = issues.STATUS
LEFT JOIN issue_tasks ON issue_tasks.CHILDID = issues.KBID
WHERE ‘;
$sql.=$options;

on echo of query, I get the correct query. But on execute, I do not get the required table. Should I use col formatter or am I giving something wrong?

• This topic was modified 9 years, 5 months ago by kthilagarajan.