No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND UPPER(C.CompanyNam_EN) like "%"ORDER BY CompanyName' at line 15 SQL=SELECT
C.CompanyId as CompanyId, C.CompanyNam_EN as CompanyName, C.CompanyAddre_EN as CompanyAddress,C.CompanyZip as CompanyZip,
C.CompanyCit_EN as CompanyCity, C.CompanyPhone as CompanyPhone, C.CompanyFax as CompanyFax, C.CompanyEmail as CompanyEmail,
C.CompanyUrl as CompanyUrl,
C.CompanyLogo_EN as CompanyLogo,
P.CompPropName_EN as CompPropName, P.CompPropValue_EN as CompPropValue, C.CompTypeID as CompTypeID
FROM Companies C,CompanyProperties P
WHERE P.CompanyId = C.CompanyId
AND P.CompPropOrderBy =
(SELECT min(I.CompPropOrderBy)
FROM CompanyProperties I
WHERE I.CompanyId=P.CompanyId)
AND C.CompanyActive = 1
AND C.CompTypeID =
AND UPPER(C.CompanyNam_EN) like "%"ORDER BY CompanyName