unidox Posted April 20, 2008 Share Posted April 20, 2008 This was my original code: if (($_POST['sort'] == "1") && ($lvl <= 2)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '2' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '2' AND conf = '1' LIMIT $start, $limit"); } elseif (($_POST['sort'] == "2") && ($lvl <= 3)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '3' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '3' AND conf = '1' LIMIT $start, $limit"); } elseif (($_POST['sort'] == "3") && ($lvl <= 4)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '4' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '4' AND conf = '1' LIMIT $start, $limit"); } elseif (($_POST['sort'] == "4") && ($lvl <= 5)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '5' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '5' AND conf = '1' LIMIT $start, $limit"); } elseif (($_POST['sort'] == "5") && ($lvl <= 6)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '6' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '6' AND conf = '1' LIMIT $start, $limit"); } elseif ($_POST['sort'] == "6") { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE conf = '2'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE conf = '2'"); } else { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1' ORDER BY `$order` ASC LIMIT $start, $limit"); } and I am trying to turn it into a while like this: if (!$_POST['sort']) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1' ORDER BY `$order` ASC LIMIT $start, $limit"); } else { if (!is_numeric($_POST['sort'])) { exit(); } $q = mysql_query("SELECT * FROM `pcp_groups`"); $sort = 0; while ($r = mysql_fetch_array($q)) { $sort++; $level = $r['level']; if (($_POST['sort'] == $sort) && ($lvl <= $level)) { $q2 = mysql_query("SELECT * FROM `pcp_users` WHERE level = '$level' AND conf = '1'"); $q = mysql_query("SELECT * FROM `pcp_users` WHERE level = '$level' AND conf = '1' LIMIT $start, $limit"); } } } but how do I change if (($_POST['sort'] == $sort) && ($lvl <= $level)) { to elseif? Link to comment https://forums.phpfreaks.com/topic/102018-while/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.