REGOGNISED PASTED SQL CODE

GOT RS FOR MYY MRT DETIL PAGE AS A BLOCK OF COODE THAT I JUST WANT TO COPY AND PASTE DUE TO MY ISSU‰ WHITH TYPING

THE SB PANEL REFUSED TO RECOGNITES THIS NEW ISSERTION ANY SUGGESTIONS

ITSTHE RS MRTDBMADI_DETAIL NOT SEEN

Use this:

<?php

$MRTdbmADI_details = new WA_MySQLi_RS("MRTdbmADI_details",$dbUpdate,1);

$MRTdbmADI_details->setQuery("SELECT dbmADI.*, GROUP_CONCAT(dbmSite.dbmSite SEPARATOR ',  ') AS SelSites FROM dbmADI LEFT OUTER JOIN MRT07 ON dbmADI.dbmADIID = MRT07.MRT07dbmADIID LEFT OUTER JOIN dbmSite ON dbmSite.dbmSiteID = MRT07.MRT07dbmSiteID WHERE dbmADI.dbmADIID = ?");

$MRTdbmADI_details->bindParam("i", "".(isset($_GET['dbmADIID'])?$_GET['dbmADIID']:"")  ."", "-1"); //WAQB_Param1

$MRTdbmADI_details->execute();

?>

You had extra spaces and dollar sign in your code preventing it from being recognized.

it now recognised the SB
NOOW GET SQL ERROR

got it working but now goy other issues

insert page the primary page record number is 1 out in the MRT table main says 1065 but MRT SAYS 1064
Insert & update pages load the file name int the field only
no physical file upload, and the file gets incremented regardless and this is happening even no file transfer

Please post one issue at a time with as much detail as possible as well as a url to reproduce and a copy of the page you are working on. I can't quite figure out what is wrong or comment on solutions based on your previous post. Please also start a new thread for each issue so that I can track and answer them efficiently.