bankera1990
Registered
PHP:
elseif($_GET['video_order'] == "desc"){
$getdata = mysql_query("SELECT *, (SELECT Count(videos.id) FROM videos WHERE videos.us_id=users.id) AS videos_count FROM users GROUP BY users.id ORDER BY videos_count DESC, users.id DESC LIMIT $cur, $max");
} elseif($_GET['video_order'] == "asc"){
$getdata = mysql_query("SELECT *, (SELECT Count(videos.id) FROM videos WHERE videos.us_id=users.id) AS videos_count FROM users GROUP BY users.id ORDER BY videos_count ASC, users.id DESC LIMIT $cur, $max");
}
Проблема е че не ми сортира по desc и asc
линка е
PHP:
index.php?p=members&favorites_order=<?php if($_GET['favorites_order'] != "desc"){ echo "desc"; } else { echo "asc"; } ?>