2. PHPRunner General questions
  3. One table two different views
This topic is locked

One table two different views

 		6/2/2005 12:40:16 PM
PHPRunner General questions
prleo1 author

i have a table called employees that has two types of employees in it -

  1. employees 2. temps

    I have a column in the table that specifies whether they are an employee or a temp.
    I created the employees page by adding a where clause to pull only employees. I am wondering how I can create a temps page using the PHPRunner, the same project, and login page? It doesnt seem to me that I can use the same table in two different pages with the PHPRunner interface.
    Any ideas?
pplaut 6/2/2005

I have contemplated the same sort of thing <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4670&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />

I have thought of handling this two different ways.

  1. Writing some custom code, which I never could get to work, but I did not spend much time with it yet. Digging into the bowels of the generated code can be a little confusing at first glance.
  2. Breaking my application down into "modules". Each module of course would probably need to be in its own sub directory.
    The advantage here, is I could use PHP runner to generate all the code.........

    The disadvantage of course it it would be messy as hell to keep up with.

    Also I might be able to "rename" my scripts and then hand code a menu option to address the problem of multiple apps in multiple directories.
    My particular issue is I want a field to be hidden if you are not an admin.
    I am trying to do a simple If Then or a CASE statement.
    When I use PHP Runner to either remove the fields from view it seems to remove the field information in two places in the script. I just have not had time to "work" with it yet.
    I would be interested further in how you end up handling this.
    Peer