Welcome to xCrud Community - Data Management and extended PHP CRUD

[ben74]

Hello,

I can't find a solution to this and I've searched hours, it must be hidden somewhere in the source code.

Anyway here is the problem : I'm using a custom query similar to :

Select blabla as col1, doudou as col2 from ...

Then I expected to be able to use the names col1 and col2 as regular table column names, i.e. be able to write:

$xcrud->column_width('col1','90px');

But this doesnt work...

I've also tried with the database name in front of the field (so $xcrud->column_width('dbname.col1','90px'); ) but still no chance...

Any idea?

Thanks a lot!

 

[DaDo]

Hello,

I can't find a solution to this and I've searched hours, it must be hidden somewhere in the source code.

Anyway here is the problem : I'm using a custom query similar to :

Select blabla as col1, doudou as col2 from ...

Then I expected to be able to use the names col1 and col2 as regular table column names, i.e. be able to write:

$xcrud->column_width('col1','90px');

But this doesnt work...

I've also tried with the database name in front of the field (so $xcrud->column_width('dbname.col1','90px'); ) but still no chance...

Any idea?

Thanks a lot!

You have to use subselect

$xcrud->subselect('field_name','Select blabla as col1');
$xcrud->subselect('field_name2','Select doudou as col2');