$music = get_music($id); echo "<form action=\"music_update.php?id=" . $id . "\" method=\"post\" class=\"form-internal inline input-seperation\" id=\"admin\">"; require "partials/_music_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 { $date = $_POST['date']; $artist = $_POST['artist']; $song = $_POST['song']; $url = $_POST['url']; if (!$date || !$artist || !$song) { echo '<div class="top-spacer_20 center error">Error - missing required value(s)</div>'; } else { $result = update_music($id, $date, $artist, $song, $url); if ($result) { echo '<div class="top-spacer_20 center"><h1>Update was successful!</h1>'; display_music(get_music($id)); echo "</div>"; } } } ?> <div class="top-spacer_20"> <a href="music_view_all.php">View all New Music</a> <p> <a href="cp.php">Control Panel</a> </div> </div> </div> <!-- end of row div --> <?php } require "partials/_footer.php";
function view_all_music() { $query = "SELECT * FROM music WHERE deleted = 'n' AND date > DATE_SUB(now(), INTERVAL 6 MONTH) ORDER BY date DESC, artist"; $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_music($info); echo '<br>[ <a href="music_update.php?id=' . $info[id] . '">Edit</a> | <a href="music_delete.php?id=' . $info[id] . '">Delete</a> ] <p>'; } echo '</ol>'; }