unemployment Posted March 8, 2011 Share Posted March 8, 2011 How do I check to see if a value is in an array and then echo it? If index.php is found in the pages column. Check to see if it's value is in the $pages array. If the value matches, echo the value. function fetch_feedback_top_performers() { $sql = "SELECT `page`, SUM(`like`) FROM `feedback` GROUP BY `page` ORDER BY SUM(`like`) DESC LIMIT 10"; $rs = mysql_query($sql); while($row = mysql_fetch_assoc($rs)) { $results[] = $row; } return $results; } $pages = array( 'about' => 'About', 'index' => 'Homepage', ); Echo it here... <?php $results = fetch_feedback_top_performers(); foreach ($results as $result) { $page = $result['page']; $total = $result['SUM(`like`)']; $extremoved = substr($page, 0, -4); ?> <div class="mhl mvs"><span class="left"><?php echo ucwords($extremoved); ?></span><span class="f_right">(<?php echo $total; ?>)</span></div> <?php } ?> I just have no idea how to perform the check. I want to do this for security. Quote Link to comment Share on other sites More sharing options...
TOA Posted March 8, 2011 Share Posted March 8, 2011 http://php.net/manual/en/function.in-array.php Quote Link to comment Share on other sites More sharing options...
unemployment Posted March 8, 2011 Author Share Posted March 8, 2011 http://php.net/manual/en/function.in-array.php I took your advice but couldn't get it to work. <?php $results = fetch_feedback_top_performers(); foreach ($results as $result) { $page = $result['page']; $total = $result['SUM(`like`)']; $extremoved = substr($page, 0, -4); if (in_array("${extremoved}", $pages)) { ?> <div class="mhl mvs"> <span class="left"><?php echo ucwords($extremoved); ?></span> <span class="f_right">(<?php echo $total; ?>)</span> </div> <?php } } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.