mcclellanfsu Posted March 8, 2007 Share Posted March 8, 2007 Hello, I am an extreme noob to the PHP language and am apparently rusty on all programming syntax. What I want is for the code to check the user and if the field userstat = 1 then display if not check to see if it =2 and so on until it gets through number four. Then if it's not equal to any of those put it in another area. Here is my code, can someone please help me figure this out...I'm sure it is a real simple syntax fix... <? if (!defined('e107_INIT')) { exit; } if (e_LANGUAGE != "English" && file_exists(e_PLUGIN . "aao_menu/languages/" . e_LANGUAGE . ".php")) { include_once(e_PLUGIN . "aao_menu/languages/" . e_LANGUAGE . ".php"); } else { include_once(e_PLUGIN . "aao_menu/language/English.php"); } $sql -> db_Select("AAO", "aao_name, aao_num, aao_stat", "ORDER BY aao_name ASC", "nowhere"); $userArray = $sql -> db_getList(); $CommandHQ =""; $AlphaSquad =""; $BravoSquad =""; $CharlieSquad =""; $recruit =""; $clan = $pref['clan_aao'] ; $trs = $pref['aao_style']; foreach($userArray as $user) { if ($user['aao_stat']=="1") { $CommandHQ .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; } else ($user['aao_stat']=="2"){ $AlphaSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; } else ($user['aao_stat']=="3"){ $BravoSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; } else ($user['aao_stat']=="4"){ $CharlieSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; } else{ $recruit .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; } } $text = "<table border='0'> <tr> <td><div align='center'><a target='_blank' href='http://aaotracker.com/clanprofile.php?clanid=".$clan."'><u>".AAO_L1."</u></a></div></td><TD></TD> </tr>"; $text .= $CommandHQ; $text .= "<tr> <td><BR><div align='center'><a target='_blank' href='http://aaotracker.com/clanprofile.php?clanid=".$clan."'><u>".AAO_L2."</u></a></div></td><TD></TD> </tr>"; $text .= $AlphaSquad; $text .= $BravoSquad; $text .= $CharlieSquad; $text .= $recruit; $text .= "</table>"; $title = "AmyOps Tracker"; $ns -> tablerender($title, $text); ?> Thank you in advance for any help! -Bob Link to comment https://forums.phpfreaks.com/topic/41800-solved-simple-if-statement/ Share on other sites More sharing options...
skali Posted March 8, 2007 Share Posted March 8, 2007 switch($user['aao_stat']){ case 1: //do what you want to do for condition 1 break; case 2: //do what you want to do for condition 2 break; case 3: //do what you want to do for condition 3 break; case 4: //do what you want to do for condition 4 break; default: //do what you want to do if no match found //put it in another area } Link to comment https://forums.phpfreaks.com/topic/41800-solved-simple-if-statement/#findComment-202718 Share on other sites More sharing options...
mcclellanfsu Posted March 8, 2007 Author Share Posted March 8, 2007 Thank you...that makes sense but for some reason it's still not working... Here is my code now: <? if (!defined('e107_INIT')) { exit; } if (e_LANGUAGE != "English" && file_exists(e_PLUGIN . "aao_menu/languages/" . e_LANGUAGE . ".php")) { include_once(e_PLUGIN . "aao_menu/languages/" . e_LANGUAGE . ".php"); } else { include_once(e_PLUGIN . "aao_menu/language/English.php"); } $sql -> db_Select("AAO", "aao_name, aao_num, aao_stat", "ORDER BY aao_name ASC", "nowhere"); $userArray = $sql -> db_getList(); $CommandHQ =""; $AlphaSquad =""; $BravoSquad =""; $CharlieSquad =""; $recruit =""; $clan = $pref['clan_aao'] ; $trs = $pref['aao_style']; /*New Code*/ switch($user['aao_stat']){ case 1: $CommandHQ .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; break; case 2: $AlphaSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; break; case 3: $BravoSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; break; case 4: $CharlieSquad .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; break; case 5: $recruit .= "<tr><td><div align='center'> <a target='_blank' href='http://aaotracker.4players.de/usertracker.php?userid=".$user['aao_num']."'>".$user['aao_name']."</a> </div></td><td><div align='center'> <img border='0' src='http://aaotracker.4players.de/trackericon.php?userid=".$user['aao_num']."&style=".$trs."'> </div></td></tr>"; break; } $text = "<table border='0'> <tr> <td><div align='center'><a target='_blank' href='http://aaotracker.com/clanprofile.php?clanid=".$clan."'><u>".AAO_L1."</u></a></div></td><TD></TD> </tr>"; $text .= $CommandHQ; $text .= "<tr> <td><BR><div align='center'><a target='_blank' href='http://aaotracker.com/clanprofile.php?clanid=".$clan."'><u>".AAO_L2."</u></a></div></td><TD></TD> </tr>"; $text .= $AlphaSquad; $text .= $BravoSquad; $text .= $CharlieSquad; $text .= $recruit; $text .= "</table>"; $title = "AmyOps Tracker"; $ns -> tablerender($title, $text); ?> It returns no results at all now. Thanks for the quick response! Any other ideas on what I am doing wrong? Link to comment https://forums.phpfreaks.com/topic/41800-solved-simple-if-statement/#findComment-202747 Share on other sites More sharing options...
skali Posted March 8, 2007 Share Posted March 8, 2007 Your code is misssin: foreach($userArray as $user) { before the switch statement Link to comment https://forums.phpfreaks.com/topic/41800-solved-simple-if-statement/#findComment-202754 Share on other sites More sharing options...
mcclellanfsu Posted March 8, 2007 Author Share Posted March 8, 2007 Thank you very much for the help! It works now! Link to comment https://forums.phpfreaks.com/topic/41800-solved-simple-if-statement/#findComment-202886 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.