require "partials/_mrm_band_form.php"; echo "</form>\n <div class=\"footnote\">** if any links are over 128 characters: use <a href=\"http://www.bit.ly\" target=_new>bit.ly</a> to shorten the url</div>"; } else { $name = $_POST['name']; $url = $_POST['url']; $pic_url = $_POST['pic_url']; $placement = $_POST['placement']; $seed = $_POST['seed']; $abbr = $_POST['abbr']; if (!$name || !$url || !$pic_url || !$placement || !$seed || !$abbr) { echo '<div class="top-spacer_20 center error">Error - missing required value(s)</div>'; } else { $result = update_mrm_band($id, $name, $url, $pic_url, $placement, $seed, $abbr); if ($result) { echo '<div class="top-spacer_20 center"><h1>Update was successful!</h1>'; display_mrm_band(get_mrm_band($id)); echo "</div>"; } } } ?> <div class="top-spacer_20"> <a href="mrm_view_all.php">View all Modern Rock Madness Bands</a> <p> <a href="cp.php">Control Panel</a> </div> </div> </div> <!-- end of row div --> <?php } require "partials/_footer.php";
function view_all_mrm_bands() { $query = "SELECT * FROM mrm_bands ORDER BY Placement"; $result = mysql_query($query); if (!$result) { echo "error: " . $query; die('Invalid'); } echo '<ol>'; for ($i = 1; $i <= mysql_num_rows($result); $i++) { $info = mysql_fetch_assoc($result); display_mrm_band($info); echo '<br>[ <a href="mrm_band_update.php?id=' . $info["id"] . '">Edit</a> | <a href="mrm_band_delete.php?id=' . $info["id"] . '">Delete</a> ] <p>'; } echo '</ol>'; }