Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function daysVideo()
- {
- $mysqli = lib_mysql_connect();
- $list = array();
- $result = $mysqli->query("
- SELECT
- fr.video_id,
- fr.name,
- fr.sef_name,
- fr.duration,
- fr.record_date,
- fr.images,
- vv.view_count
- FROM
- frontpage fr, video_value vv
- WHERE
- fr.video_id=vv.video_id
- AND
- fr.location='1' ORDER BY fr.rank ASC LIMIT 12
- ");
- if($result->num_rows > 0)
- {
- while($row = $result->fetch_array(MYSQLI_ASSOC))
- array_push($list, array(
- 'video_id' => $row["video_id"],
- 'name' => $row["name"],
- 'sef_name' => $row["sef_name"],
- 'duration' => $row["duration"],
- 'record_date' => $row["record_date"],
- 'images' => $row["images"],
- 'view_count' => $row["view_count"]
- ));
- }
- lib_mysql_close($mysqli);
- return $list;
- }
Add Comment
Please, Sign In to add comment