[SOLVED] mysql and tables.

KingChaos · July 31, 2007

Hi there. First topic here. Proberbly not the last one.

I got a php file that imports it's info fram a database. And from that info it creates a table. This is for a game. And if it's more than one game running it creates another table below the first one. Like this:

What I need is to make the tables like this:

Here is the php-file:

<?

include("html.php");

$html = mysql_fetch_array(mysql_query("SELECT description FROM $tab;"));

siteheader();

?>

<tr>

Open Rounds:

<?

$getgames = mysql_query("SELECT round,ends,starts,name,status FROM $tab[game] WHERE ends>$time ORDER BY round ASC;");

while ($game = mysql_fetch_array($getgames))

{

?>

Round <?=$game[0]?> - <?=$game[3]?>

<td align=center>Worth</td>

<td>

</tr>

<?

$pmpstatus = mysql_fetch_array(mysql_query("SELECT code FROM $tab[user] WHERE status='banned';"));

$getpimps = mysql_query("SELECT id,pimp,networth,nrank,crew FROM "."r".$game[0]."_".$tab[pimp]." WHERE rank>0 AND code!='$pmpstatus[0]' ORDER BY CAST(networth AS UNSIGNED) DESC LIMIT 10;");

while ($pimp = mysql_fetch_array($getpimps))

{

$crw = mysql_fetch_array(mysql_query("SELECT icon FROM "."r".$game[0]."_".$tab[crew]." WHERE id='$pimp[4]';"));

if($rankstart==0){$rankcolor="#003366";$rankstart++;}

elseif($rankstart==1){$rankcolor="#16283B";$rankstart--;}

?>

<td height="16"><?if($crw[0]){?><img src="<?=$crw[0]?>" width="14" height="14" align="absmiddle"><?}?><a href="pimp.php?pid=<?=$pimp[1]?>&rnd=<?=$game[0]?>"><?=$pimp[1]?></a></td>

</tr>

<?}?>

</table>

</center>

<?if ($game[2] > $time){?>Starts in <?countdown($game[2]);}else{?><?if($game[4] == pause){?>[Round Paused]<?} else {?>Ends in <?countdown($game[1]);}?><? } ?>

<?}?>

</div>

</td>

</tr>

</table>

<?

sitefooter();

?>

Hope someone got a solution for me.

King

mpharo · July 31, 2007

One way to do this is through embedded tables...

<table>
<tr>
<td>
<table>
<tr>
<td>
Table 1
</td>
</tr>
</table>
</td>
<td>
<table>
<tr>
<td>
Table 2
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table>
<tr>
<td>
Table 3
</td>
</tr>
</table>
</td>
<td>
<table>
<tr>
<td>
Table 4
</td>
</tr>
</table>
</td>
</tr>
</table>

KingChaos · July 31, 2007

Thx 4 the reply, but that wont work.

Becouse then I'll have to edit it all the time. This is for a game site, and some games runs for 30 day and others runs just for 3 days. And I only wanna show the active games.

So now the script fetches those games automaticly, and generates a new table for that game.

But for all I know it might be another file that tells the site how to split the tables. But since I don't know much about programming, I have no idea!

But there's only one other file that is running together with this one, and I can't find something there eighter. (not that I know what to look for. lol)

But here is the other file.:

<?

include("funcs.php");

include("banners.php");

$id=cln($id);

$referuser = mysql_fetch_array(mysql_query("SELECT username FROM $tab[user] WHERE id='$id';"));

$refuser = $referuser[0];

function secureheader(){

global $id, $tab, $time, $sitename;

$user = mysql_fetch_array(mysql_query("SELECT online,status,code FROM $tab[user] WHERE id='$id';"));

$idle=$time-$user[0];

if (!$user){ setcookie("trupimp",NODATA); header("Location: login.php?reason=notlogged"); }

elseif ($idle > 3600){ setcookie("trupimp",NODATA); header("Location: login.php?reason=idle"); }

elseif ($user[1] == banned){ setcookie("trupimp",NODATA); header("Location: login.php?reason=banned&code=$user[2]"); }

$time = cln($time);

mysql_query("UPDATE $tab[user] SET online='$time' WHERE id='$id';");

}

function siteheader(){

global $site, $tab, $menu, $time, $id, $id1, $sitename, $showads, $userstatus, $userads, $showblock, $adverts;

$block = mysql_fetch_array(mysql_query("SELECT showblock FROM settings;"));

$showblock = $block[0];

$user = mysql_fetch_array(mysql_query("SELECT status,ads FROM users WHERE id='$id';"));

$userads = $user[1];

$userstatus = $user[0];

if ($userstatus == admin || $userstatus == supporter){$userstatus = supporter;}

if ($userads == yes || $userstatus != supporter){$showads = "1";}

//SHOWING PIMPS ONLINE

$idletime=$time-360;

$reg = mysql_fetch_row(mysql_query("SELECT count(username) FROM $tab[user];"));

//pinoywebdev add s

$idletime=cln($idletime);

$time = cln($time);

//pinoywebdev add e

$online=fetch("SELECT COUNT(id) FROM $tab[user] WHERE online>$idletime;");

$getgames = mysql_query("SELECT round FROM $tab[game] WHERE starts<$time AND ends>$time ORDER BY round ASC;");

while ($game = mysql_fetch_array($getgames)){

$onlinepimps=fetch("SELECT COUNT(id) FROM r$game[0]_$tab[pimp] WHERE online>$idletime;");

$pimpin=$pimpin+$onlinepimps;

}

$getgames = mysql_query("SELECT round FROM $tab[game] WHERE starts<$time AND ends>$time ORDER BY round ASC;");

while ($game = mysql_fetch_array($getgames)){

$pimpshitting=fetch("SELECT COUNT(id) FROM r$game[0]_$tab[pimp] WHERE lastattack>$idletime;");

$attackin=$attackin+$pimpshitting;

}

?>

<html>

<head>

<title><?=$sitename?> - Free Web Based Pimps Game</title>

</head>

<tr>

</tr>

<tr>

</tr>

<tr>

<?if(!$id){?>

<a href="index.php">Home</a> |

<a href="login.php">Login</a> |

<a href="signup.php">Signup</a> |

<a href="guide.php">Guide</a> |

<a href="rules.php">Rules</a> |

<a href="winners.php">Winners</a>

<?}else{?>

<a href="index.php">Home</a> |

<a href="play.php">Play</a> |

<a href="myaccount.php">My Account</a> |

<a href="credits.php">Purchase Credits</a> |

<a href="winners.php">Winners</a> |

<a href="logout.php">Logout</a>

<?}?>

</td>

</tr>

<tr>

</tr>

<tr>

</td>

<?if(!$id){?>

<tr>

Login</td>

</tr>

</table>

<tr>

Username:

</tr>

<tr>

Password:

</td>

</tr>

<tr>

</tr>

</table>

Not a pimp? <a href="signup.php">Become One!</a>, its free!

Lost your password? <a href="lostpass.php">click here</a>.

</form>

<?}?>

<tr>

News</td>

</tr>

</table>

<?

$limitnews = mysql_fetch_array(mysql_query("SELECT numbernews FROM settings;"));

$getnews = mysql_query("SELECT id,news,posted FROM $tab[news] WHERE id>0 ORDER BY posted DESC limit $limitnews[0];");

while ($news = mysql_fetch_array($getnews)){?>

<tr>

</tr>

<tr>

</tr>

</table>

<? }

$result = mysql_query("Select * From settings");

$row = mysql_fetch_array($result, MYSQL_BOTH);

$block = $row['block'];

$showblock = $row['showblock'];

$blocktitle = $row['blocktitle'];

?>

<? if($showblock == yes) { ?>

<tr>

<?= $blocktitle ?></td>

</tr>

<tr>

</tr>

</table>

<? } ?>

Statistics

Registered: <?=commas($reg[0])?>

Online:<?=commas($online)?>

Pimping: <?=commas($pimpin)?>

Attacking: <?=commas($attackin)?>

</center>

</td>

<?if ($showads == 1 && $adverts != ""){echo ?><center><?= $adverts;?></center> <?}?>

<?

}

function sitefooter(){

global $site, $tab, $id, $domain, $adminemail, $showads, $showblock, $bottomadverts;

$user = mysql_fetch_array(mysql_query("SELECT status FROM $tab[user] WHERE id='$id';"));

?>

<?if ($showads == 1 && $bottomadverts != ""){echo ?><center><?= $bottomadverts;?></center> <?}?>

</td>

</tr>

<tr>

</td>

</tr>

</table>

Script from:

</body>

</html>

<?

}

?>

King

AndyB · July 31, 2007

Hi there. First topic here. Proberbly not the last one.

For future reference, PLEASE wrap your code here in [ CODE ] statements.

mpharo · July 31, 2007

the way to do it is check for a active game then print the resulting tables.


<table>
<tr>
<td>

<?php
If ($activegames>=1){

echo "<table>"
. "<tr>"
. "<td>"
. "Table 1"
. "</td>"
. "</tr>"
. "</table>"
. "</td>";

} 

If ($activegames>=2){

echo "<td>"
. "<table>"
. "<tr>"
. "<td>"
. "Table 2"
. "</td>"
. "</tr>"
. "</table>"
. "</td>"
. "</tr>";

}

</table>
?>

ect...ect...ect...

KingChaos · August 20, 2007

I got a code that generates rows in a table from a mysql fetch. It works almost as it should, but it generates them verticaly and I need them to be horizontaly..

Code for verticaly generated rows

<table width="100%" height="100%" border="0">
    <tr>
     <td align="center" height="12"><FONT SIZE=3><STRONG><b>Heading text. Appears only once!</FONT></b></td>
    </tr><p><br>
    <tr>	
    </tr>

     <td align="center" valign="top">
     <?
          if($msg == disabled){?><br><font color="#FF9900"><b>Some text goes here</b></font><br><?}
          if($msg == select){?><br><font color="#FF9900"><b>Some text goes here</b></font><br><?}
      elseif($msg){?><br><font color="#FF9900"><b><?=$msg?></b></font><br><?}?>
     <?
// pinoywebdev add s
$time = cln($time);
// pinoywebdev add e
     $get = mysql_query("SELECT 1,2 FROM $tab[game] WHERE ends>'$time' ORDER BY round ASC;");
     while ($game = mysql_fetch_array($get)){ output($game[0],$game[1]); }
     ?>
     </td>
    </tr>
   </table>

How can I make this code generates new table coloms instead of rows ???

Plz help

King

Sign In

[SOLVED] mysql and tables.

Recommended Posts

KingChaos

Link to comment

Share on other sites

mpharo

Link to comment

Share on other sites

KingChaos

Link to comment

Share on other sites

AndyB

Link to comment

Share on other sites

mpharo

Link to comment

Share on other sites

KingChaos

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information