Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $db_user = "root";
- $db_pass = "";
- $db_name = "music_reviews_database";
- $db_host = "localhost";
- $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
- if (!isset($q)) {
- $q = mysqli_query($conn,
- "SELECT album.Album,
- artist.ArtistsName,
- datereviewed.DateReviewed,
- features.Features,
- genre.Genre,
- rating.Rating,
- songname.SongName,
- link.link,
- songname.ID,
- comments.Comments
- FROM songname
- INNER JOIN album ON album.ID = songname.ID
- INNER JOIN artist ON artist.ID = songname.ID
- INNER JOIN datereviewed ON datereviewed.ID = songname.ID
- INNER JOIN features ON features.ID = songname.ID
- INNER JOIN genre ON genre.ID = songname.ID
- INNER JOIN rating ON rating.ID = songname.ID
- INNER JOIN link ON link.ID = songname.ID
- INNER JOIN comments ON comments.ID = songname.ID
- ORDER BY DateReviewed DESC LIMIT 1");
- $row = mysqli_fetch_array($q);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement