Index
» Projects
» phpMyEdit
» Forum
» Filter or TAB? |
|
dglp
Joined: 09 Nov 2014
Posts: 2
Posted: 2014-11-09 11:07
Back to top
Reply with quote
|
I'm just setting up an instance ot phpMyEdit, and am wondering whether it's simpler to display a subset of columns using a filter, or the TAB functions.
I've got a table (projectdetails) of 30 columns and 200 records I want to show just three columns of the main table (id, name, mapit), as an index of sorts.
I am thinking the filter option requires defining a WHERE clause that includes evey record of the three columns. Not sure how I'd do that.
So perhaps the TAB function would be easier? I'm looking for examples.
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2014-11-09 18:04
Back to top
Reply with quote
|
Set 'options' for id, name, mapit to ACPVDFL and set the other columns to ACPVD
http://opensource.platon.sk/projects/doc.php/phpMyEdit/html/configuration.permission-options.html
|
dglp
Joined: 09 Nov 2014
Posts: 2
Posted: 2014-11-09 20:45
Back to top
Reply with quote
|
Very nice! Thank You!
So, for example, project_name options look like this:
Code: |
$opts['fdd']['project_name'] = array(
'nowrap' => 'true',
'name' => 'Project name',
'select' => 'T',
'options' => 'ACPVDFL',
'maxlen' => 65535,
'textarea' => array(
'rows' => 5,
'cols' => 50),
'sort' => true
); |
And the main page is clean aside from the columns I want.
*A further question?*
Can the navigation links be assigned to the project name field? So that I can click on the name to view the detail page...
|
Post new topic
Reply to topic
|
|
|
|