skippa Posted September 29, 2009 Share Posted September 29, 2009 Heres My Script <? session_start(); if (!(isset($_SESSION["real_name"]))) { //echo "I'm not logged in"; header('Location: login.php'); } else { echo ""; } ?> <html> <head> <title>Midcity-Mafia :: Countries</title></head> <link REL="stylesheet" TYPE="text/css" HREF="main.css"> <script language=javascript src=Menus.js></script> <body background="wallpaper.jpg"> <center> <table border="0" cellspacing="0" cellpadding="0" align="center" width="95%" class="cat"> <TR> <TD width="150" background="tdbg3.jpg" bgcolor="#222222" valign="top"> <?php include("leftmenu.php");?> </TD> <td width="100%" valign="top"> <br> <table border="1" cellspacing="0" cellpadding="2" bordercolor="black" align="center" width="75%" class="sub2"> <tr> <td class="header" colspan="15" align="center">Countries</td> </tr> <tr> <td colspan="1" class="header" align="center">Country</td> <td colspan="1" class="header" align="center">Bullet Owner</td> <td colspan="1" class="header" align="center">Roulette</td> <td colspan="1" class="header" align="center">Slots</td> <td colspan="1" class="header" align="center">Racetrack</td> <td colspan="1" class="header" align="center">Dice</td> </tr> <? $sql="SELECT * from countries WHERE place='Italy'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <tr> <td colspan="1">Italy</td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['BF']; ?>'> <? echo $rows['BF']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['roulette']; ?>'><? echo $rows['roulette']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($slots == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['slots']; ?>'><? echo $rows['slots']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['racetrack']; ?>'><? echo $rows['racetrack']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['dice']; ?>'><? echo $rows['dice']; ?></a> <? } ?> </td> </tr> <? } ?> <? $sql="SELECT * from countries WHERE place='France'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <tr> <td colspan="1">France</td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['BF']; ?>'> <? echo $rows['BF']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['roulette']; ?>'><? echo $rows['roulette']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($slots == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['slots']; ?>'><? echo $rows['slots']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['racetrack']; ?>'><? echo $rows['racetrack']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['dice']; ?>'><? echo $rows['dice']; ?></a> <? } ?> </td> </tr> <? } ?> <? $sql="SELECT * from countries WHERE place='Nigeria'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <tr> <td colspan="1">Nigeria</td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['BF']; ?>'> <? echo $rows['BF']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['roulette']; ?>'><? echo $rows['roulette']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($slots == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['slots']; ?>'><? echo $rows['slots']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['racetrack']; ?>'><? echo $rows['racetrack']; ?></a> <? } ?> </td><td colspan="1"> <? if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['dice']; ?>'><? echo $rows['dice']; ?></a> <? } ?> </td> </tr> <? } ?> <? $sql="SELECT * from countries WHERE place='America'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <tr> <td colspan="1">America</td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['BF']; ?>'> <? echo $rows['BF']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['roulette']; ?>'><? echo $rows['roulette']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($slots == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['slots']; ?>'><? echo $rows['slots']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['racetrack']; ?>'><? echo $rows['racetrack']; ?></a> <? } ?> </td><td colspan="1"> <? if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['dice']; ?>'><? echo $rows['dice']; ?></a> <? } ?> </td> </tr> <? } ?> <? $sql="SELECT * from countries WHERE place='France'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <? } ?> <? $sql="SELECT * from countries WHERE place='England'"; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ // Start looping table row $BF = $rows['BF']; $roulette = $rows['roulette']; $slots = $rows['slots']; $racetrack = $rows['racetrack']; $dice = $rows['dice']; ?> <tr> <td colspan="1">England</td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['BF']; ?>'> <? echo $rows['BF']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['roulette']; ?>'><? echo $rows['roulette']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($blackjack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['bj']; ?>'><? echo $rows['bj']; ?></a> <? } ?> </td> <td colspan="1"> <? if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['racetrack']; ?>'><? echo $rows['racetrack']; ?></a> <? } ?> </td><td colspan="1"> <? if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<? echo $rows['dice']; ?>'><? echo $rows['dice']; ?></a> <? } ?> </td> </tr> <? } ?> <tr> <td colspan="7"> <font color="red">Users are only allowed to hold a maximum of 1 casino and bullet factory each.</font> </td></tr> </table> <br><br> </td> <TD width="150" valign="top"> <?php include("rightmenu.php");?> </TD> </TR> </table> </center> </body> </html> The Page should show the owners of casinos, but it doesnt, anyone help? Link to comment https://forums.phpfreaks.com/topic/175974-help-with-mafia-game/ Share on other sites More sharing options...
redarrow Posted September 29, 2009 Share Posted September 29, 2009 sorry but what wrong please??? Link to comment https://forums.phpfreaks.com/topic/175974-help-with-mafia-game/#findComment-927257 Share on other sites More sharing options...
Maq Posted September 29, 2009 Share Posted September 29, 2009 1) Use [/code] tags. 2) What have you done to diagnose the problem? 3) Post only the relevant code. 4) Don't use short hand PHP tags, use <?php tags. 5) I don't see anything that even resembles you trying to get the owners... (Assuming it's coming from the DB) Link to comment https://forums.phpfreaks.com/topic/175974-help-with-mafia-game/#findComment-927320 Share on other sites More sharing options...
Andy-H Posted September 29, 2009 Share Posted September 29, 2009 Why not do something along these lines? <?php session_start(); if (!(isset($_SESSION["real_name"]))) { //echo "I'm not logged in"; header('Location: login.php'); } else { echo ""; } ?> <html> <head> <title>Midcity-Mafia :: Countries</title></head> <link REL="stylesheet" TYPE="text/css" HREF="main.css"> <script language=javascript src=Menus.js></script> <body background="wallpaper.jpg"> <center> <table border="0" cellspacing="0" cellpadding="0" align="center" width="95%" class="cat"> <TR> <TD width="150" background="tdbg3.jpg" bgcolor="#222222" valign="top"> <?php include("leftmenu.php");?> </TD> <td width="100%" valign="top"> <br> <table border="1" cellspacing="0" cellpadding="2" bordercolor="black" align="center" width="75%" class="sub2"> <tr> <td class="header" colspan="15" align="center">Countries</td> </tr> <tr> <td colspan="1" class="header" align="center">Country</td> <td colspan="1" class="header" align="center">Bullet Owner</td> <td colspan="1" class="header" align="center">Roulette</td> <td colspan="1" class="header" align="center">Slots</td> <td colspan="1" class="header" align="center">Racetrack</td> <td colspan="1" class="header" align="center">Dice</td> </tr> <?php $sql="SELECT BF, roulette, slots, racetrack, dice, place from countries ORDER BY place"; $result=mysql_query($sql); while($rows=mysql_fetch_row($result)){ // Start looping table row $BF = $rows[0]; $roulette = $rows[1]; $slots = $rows[2]; $racetrack = $rows[3]; $dice = $rows[4]; $place = $rows[5]; ?> <tr> <td colspan="1"><?php echo $place; ?></td> <td colspan="1"> <? if ($BF == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<?php echo $BF; ?>'> <?php echo $BF; ?></a> <?php } ?> </td> <td colspan="1"> <?php if ($roulette == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<?php echo $roulette; ?>'><?php echo $roulette; ?></a> <?php } ?> </td> <td colspan="1"> <?php if ($slots == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<?php echo $slots; ?>'><?php echo $slots; ?></a> <?php } ?> </td> <td colspan="1"> <?php if ($racetrack == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<?php echo $racetrack; ?>'><?php echo $racetrack; ?></a> <?php } ?> </td> <td colspan="1"> <?php if ($dice == "None"){ echo "None"; }else{ ?> <a href='viewprofile.php?viewuser=<?php echo $dice; ?>'><?php echo $dice; ?></a> <?php } ?> </td> </tr> <?php } ?> <tr> <td colspan="7"> <font color="red">Users are only allowed to hold a maximum of 1 casino and bullet factory each.</font> </td></tr> </table> <br><br> </td> <TD width="150" valign="top"> <?php include("rightmenu.php");?> </TD> </TR> </table> </center> </body> </html> Link to comment https://forums.phpfreaks.com/topic/175974-help-with-mafia-game/#findComment-927336 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.