Re: PHP creates query that has to be edited before it will run in MySql

[Peter Brawley]

Much simpler than fussing with all those quotes and concatenations:

$query = "
SELECT `recId`,`key`,`IDno`,`VendorId`,`AccountNo`, `Category`,
`Internet`,`Internet2`, `Company`, `Email`,`Email2`,`Phone`,
des_decrypt(`internetid`, 'alibaba511')AS 'internetid',
des_decrypt(`PW`, 'alibaba511') AS 'PW',
des_decrypt(`licensekeypin`, 'alibaba511') AS 'license',
`EmailOfRecord`, `Hints`
FROM `account` WHERE `Company`= 'Fay School'
";

And you could simplify your life further by adopting the convention of never using reserved words like `key` as column names, so you could skip all those bug-inviting backticks, eg ...

$query = "SELECT recId, thekey, IDno, VendorId, AccountNo, Category,
Internet,Internet2, Company, Email,Email2,Phone,
des_decrypt(internetid, 'alibaba511')AS 'internetid',
des_decrypt(PW, 'alibaba511') AS 'PW',
des_decrypt(licensekeypin, 'alibaba511') AS 'license',
EmailOfRecord, Hints
FROM account WHERE Company= 'Fay School'
";