[Resolved] using switch...case stmt w/ array or for loop?, switch..case, arrays, for loops

ski_woman

Hi,

I have done a little digging and have found out about switch...case statements. I like them because they look cleaner than extremely long if...else chains.

My question is this: if I have an extremely long if...else chain which then becomes a very long switch...case statement, can I somehow use a for loop to build the case statement? Maybe store the case parameters in an array?

I am creating a php application but my code is very long and very inefficient. I would like to make it neater and more logical. I think I have hardcoded so many work-arounds that it is a very large mess.

Do you have any suggestions on how to think about solving this? Or could you tell me where to look?

Any suggestions you could give would be appreciated.

I've attached a file with the lengthy switch statements in it.

trex005

well I see that you are Using MySQL... could you not just have a table with
program,category,catigory_id
and then do a simple SELECT

$sql = "
SELECT
category_id
FROM
table_name
WHERE
program = '$program'
AND
category = '$category'
";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$categoryID = $row['category_id']

Yes I know going through all those MySQL functions seems to be a waste when just looking for 1 field for 1 row... but it is my style! 🙂

ski_woman

Thanks! This worked. Doh!

trex005

And Thank you for marking it resolved!!

ski_woman

I saw that it wanted me to. What does that do? I'm sure it does something important for the people who administer this forum.

trex005

I'm actually not an administrator, but when browsing the threads for people to help if something is marked resolved it saves MUCH time!