Topic awaiting preservation: switch & select: more than 3? (Page 1 of 1)

Hola.
Stoopid question:
how many 'case' can I have into a switch statement??
I'm asking this because the script does not work when I add more than 3 select.
The script: <BLOCKQUOTE><FONT face="Verdana, Arial">code:</font><HR><pre>
switch($var) {
case "borrar":
$query_delete = "delete from espera where ID = " . $hola . " ";
$result_delete = mysql_query($query_delete, $link);
echo "mensaje eliminado<br> <a href=index.php>regresar a administración</a> <br><a href=../index.php>ir a contactos</a>";
break;

case "aceptar":
$query_darAlta = "INSERT INTO post SELECT * FROM espera WHERE ID = " . $hola . "";
$result_darAlta = mysql_query($query_darAlta) or die ("Could not query.");
$query_delete = "delete from espera where ID = " . $hola . " ";
$result_delete = mysql_query($query_delete, $link);
echo "mensaje agregado a los contactos<br> <a href=index.php>regresar a administración</a> <br><a href=../index.php>ir a contactos</a>";
break;

case "editar":
$query_select = "select nombre,pais,img1,thumb1,mensaje,email,categoria,img2,thumb2,img3,thumb3,img4,thumb4,ref,id from espera where ID = " . $hola . " ";
$result_select = mysql_query($query_select, $link);
$num_posts = mysql_num_rows($result_select);
while ($row = mysql_fetch_array($result_select)) {
echo "<TR bgColor=#444444>\n";
echo "<td align=left Valign=top width=150>\n";
echo "<b>".$row[0]."</b>\n";
echo "<br>".$row[1]."\n";
echo "<br><FORM action=update.php method=post><input type=text name=mail value=".$row[5].">\n";
echo "</td>\n";
echo "<td align=left Valign=top>Categoría:<b>
<select name=categoria size=1>
<option value='".$row[6]."' selected>".$row[6]."</option>
<option value='chica busca chica'>chica busca chica</option>
<option value='chica busca chico'>chica busca chico</option>
<option value='chica busca pareja'>chica busca pareja</option>
<option value='chico busca pareja'>chico busca pareja</option>
<option value='chico busca chico'>chico busca chico</option>
<option value='chico busca chica'>chico busca chica</option>
<option value='pareja busca pareja'>pareja busca pareja</option>
<option value='pareja busca chico'>pareja busca chico</option>
<option value='pareja busca chica'>pareja busca chica</option>
</select></b>

in theory, your case can have as many conditions as you'd like to have.
hm, what does the script say when it 'breaks'?
I can't find anything wrong with it just glancing over it...

so long,

Tyberius Prime

Sorry TB, My BAd. The error is this:
Parse error: parse error, unexpected T_DEFAULT in /httdoc/process.php on line 172

*forgots the edit buttom*

Oh, and the line error changes if I delete one select. Always point to the last'select'. And so until I leave just 3 selects

You have a syntax error in the fourth case statement...

if (count($del) > 1) {
for ($i=0;$i<count($del);$i++) {
$result[$i] = mysql_query("DELETE FROM espera WHERE id = '$del[$i]'");
}
} <-- you forgot the closing bracket for if statement

Jheez, me and my stupids sintaxis mistakes!!!
I'm changing and testing!

(BRB)

No, it doesn't work, even if I delete the complete 'case' statement.......
I have to delete 2 cases to make it work, looks like there's a limit (thought I've learned that cases have no limit)

Yeah, but the } was missing in the second select

Well, you have another syntax error in the third case statement ("editar"). You forgot to close while statement...