Jump to content

Blank pages must die.......

cry of war

By cry of war
in PHP Coding Help

 Share

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
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
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.