Editorial Board

    Error

    SQL-query:

    SELECT
            CONCAT(firstname, ' ',surname) AS name,
            email,
            fax,
            CONCAT(address1,
                    IF(address2='','',', '),address2,
                    IF(address3='','',', '),address3,
                    IF(city='','',', '),city,
                    IF(postalcode='','',', '),postalcode,
                    IF(country='','',', '),country) as address
    FROM
            contacts
    WHERE
            type='Editorial Board'
    ORDER by surname

    MySQL said: Unknown column 'address1' in 'field list'
    Back