Guest User

Untitled

a guest
Jun 24th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. function daysVideo()
  2. {
  3. $mysqli = lib_mysql_connect();
  4. $list = array();
  5. $result = $mysqli->query("
  6. SELECT
  7. fr.video_id,
  8. fr.name,
  9. fr.sef_name,
  10. fr.duration,
  11. fr.record_date,
  12. fr.images,
  13. vv.view_count
  14. FROM
  15. frontpage fr, video_value vv
  16. WHERE
  17. fr.video_id=vv.video_id
  18. AND
  19. fr.location='1' ORDER BY fr.rank ASC LIMIT 12
  20. ");
  21. if($result->num_rows > 0)
  22. {
  23. while($row = $result->fetch_array(MYSQLI_ASSOC))
  24. array_push($list, array(
  25. 'video_id' => $row["video_id"],
  26. 'name' => $row["name"],
  27. 'sef_name' => $row["sef_name"],
  28. 'duration' => $row["duration"],
  29. 'record_date' => $row["record_date"],
  30. 'images' => $row["images"],
  31. 'view_count' => $row["view_count"]
  32. ));
  33. }
  34. lib_mysql_close($mysqli);
  35. return $list;
  36. }
Add Comment
Please, Sign In to add comment