Tkaspers88 Posted August 2, 2006 Share Posted August 2, 2006 I have a database with information about MMORPG monsters.. now I want to create a creatureoverview like you can see here: [url=http://www.tibia.com/library/?subtopic=creatures]http://www.tibia.com/library/?subtopic=creatures[/url] and here [url=http://www.tibianews.net/bestiary.asp]http://www.tibianews.net/bestiary.asp[/url] etc..I want to show 5 creatures on a row..I use this code to get the information from the database and to show them:[code]<?phpinclude('../dbconfig.php');$sql = "SELECT ImageAdress,NameUrl,Name,Experience,Hitpoints FROM Creatures ORDER BY Name";if(!$result = mysql_query($sql)){ echo "Error: Creating creaturelist failed. Please try again!";}else{ if(mysql_num_rows($result) == 0) { echo "Error: No results.. Please try again!"; } else { while($row = mysql_fetch_assoc($result)) { echo '<TD><A HREF="creature.php?xd='.$row['NameUrl'].'"><IMG border=0 src="images/'.$row['ImageAdress'].'" width=64 height=64></A><BR><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#CCCCCC"><strong>'.$row['Name'].'</strong></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#999999"><em>Exp: '.$row['Experience'].'</em></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><em>HP: '.$row['Hitpoints'].'</em></font></TD>'; } }}?>[/code]But it shows them wrong... As you can see it shows the image,name,exp and hp and it retrieves all creatures from my database.. how can i make it like i want it?I want it to show 5 creatures next to each other and not all of them.. so it needs to start a new row after 5 creatures..Maybe its modulo?//Thijs Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 2, 2006 Share Posted August 2, 2006 Something like this perhaps?[code] $i=1; while($row = mysql_fetch_assoc($result)) { if ($i == 1) echo '<tr>'; echo '<TD><A HREF="creature.php?xd='.$row['NameUrl'].'"><IMG border=0 src="images/'.$row['ImageAdress'].'" width=64 height=64></A><BR><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#CCCCCC"><strong>'.$row['Name'].'</strong></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#999999"><em>Exp: '.$row['Experience'].'</em></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><em>HP: '.$row['Hitpoints'].'</em></font></TD>'; if ($i == 5) echo '</tr>'; $i++; } if ($i != 1 && $i != 5) echo '</tr>'; echo '</table>';[/code]Ronald ;D Quote Link to comment Share on other sites More sharing options...
DaveLinger Posted August 2, 2006 Share Posted August 2, 2006 almost perfect, but where do I define my variables retrieved from the db? Quote Link to comment Share on other sites More sharing options...
Tkaspers88 Posted August 2, 2006 Author Share Posted August 2, 2006 [quote author=ronverdonk link=topic=102709.msg408058#msg408058 date=1154526993]Something like this perhaps?[code] $i=1; while($row = mysql_fetch_assoc($result)) { if ($i == 1) echo '<tr>'; echo '<TD><A HREF="creature.php?xd='.$row['NameUrl'].'"><IMG border=0 src="images/'.$row['ImageAdress'].'" width=64 height=64></A><BR><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#CCCCCC"><strong>'.$row['Name'].'</strong></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#999999"><em>Exp: '.$row['Experience'].'</em></font><br /><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><em>HP: '.$row['Hitpoints'].'</em></font></TD>'; if ($i == 5) echo '</tr>'; $i++; } if ($i != 1 && $i != 5) echo '</tr>'; echo '</table>';[/code]Ronald ;D[/quote]It works "almost".. It works for the first 5 creatures.. but all the others are next to each other.. hmmGreetings,Thijs Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 2, 2006 Share Posted August 2, 2006 Sorry, overlooked the obvious reset of $i. Should be:[code]if ($i == 5) { echo '</tr>'; $i=1;} else $i++;[/code]Ronald ;D Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted August 2, 2006 Share Posted August 2, 2006 [code]if($i%5 == 0)[/code]then you don't even need to reset.so, modulo is the answer :) 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.