Using 'AS FIELDNAME' in sql fails

I have an sql that uses this snippet:

CONCAT(last_name, ', ', IF(prefix > '',CONCAT(prefix,' '),''),first_name,' ',IF(mi > '',mi,''),IF(suffix > '', CONCAT(', ',suffix),'')) AS fName, "

when I run the sql I get this error:

SQL Error found in query: SELECT account_number,temp_acct_num,fName,city,state,zip,zip4,ext1,email,status,trx FROM accounts WHERE last_name > '' ORDER BY last_name ASC LIMIT 0, 30

Error Message: Unknown column 'fName' in 'field list'

Is there a work around that I can use to run this sql?

TIA,
Paul Dubinsky

Hi,

are you using $objGrid -> sqlstatement to define The SQL?

Yes, I am.

But, I have found a work around which is to create a temporary MySQL table with the fields that I want from the first sql and then to build the phpmdg grid from the temporary table. That way the phpmdg grid sees the "as fName" as a legitimate table column and never sees the complex CONCAT statement.

Paul

$objGrid->FormatColumn("Personnel", "Personnel", 100, 100, 0, "100", "center","SELECT
* FROM Personnel");

doesn't work and I got this error

Warning: Invalid argument supplied for foreach() in /Applications/XAMPP/xamppfiles/htdocs/stem/phpmydatagrid.class.php on line 1079

in your website, it states the free version has the ability to select field to dynamic make a dropdown menu.

Please let me know. Thanks

you are using a wrong format the correct one should be:

$objGrid->FormatColumn("Personnel", "Personnel", 100, 100, 0, "100", "center","select:SELECT field1, field2 FROM Personnel");