Xtremer360 Posted February 16, 2009 Share Posted February 16, 2009 function arenas() { $country = $_GET['country']; $query = mysql_query("SELECT * FROM `arenas` WHERE `country` = '" . $country . "'"); $row = mysql_fetch_array($query); print '<h1 class="backstage">Arena Management</h1><br />'; print "<h2 class=\"backstage\">".$country." Arenas :: <a href=\"#\" onclick=\"addarena('addarena', 'content', '". $country ."'); return false;\">Add New Arena</a></h2><br />"; $query = "SELECT * FROM arenas WHERE `country` = '" . $country . "' ORDER BY `citystate`"; $result = mysql_query ( $query ); // Run The Query $rows = mysql_num_rows($result); if ($rows > 0) { print '<table width="100%" class="table1">'; print '<tr class="rowheading">'; print '<td> </td>'; print '<td>City</td>'; print '<td>Arena</td>'; print '<td align="center">Capacity</td>'; print '</tr>'; // Fetch and print all records. $i = 0; while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) { $sClass = 'row2'; if ($i ++ & 1) { $sClass = 'row1'; } printf ( "<tr class=\"%s\">", $sClass ); print "<td valign=\"top\" align=\"center\" width=\"30\"><a href=\"#\" onclick=\"editarena('editarena', 'content' , '". $row ['arena'] ."'); return false;\">Edit</a></td>"; printf ( "<td valign=\"top\">%s</td>", $row [citystate] ); printf ( "<td valign=\"top\">%s</td>", $row [arena] ); printf ( "<td valign=\"top\" align=\"center\">%s</td>", $row [capacity] ); print '</tr>'; } echo '</table><br />'; } else { print '<span>There are no arenas for this country.</span><br /><br />'; } print '<input type="button" value="Return to Country List" class="button200"><br /><br />'; print '<h2 class="backstage"><input type="button" value="Return to Main Menu" class="button200"></form></h2>'; } function editarena() { $arena = $_GET['arena']; $query = mysql_query("SELECT * FROM `arenas` WHERE `arena` = '" . $arena . "'"); $row = mysql_fetch_array($query); print '<h1 class="backstage">Arena Management</h1><br />'; print '<h2 class="backstage">Edit Arena</h2><br />'; print '<form name="editarena" method="post" action="backstage.php" id="editarena">'; print '<table width="100%" class="table2">'; print '<tr>'; print "<td width=\"120\" class=\"rowheading\" valign=\"center\">Arena:</td><td class=\"row3\"><input type=\"text\" name=\"arena\" class=\"fieldtext490\" value=\"".$row['arena']."\"></td>"; print '</tr>'; print '<tr>'; print "<td width=\"120\" class=\"rowheading\" valign=\"center\">City, State:</td><td class=\"row3\"><input type=\"text\" name=\"citystate\" class=\"fieldtext490\" value=\"".$row['citystate']."\"></td>"; print '</tr>'; print '<tr>'; print "<td width=\"120\" class=\"rowheading\" valign=\"center\">Capacity:</td><td class=\"row3\"><input type=\"text\" name=\"capacity\" class=\"fieldtext140\" value=\"".$row['capacity']."\"></td>"; print '</tr>'; print '</table><br />'; print '<input type="checkbox" name="deletearena"><span class="table1heading">Delete Arena?</span><br /><br />'; print '<input type="hidden" name="oldarena" value="'.$row['arena'].'"> '; print '<input type="submit" value="Edit Arena" class=button name="editarena></form><br /><br />'; print '<input type="button" value="Return to Arena List" class="button200"><br /><br />'; print '<h2 class=backstage><input type="button" value="Return to Main Menu" class="button200"></form></h2>'; } Link to comment https://forums.phpfreaks.com/topic/145354-not-showing-values-for-edit-form/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.