Advertisement
Guest User

Untitled

a guest
Sep 17th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. $db_user = "root";
  2. $db_pass = "";
  3. $db_name = "music_reviews_database";
  4. $db_host = "localhost";
  5.  
  6. $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  7. if (!isset($q)) {
  8. $q = mysqli_query($conn,
  9. "SELECT album.Album,
  10. artist.ArtistsName,
  11. datereviewed.DateReviewed,
  12. features.Features,
  13. genre.Genre,
  14. rating.Rating,
  15. songname.SongName,
  16. link.link,
  17. songname.ID,
  18. comments.Comments
  19. FROM songname
  20. INNER JOIN album ON album.ID = songname.ID
  21. INNER JOIN artist ON artist.ID = songname.ID
  22. INNER JOIN datereviewed ON datereviewed.ID = songname.ID
  23. INNER JOIN features ON features.ID = songname.ID
  24. INNER JOIN genre ON genre.ID = songname.ID
  25. INNER JOIN rating ON rating.ID = songname.ID
  26. INNER JOIN link ON link.ID = songname.ID
  27. INNER JOIN comments ON comments.ID = songname.ID
  28. ORDER BY DateReviewed DESC LIMIT 1");
  29. $row = mysqli_fetch_array($q);
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement