PHP - Switch Problem

Hello again having trouble to switch pages

All it dose just refrashe page 

<a href=/?p=cinema&pid=503&act=video>Test</a>

Quote

$keiciam = isset($_GET['act']) ? $_GET['act']:'';
switch($keiciam)
{
case 'video':

eval("\$cinema_player = \"".$TSUE['TSUE_Template']->LoadTemplate('cinema_player')."\";");
      

break;
default:
}

Morning,

I'm working on a web site using a switch to separate different calls from a MySQL database.  My style looks like this:


<?php

switch ($_GET['page']) {
     case 'news':
           echo ("NEWS HERE"); }
           break;
     case 'schedule';
          echo ("SCHEDULE HERE"); }
          break;
     default:
          echo ("MAIN PAGE HERE");
     break;
}


What I am trying to do, is specify that if the page is news, there can be an additional variable for id.  I attempted before and after the break; for the news case, to make a new switch, but it isn't taking.  I've looked around online, but can't find any information about this.  Can anyone offer a hand?

Code: [Select]
<?php

switch($_GET['action']){
case 'delete':
      
break;
case 'edit':
case 'write':


  if($action=='edit'){
$form_action = 'edit_ok';
echo 'Edit Page';
  }else{
$form_action = 'write_ok';
echo 'Write Page';
  }



?>
<?php
$id=$_GET['id'];
$result = mysql_query("SELECT * FROM project_data WHERE id='$id'");
$row = mysql_fetch_array($result);
?>

                <table border = "1">
<form action="switch.php?id=<?php echo $row['ID']?>&action=[color=purple][b]<?php echo $action ?>[/b][/color]" method="post">
<tr>
<td>Date Of Birth</td>
<td><input type="text" name="dateofbirth" value="<?php echo $row['Date_Of_Birth']?>"/></td>
  </tr>
  <tr>
<td>Gender</td>
<td><input type="radio" name="gender" value="male" <?php if($row['Gender']=='male'){echo 'checked';}?>/> Male<input type="radio" name="gender" value="female" <?php if($row['Gender']=='female'){echo 'checked';}?>/> Female</td>
  </tr>
  <tr>
<td>Title</td>
<td><select name="title">
<option value="">Please Select</option>
<option value="Mr" <?php if($row['Title']=='Mr'){echo 'selected';}?>>Mr</option>
<option value="Ms" <?php if($row['Title']=='Ms'){echo 'selected';}?>>Ms</option>
<option value="Mrs" <?php if($row['Title']=='Mrs'){echo 'selected';}?>>Mrs</option>
<option value="Miss" <?php if($row['Title']=='Miss'){echo 'selected';}?>>Miss</option>
<option value="Other" <?php if($row['Title']=='Other'){echo 'selected';}?>>Other</option>
</select></td>
  </tr>
  <tr>
<td>First Name</td>
<td><input type="text" name="firstname" value="<?php echo $row['First_Name']?>"/></td>
  </tr>
  <tr>
<td>Last Name</td>
<td><input type="text" name="lastname" value="<?php echo $row['Last_Name']?>" /></td>
  </tr>
  <tr>
<td>Address Line 1</td>
<td><input type="text" name="address1" value="<?php echo $row['Address_Line_1']?>" /></td>
  </tr>
  <tr>
<td>Address Line 2</td>
<td><input type="text" name="address2" value="<?php echo $row['Address_Line_2']?>" /></td>
  </tr>
  <tr>
<td>City</td>
<td><input type="text" name="postcode" value="<?php echo $row['City']?>" /></td>
  </tr>
  <tr>
<td>Postcode</td>
<td><input type="text" name="postcode" value="<?php echo $row['Postcode']?>" /></td>
  </tr>
  <tr>
<td>Contact No</td>
<td><input type="text" name="contactno" value="<?php echo $row['Contact_No']?>" /></td>
  </tr>
  <tr>
<td>Email</td>
<td><input type="text" name="email" value="<?php echo $row['Email']?>"/></td>
  </tr>
  <tr>
<td>Additional Info</td>
<td><textarea rows="10" cols="30" name="note"><?php echo $row['Additional_Comment']?></textarea></td>
  </tr>
  <tr>
<td><input type="submit" value="Update" /></td>
<td><a href='switch.php'>Main Page</a></td>
  </tr>
  </table>
</form>


<?php


break;

//case 'write';
?>
          <!--<table border = "1">
  <form action="switch.php?action=write_ok" method="post">
  <table>
  <tr>
<td>Date Of Birth</td>
<td><input type="text" name="dateofbirth" /></td>
  </tr>
  <tr>
<td>Gender</td>
<td><input type="radio" name="gender" value="male" />Male<input type="radio" name="gender" value="female" /> Female</td>
  </tr>
  <tr>
<td>Title</td>
<td><select name="title">
<option value="" selected="selcted">Please Select</option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
<option value="Miss">Miss</option>
<option value="Ms">Ms</option>
<option value="Other">Other</option>
</select></td>
</tr>
<tr>
  <td>First Name</td>
  <td><input type="text" name="firstname" /></td>
</tr>
<tr>
  <td>Last Name</td>
  <td><input type="text" name="lastname" /></td>
</tr>
<tr>
  <td>Address Line 1</td>
  <td><input type="text" name="address1" /></td>
</tr>
<tr>
  <td>Address Line 2</td>
  <td><input type="text" name="address2" /></td>
</tr>
<tr>
  <td>City</td>
  <td><input type="text" name="city" /></td>
</tr>
<tr>
  <td>Postcode</td>
  <td><input type="text" name="postcode" /></td>
</tr>
<tr>
  <td>Contact No</td>
  <td><input type="text" name="contactno" /></td>
</tr>
<tr>
  <td>Email</td>
  <td><input type="text" name="email" /></td>
</tr>
<tr>
  <td>Additional Info</td>
  <td><textarea rows="15" cols="30" name="note">Please Enter Any Additional Information</textarea></td>
</tr>
<tr>
  <td><input type="submit" value="Submit"></td>
  <td><a href='switch.php'>Back</a></td>
</tr>
  </table>
  </form>-->

<?php

//break;
I have this code, which is basically a form for inputting and another for editing. As you can see I have made one part a comment as I want just the edit part to control the input and edit, which is shown at the very beginning with write case, and the seperate edit case, all I need to complete it is the part that I have highlighted in purple/bold.
Does anybody have any help?

Code: [Select]
<!--PHP Update-->
<?php

$con = mysql_connect("localhost","root","");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("project1", $con);

if ($_GET['action']=='delete_ok'){

}elseif ($_GET['action']=='edit_ok'){

}


switch($_GET['action']){
case 'write_ok';




$sql="INSERT INTO project_data (Date_Of_Birth, Gender, Title, First_Name, Last_Name, Address_Line_1, Address_Line_2, City, Postcode, Contact_No, Email, Additional_Comment) VALUES ('".$_POST[dateofbirth]."','".$_POST[gender]."','".$_POST[title]."','".$_POST[firstname]."','".$_POST[lastname]."','".$_POST[address1]."','".$_POST[address2]."','".$_POST[city]."','".$_POST[postcode]."','".$_POST[contactno]."','".$_POST[email]."','".$_POST[note]."')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }else{




echo '<script>alert("Data Has Been Successfully Updated");</script>';
echo '<meta http-equiv="Refresh" content="0;URL=switch.php">';
  }


break;


case 'edit_ok';

if ((!isset($_GET['id']) || trim($_GET['id']) == ''))
{
die('Missing record ID!');

}

  $id= $_GET['id'];

mysql_query("UPDATE project_data SET Date_Of_Birth='".$_POST[dateofbirth]."',Gender='".$_POST[gender]."',Title='".$_POST[title]."',First_Name='".$_POST[firstname]."',Last_Name='".$_POST[surname]."',Address_Line_1='".$_POST[address1]."',Address_Line_2='".$_POST[address2]."',City='".$_POST[city]."',Postcode='".$_POST[postcode]."',Contact_No='".$_POST[contactno]."',Email='".$_POST[email]."',Additional_Comment='".$_POST[note]."' WHERE ID='".$_GET['id']. "'") or die ("Error in query: $query. " . mysql_error());



     echo '<script>alert("Data Has Been Successfully Updated");</script>';
echo '<meta http-equiv="Refresh" content="0;URL=switch.php">';
  }


break;
case 'delete_ok':
#########Delete OK Start#################


$id= $_GET['id'];
$result = mysql_query("DELETE FROM project_data WHERE ID = '$id'")
or die ("Error in query: $query. " . mysql_error());

echo '<script>alert("Data Has Been Successfully Updated");</script>';
echo '<meta http-equiv="Refresh" content="0;URL=switch.php">';
  }


#########Delete OK End #################
break;
}
?>

<!--HTML-->

<?php

switch($_GET['action']){
case 'delete';

break;
case 'edit';
echo 'Edit page';

?>
<?php
$id=$_GET['id'];
$result = mysql_query("SELECT * FROM project_data WHERE id='$id'");
$row = mysql_fetch_array($result);
?>

                <table border = "1">
<form action="switch.php?id=<?php echo $row['ID']?> action=edit_ok" method="post">
<tr>
<td>Date Of Birth</td>
<td><input type="text" name="dateofbirth" value="<?php echo $row['Date_Of_Birth']?>"/></td>
  </tr>
  <tr>
<td>Gender</td>
<td><input type="radio" name="gender" value="male" <?php if($row['Gender']=='male'){echo 'checked';}?>/> Male<input type="radio" name="gender" value="female" <?php if($row['Gender']=='female'){echo 'checked';}?>/> Female</td>
  </tr>
  <tr>
<td>Title</td>
<td><select name="title">
<option value="">Please Select</option>
<option value="Mr" <?php if($row['Title']=='Mr'){echo 'selected';}?>>Mr</option>
<option value="Ms" <?php if($row['Title']=='Ms'){echo 'selected';}?>>Ms</option>
<option value="Mrs" <?php if($row['Title']=='Mrs'){echo 'selected';}?>>Mrs</option>
<option value="Miss" <?php if($row['Title']=='Miss'){echo 'selected';}?>>Miss</option>
<option value="Other" <?php if($row['Title']=='Other'){echo 'selected';}?>>Other</option>
</select></td>
  </tr>
  <tr>
<td>First Name</td>
<td><input type="text" name="firstname" value="<?php echo $row['First_Name']?>"/></td>
  </tr>
  <tr>
<td>Last Name</td>
<td><input type="text" name="lastname" value="<?php echo $row['Last_Name']?>" /></td>
  </tr>
  <tr>
<td>Address Line 1</td>
<td><input type="text" name="address1" value="<?php echo $row['Address_Line_1']?>" /></td>
  </tr>
  <tr>
<td>Address Line 2</td>
<td><input type="text" name="address2" value="<?php echo $row['Address_Line_2']?>" /></td>
  </tr>
  <tr>
<td>City</td>
<td><input type="text" name="postcode" value="<?php echo $row['City']?>" /></td>
  </tr>
  <tr>
<td>Postcode</td>
<td><input type="text" name="postcode" value="<?php echo $row['Postcode']?>" /></td>
  </tr>
  <tr>
<td>Contact No</td>
<td><input type="text" name="contactno" value="<?php echo $row['Contact_No']?>" /></td>
  </tr>
  <tr>
<td>Email</td>
<td><input type="text" name="email" value="<?php echo $row['Email']?>"/></td>
  </tr>
  <tr>
<td>Additional Info</td>
<td><textarea rows="10" cols="30" name="note"><?php echo $row['Additional_Comment']?></textarea></td>
  </tr>
  <tr>
<td><input type="submit" value="Edit" /></td>
<td><a href='switch.php'>Back</a></td>
  </tr>
  </table>
</form>


<?php


break;

case 'write';
?>

  <form action="switch.php?action=write_ok" method="post">
  <table>
  <tr>
<td>Date Of Birth</td>
<td><input type="text" name="dateofbirth" /></td>
  </tr>
  <tr>
<td>Gender</td>
<td><input type="radio" name="gender" value="male" />Male<input type="radio" name="gender" value="female" /> Female</td>
  </tr>
  <tr>
<td>Title</td>
<td><select name="title">
<option value="" selected="selcted">Please Select</option>
<option value="Mr">Mr</option>
<option value="Mrs">Mrs</option>
<option value="Miss">Miss</option>
<option value="Ms">Ms</option>
<option value="Other">Other</option>
</select></td>
</tr>
<tr>
  <td>First Name</td>
  <td><input type="text" name="firstname" /></td>
</tr>
<tr>
  <td>Last Name</td>
  <td><input type="text" name="lastname" /></td>
</tr>
<tr>
  <td>Address Line 1</td>
  <td><input type="text" name="address1" /></td>
</tr>
<tr>
  <td>Address Line 2</td>
  <td><input type="text" name="address2" /></td>
</tr>
<tr>
  <td>City</td>
  <td><input type="text" name="city" /></td>
</tr>
<tr>
  <td>Postcode</td>
  <td><input type="text" name="postcode" /></td>
</tr>
<tr>
  <td>Contact No</td>
  <td><input type="text" name="contactno" /></td>
</tr>
<tr>
  <td>Email</td>
  <td><input type="text" name="email" /></td>
</tr>
<tr>
  <td>Additional Info</td>
  <td><textarea rows="15" cols="30" name="note">Please Enter Any Additional Information</textarea></td>
</tr>
<tr>
  <td><input type="submit" value="Submit"></td>
  <td><a href='switch.php'>Back</a></td>
</tr>
  </table>
  </form>

<?php

break;
default:




echo "<table border='1'>
<tr>
<th>ID</th>
<th>Date Of Birth</th>
<th>Gender</th>
<th>Title</th>
<th>First Name</th>
<th>Last Name</th>
<th>Address Line 1</th>
<th>Address Line 2</th>
<th>City</th>
<th>Postcode</th>
<th>Contact No</th>
<th>Email</th>
<th>Additional Info</th>
<th>Action</th>
</tr>";

$result = mysql_query("SELECT * FROM project_data");
while($row = mysql_fetch_array($result)){
  echo "<tr>";
  echo "<td>" . $row['ID'] . "</td>";
  echo "<td>" . $row['Date_Of_Birth'] . "</td>";
  echo "<td>" . $row['Gender'] . "</td>";
  echo "<td>" . $row['Title'] . "</td>";
  echo "<td>" . $row['First_Name'] . "</td>";
  echo "<td>" . $row['Last_Name'] . "</td>";
  echo "<td>" . $row['Address_Line_1'] . "</td>";
  echo "<td>" . $row['Address_Line_2'] . "</td>";
  echo "<td>" . $row['City'] . "</td>";
  echo "<td>" . $row['Postcode'] . "</td>";
  echo "<td>" . $row['Contact_No'] . "</td>";
  echo "<td>" . $row['Email'] . "</td>";
  echo "<td>" . $row['Additional_Comment'] . "</td>";
  echo "<td><a href='switch.php?action=edit&id=" . $row['ID']."'>Edit</a>&nbsp&nbsp<a href='switch.php?action=delete&id=" . $row['ID']."'>Delete</a></td>";
  echo "</tr>";
  }
echo "</table>";

echo "<a href='switch.php?action=write'>Insert</a>";



}

mysql_close($con);
?>
Here is the completed code, but I still have a problem the page is coming up with an error:



( ! ) Fatal error: Cannot break/continue 1 level in C:\wamp\www\p1\switch.php on line 63
Call Stack
#   Time   Memory   Function   Location
1   0.0009   413960   {main}( )   ..\switch.php:0

I cannot seem to figure it out, Can anyone help?
Thanks

Here is my dilemma.

I'm trying to get the "class name" to return instead of the number that is associated with it.

I wrote a switch so that each of the 16 cases would be associated with what the class name is.

However, how do I make it output into my statement?

Here is what I have so far:


function getClassByNumber($x){
switch($x){
case 1: return "Alchemist";
case 2: return "Assassin";
case 3: return "Dark Arts";
case 4: return "Dark Paladin";
case 5: return "Entertainer";
case 6: return "Hunter";
case 7: return "Mage";
case 8: return "Monk";
case 9: return "Paladin";
case 10: return "Pirate";
case 11: return "Priest";
case 12: return "Psion";
case 13: return "Scholar";
case 14: return "Thief";
case 15: return "Warlock";
case 16: return "Warrior";
}
}

$class = getClassByNumber($username->class);

echo You are now a $class.


Username is defined as seeking the table I want. Class is the field where the number is stored.

Thanks!