Examples of Case Statements

[tjbarr]

Does anyone have code that uses case statements in php?

[tijger]

hey tjbarr,

what case statement do you mean? that of switch? as in:

switch ($i) {
    case 0:
        print "i equals 0";
        break;
    case 1:
        print "i equals 1";
        break;
    case 2:
        print "i equals 2";
        break;
}

and what do you want to know?

greetings, tijger

[tjbarr]

I'm not sure how to explain it but I will have to query different tables depending on the users selections.

e.g.

Table1:Counties only_source1
Table2:Counties only_source2
Table3:States only_source1
Table4:States only_source2
Table5:Regions
Table6:Variables
Table7:Computed Indicators
Table8:Economic Indicators

The tables are too large to combine.

First the user selects a region - then years.
Then the user selects an Economic indicator

Depending on the economic indicator the user gets a list of choices for variables and computed indicators in which they can pick multiple selections. The variables are from different sources.

Now I'm not sure what to do next. Should it be cases

e.g.
case1: region ="state" and indicator=5 and variable=2 and computed=2 then
select from table1 1979, 1980, varcode, reg;
where varcode=2, region=state;