while loop within a switch statement?

[La_Parka]

Is it possible for a while loop to create cases within a switch statement? I've tried:

switch ($type)
  {
$query = @mysql_query("SELECT * FROM table");
while ($row = mysql_fetch_array($query)) 
      {
       case $row[id]:
       echo "".$row[field]."";
       break;
       }

  }

but I get an "unexpected T_VARIABLE, expecting T_CASE or T_DEFAULT" error.

[TheIceman5]

no it wont work

[Weedpacket]

I'm at a total loss to understand why something like that would be useful, but if you insisted on doing whatever it is you're doing that way you could build the entire switch(...){......} statement in a string, and then calling eval() on it.

[tasistro]

Try letting the dbase do the switch and while it is better at it...

Look into the following...

$query = @("SELECT * FROM table WHERE id=".$type);
$row = mysql_fetch_array($query);
echo "".$row[field]."";