How does MySQL reindex a table?

Php mysql adding to a database table and printing table out?

• code i have for doing this so far is //are we adding a new track to the 'selected tracks' list if (isset($_GET["action"]) && $_GET["action"]=="addTrack") { $trackID=$_GET["trackID"]; // Part (2c) // before adding the new track, make sure that the selectedTracks // table does not already contain 10 tracks // Part (2b) // before adding the new track, make sure that it does not already exist // in the selectedTracks table // Part (2a) // first add code to insert $trackID into the selectedTracks table INSERT INTO selectedTracks VALUES(trackID); $dbQuery ="select id, trackID from selectedTracks"; $dbResult=mysql_query($dbQuery); echo mysql_num_rows($dbResult)."\n"; // now retrieve the artist name and song title for every entry in the // selectedTracks table. Return the tracks/artists in an // unordered list with a suitable heading e.g. // Tracks selected so far (3) // . track name - artist name // . track name - artist name // . track name - artist name } As you can see ive got part of 2a done, is it right? does anyone know how i print the table out in an unordered list? Also how do i prevent a track being added more then once and how to ensure the list has no more than 10 tracks? Thanks for any help in advance

• Answer:

  does anyone know how i print the table out in an unordered list? select (get) all of the records in the database (as an array) count how many in the array loop though the array printing the relevant details Also how do i prevent a track being added more then once you need to check if it's in the database already before you add it. (it's called validation). if select to see if a record with the same name AND track exists. and how to ensure the list has no more than 10 tracks? check befor adding how many are already on file matching the artist name