[blinn_shade]

Hey,

Just wondering. Can while() be used in the switch() to create case's from the loop?

such as:

PHP Code:

// This is not real coding. Just a demo

$result = query();

while($row = fetch($result)){
       
       case $row['name'];
       
              // content here.

       break;

}

// ???????????????????????? 

Thanks.

[Nico]

No, you cannot create cases like this, dynamically.

If you tell us what you're trying to achieve, we may can help you find another solution.

[blinn_shade]

Hey,

I have another solution but I was just wondering. I tested this and your right it doesn't work. I am going to use if statements

Thanks.

[job0107]

blin_shade, I like the way you think. I believe there is a way to create
a SWITCH() case... case... case... using a database. I believe this method
would give you a lot of flexibility.

PHP has a function called eval(). It evaluates all data as PHP code and
executes it. So, all you would need is a table with two fields. A case field
and an action field. The case field can hold any case. And the action field
can hold any PHP code.

Something like this:

PHP Code:

<?php
$case = isset($_POST["case"]) ? $_POST["case"] : isset($_GET["case"]) ? $_GET["case"] : 1;
$server   = ""; // MySQL hostname
$username = ""; // MySQL username
$password = ""; // MySQL password
$dbname   = ""; // MySQL db name
$table = ""; // Table name
mysql_connect($server,$username,$password) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$results = mysql_query("SELECT * from $table");
while($row = mysql_fetch_array($results)){if($case == $row["case"]){eval($row["action"]);}}
?>