Jump to content

Blank pages must die.......

cry of war

By cry of war
in PHP Coding Help

Recommended Posts

cry of war Member

cry of war

Posted
Posted

The code below i started working on today after i finished typing it out i tested it and found that i got a blank screen after i pressed Load Alchemy..... All tables and stuff are already set up so that shouldnt be causing an error im just dumbfounded why i keep getting blank pages in everything i do....

The way it works is suppost to work is

Load page---Click Load Alchemy---Displays queryed information----Click Finish----Update Infromation

The way it does work is

Load page---Click Load Alchemy---Displays blank page---------------------------------------------

 

Heres the code if anyone could help me it would be great...... oh and sorry for the code being so long.

 

<head>
<title>Add Alchemy</title>
</head>
<?php
ini_set('display_errors', '1');
error_reportIng(E_ALL);
include "databaseconnect.php";
$table = "Ingredient";
$table2 = "Effects";
/*link to other tables makes it work better instead of EffECTS**/
$result = mysql_query("SELECT * FROM $table");
if (!is_resource($result)){
	 		echo "\nThis page cannot be displayed because there are no Alchemy Ingredients to Edit.";
die;
}
if (!isset($_POST["Load"])){
	 		echo "\nSelect alchemy item you wish to edit:";
	 		echo "\n<FORM action=".$_SERVER['PHP_SELF']." method='post'>";
	 		echo "\n<SELECT name='EditAlchemy'>";
	 		echo "\n<option label='' value=''>None</OPTION>";
	 		echo "\n<optgroup label='Ingredents'>";
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='A'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'A%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='B'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'B%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='C'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'C%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='D'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'D%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='E'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'E%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='F'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'F%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='G'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'G%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='H'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'H%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='I'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'I%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='J'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'J%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='K'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'K%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='L'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'L%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='M'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'M%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='N'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'N%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='O'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'O%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='P'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'P%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='Q'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'Q%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='R'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'R%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='S'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'S%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='T'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'T%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='U'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'U%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='V'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'V%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='W'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'W%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='X'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'X%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='Y'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'Y%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n<optgroup label='Z'>";
$result = mysql_query("SELECT * FROM `Ingredient` WHERE `Ingredientname` LIKE 'Z%' ORDER BY `Ingredientname`");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   printf("\n<option value='$row[ingredientname]'>$row[ingredientname]</OPTION>");
}
	 		echo "\n</OPTGROUP>";
	 		echo "\n</SELECT>";
	echo "\n<input type='SUBMIT' value='Load Alchemy Item' Name='Load'>";
}

if (isset($_POST["Load"])) {
$EditAlchemy=$_POST["EditAlchemy"];
$result = mysql_query("SELECT * FROM $table WHERE Ingredientname='$EditAlchemy'");
$result2 = mysql_query("SELECT * FROM $table2");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$Ingredientname = "$row[ingredientname]";
$Ingredientdis = "$row[ingredientdis]";
$Ingredientweight = "$row[ingredientweight]";
$Ingredientlevel1 = "$row[ingredientlevel1]";
$Effect1 = "$row[Effect1]";
$Alignment1 = "$row[Alignment1]";
$Ingredientstrenth1 = "$row[ingredientstrenth1]";
$Ingredientduration1 = "$row[ingredientduration1]";
$Ingredientlevel2 = "$row[ingredientlevel2]";
$Effect2 = "$row[Effect2]";
$Alignment2 = "$row[Alignment2]";
$Ingredientstrenth2 = "$row[ingredientstrenth2]";
$Ingredientduration2 = "$row[ingredientduration2]";
$Ingredientlevel3 = "$row[ingredientlevel3]";
$Effect3 = "$row[Effect3]";
$Alignment3 = "$row[Alignment3]";
$Ingredientstrenth3 = "$row[ingredientstrenth3]";
$Ingredientduration3 = "$row[ingredientduration3]";
$Ingredientlevel4 = "$row[ingredientlevel4]";
$Effect4 = "$row[Effect4]";
$Alignment4 = "$row[Alignment4]";
$Ingredientstrenth4 = "$row[ingredientstrenth4]";
$Ingredientduration4 = "$row[ingredientduration4]";
$Ingredientlevel5 = "$row[ingredientlevel5]";
$Effect5 = "$row[Effect5]";
$Alignment5 = "$row[Alignment5]";
$Ingredientstrenth5 = "$row[ingredientstrenth5]";
$Ingredientduration5 = "$row[ingredientduration5]";
$Ingredientlevel6 = "$row[ingredientlevel6]";
$Effect6 = "$row[Effect6]";
$Alignment6 = "$row[Alignment6]";
$Ingredientstrenth6 = "$row[ingredientstrenth6]";
$Ingredientduration6 = "$row[ingredientduration6]";
$Ingredientlevel7 = "$row[ingredientlevel7]";
$Effect7 = "$row[Effect7]";
$Alignment7 = "$row[Alignment7]";
$Ingredientstrenth7 = "$row[ingredientstrenth7]";
$Ingredientduration7 = "$row[ingredientduration7]";
$Ingredientlevel8 = "$row[ingredientlevel8]";
$Effect8 = "$row[Effect8]";
$Alignment8 = "$row[Alignment8]";
$Ingredientstrenth8 = "$row[ingredientstrenth8]";
$Ingredientduration8 = "$row[ingredientduration8]";
$Ingredientlevel9 = "$row[ingredientlevel9]";
$Effect9 = "$row[Effect9]";
$Alignment9 = "$row[Alignment9]";
$Ingredientstrenth9 = "$row[ingredientstrenth9]";
$Ingredientduration9 = "$row[ingredientduration9]";
$Ingredientlevel10 = "$row[ingredientlevel10]";
$Effect10 = "$row[Effect10]";
$Alignment10 = "$row[Alignment10]";
$Ingredientstrenth10 = "$row[ingredientstrenth10]";
$Ingredientduration10 = "$row[ingredientduration10]";
}
while ($row1 = mysql_fetch_array($result2, MYSQL_BOTH)) {
	echo "<tr><td>Alchemy Ingredient name:</td><td><input type='text' name='Ingredientname' value='".$Ingredientname."' maxlength='30'></td></tr><br />";
	echo "<tr><td>Ingredient description:</td><td><textarea name='Ingredientdis' maxlength='256'>".$Ingredientdis."</textarea></td></tr><br />";
	echo "<tr><td>Weight of Ingredient:</td><td><input type='text' name='Ingredientweight' value='".$Ingredientweight."' maxlength='6'></td></tr><br />";
	echo "</table>";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel1' value='".$Ingredientlevel1."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect1'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect1){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment1'>\n";
if ($Alignment1=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth1' value='".$Ingredientstrenth1."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration1' value='".$Ingredientduration1."' maxlength='3' size='2'>(seconds)</td></tr>\n";

	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel2' value='".$Ingredientlevel2."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect2'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect2){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment2'>\n";
if ($Alignment2=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth2' value='".$Ingredientstrenth2."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration2' value='".$Ingredientduration2."' maxlength='3' size='2'>(seconds)</td></tr>\n";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel3' value='".$Ingredientlevel3."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect3'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect3){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment3'>\n";
if ($Alignment3=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth3' value='".$Ingredientstrenth3."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration3' value='".$Ingredientduration3."' maxlength='3' size='2'>(seconds)</td></tr>\n";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel4' value='".$Ingredientlevel4."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect4'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect4){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment4'>\n";
if ($Alignment4=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth4' value='".$Ingredientstrenth4."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration4' value='".$Ingredientduration4."' maxlength='3' size='2'>(seconds)</td></tr>\n";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel5' value='".$Ingredientlevel5."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect5'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect5){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment5'>\n";
if ($Alignment5=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth5' value='".$Ingredientstrenth5."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration5' value='".$Ingredientduration5."' maxlength='3' size='2'>(seconds)</td></tr>\n";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel6' value='".$Ingredientlevel6."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect6'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect6){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment6'>\n";
if ($Alignment6=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth6' value='".$Ingredientstrenth6."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration6' value='".$Ingredientduration6."' maxlength='3' size='2'>(seconds)</td></tr>\n";
	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel7' value='".$Ingredientlevel7."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect7'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect7){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment7'>\n";
if ($Alignment.$i=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth7' value='".$Ingredientstrenth7."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration7' value='".$Ingredientduration7."' maxlength='3' size='2'>(seconds)</td></tr>\n";

	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel7' value='".$Ingredientlevel7."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect7'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect7){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment8'>\n";
if ($Alignment8=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth8' value='".$Ingredientstrenth8."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration8' value='".$Ingredientduration8."' maxlength='3' size='2'>(seconds)</td></tr>\n";

	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel9' value='".$Ingredientlevel9."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect9'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect9){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment9'>\n";
if ($Alignment9=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth9' value='".$Ingredientstrenth9."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration9' value='".$Ingredientduration9."' maxlength='3' size='2'>(seconds)</td></tr>\n";

	echo "<table>";
	echo "<tr><td>Level required<br>to identify Effect:</td><td><input type='text' name='Ingredientlevel10' value='".$Ingredientlevel10."' maxlength='3' size='2'></td>\n";
	echo "<td>Effect:\n";
	echo "<td><select name='Effect10'>\n";
	echo "<option value" .$row1[Name]. "";
if ($row1[Name]==$Effect10){
	echo "selected";
}
	echo ">" .$row1[Name]. "<option>\n";
	echo "</select></td>";
	echo "<td>Effect Strength:\n";
	echo "<select name='Alignment10'>\n";
if ($Alignment10=="1"){
$yes="selected";
$no="";
}else{
$no="selected";
$yes="";
}
	echo "<option value='1' ".$yes.">+</option>\n";
	echo "<option value='2' ".$no.">-</option>\n";
	echo "</select></td>\n";
	echo "<td><input type='text' name='Ingredientstrenth10' value='".$Ingredientstrenth10."' maxlength='3' size='2'></td>\n";
	echo "<td>Duration:</td><td><input type='text' name='Ingredientduration10' value='".$Ingredientduration10."' maxlength='3' size='2'>(seconds)</td></tr>\n";
}
}

if (isset($_POST["Finish"])) {
$Ingredientname=$_POST["Ingredientname"];
$Ingredientdis=$_POST["Ingredientdis"];
$Ingredientweight=$_POST["Ingredientweight"];
$Ingredientlevel1=$_POST["Ingredientlevel1"];
$Effect1=$_POST["Effect1"];
$Alignment1=$_POST["Alignment1"];
$Ingredientstrenth1=$_POST["Ingredientstrenth1"];
$Ingredientduration1=$_POST["Ingredientduration1"];
$Ingredientlevel2=$_POST["Ingredientlevel2"];
$Effect2=$_POST["Effect2"];
$Alignment2=$_POST["Alignment2"];
$Ingredientstrenth2=$_POST["Ingredientstrenth2"];
$Ingredientduration2=$_POST["Ingredientduration2"];
$Ingredientlevel3=$_POST["Ingredientlevel3"];
$Effect3=$_POST["Effect3"];
$Alignment3=$_POST["Alignment3"];
$Ingredientstrenth3=$_POST["Ingredientstrenth3"];
$Ingredientduration3=$_POST["Ingredientduration3"];
$Ingredientlevel4=$_POST["Ingredientlevel4"];
$Effect4=$_POST["Effect4"];
$Alignment4=$_POST["Alignment4"];
$Ingredientstrenth4=$_POST["Ingredientstrenth4"];
$Ingredientduration4=$_POST["Ingredientduration4"];
$Ingredientlevel5=$_POST["Ingredientlevel5"];
$Effect5=$_POST["Effect5"];
$Alignment5=$_POST["Alignment5"];
$Ingredientstrenth5=$_POST["Ingredientstrenth5"];
$Ingredientduration5=$_POST["Ingredientduration5"];
$Ingredientlevel6=$_POST["Ingredientlevel6"];
$Effect6=$_POST["Effect6"];
$Alignment6=$_POST["Alignment6"];
$Ingredientstrenth6=$_POST["Ingredientstrenth6"];
$Ingredientduration6=$_POST["Ingredientduration6"];
$Ingredientlevel7=$_POST["Ingredientlevel7"];
$Effect7=$_POST["Effect7"];
$Alignment7=$_POST["Alignment7"];
$Ingredientstrenth7=$_POST["Ingredientstrenth7"];
$Ingredientduration7=$_POST["Ingredientduration7"];
$Ingredientlevel8=$_POST["Ingredientlevel8"];
$Effect8=$_POST["Effect8"];
$Alignment8=$_POST["Alignment8"];
$Ingredientstrenth8=$_POST["Ingredientstrenth8"];
$Ingredientduration8=$_POST["Ingredientduration8"];
$Ingredientlevel9=$_POST["Ingredientlevel9"];
$Effect9=$_POST["Effect9"];
$Alignment9=$_POST["Alignment9"];
$Ingredientstrenth9=$_POST["Ingredientstrenth9"];
$Ingredientduration9=$_POST["Ingredientduration9"];
$Ingredientlevel10=$_POST["Ingredientlevel10"];
$Effect10=$_POST["Effect10"];
$Alignment10=$_POST["Alignment10"];
$Ingredientstrenth10=$_POST["Ingredientstrenth10"];
$Ingredientduration10=$_POST["Ingredientduration10"];
$input= array($Ingredientname,$Ingredientdis,$Ingredientweight,$Ingredientlevel1,$Effect1,$Alignment1,$Ingredientstrenth1,$Ingredientduration1,$Ingredientlevel2,$Effect2,$Alignment2,$Ingredientstrenth2,$Ingredientduration2,$Ingredientlevel3,$Effect3,$Alignment3,$Ingredientstrenth3,$Ingredientduration3,$Ingredientlevel4,$Effect4,$Alignment4,$Ingredientstrenth4,$Ingredientduration4,$Ingredientlevel5,$Effect5,$Alignment5,$Ingredientstrenth5,$Ingredientduration5,$Ingredientlevel6,$Effect6,$Alignment6,$Ingredientstrenth6,$Ingredientduration6,$Ingredientlevel7,$Effect7,$Alignment7,$Ingredientstrenth7,$Ingredientduration7,$Ingredientlevel8,$Effect8,$Alignment8,$Ingredientstrenth8,$Ingredientduration8,$Ingredientlevel9,$Effect9,$Alignment9,$Ingredientstrenth9,$Ingredientduration9,$Ingredientlevel10,$Effect10,$Alignment10,$Ingredientstrenth10,$Ingredientduration10);
$input2= array(Ingredientname,Ingredientdis,Ingredientweight,Ingredientlevel1,Effect1,Alignment1,Ingredientstrenth1,Ingredientduration1,Ingredientlevel2,Effect2,Alignment2,Ingredientstrenth2,Ingredientduration2,Ingredientlevel3,Effect3,Alignment3,Ingredientstrenth3,Ingredientduration3,Ingredientlevel4,Effect4,Alignment4,Ingredientstrenth4,Ingredientduration4,Ingredientlevel5,Effect5,Alignment5,Ingredientduration5,Ingredientlevel6,Effect6,Alignment6,Ingredientstrenth6,Ingredientduration6,Ingredientlevel7,Effect7,Alignment7,Ingredientstrenth7,Ingredientduration7,Ingredientlevel8,Effect8,Alignment8,Ingredientstrenth8,Ingredientduration8,Ingredientlevel9,Effect9,Alignment9,Ingredientstrenth9,Ingredientduration9,Ingredientlevel10,Effect10,Alignment10,Ingredientstrenth10,Ingredientduration10);
mysql_query("UPDATE * SET $input2 = '$input1' WHERE Ingredientname = '$EditAlchemy'");
	echo "You have just updated the Table";
	echo "If you would like to edit another Alchemy Ingredient please select";
}
?>

Link to comment
https://forums.phpfreaks.com/topic/76564-blank-pages-must-die/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.