help.. modulo?

[Tkaspers88]

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]<?php

include('../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

[ronverdonk]

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

[DaveLinger]

almost perfect, but where do I define my variables retrieved from the db?

[Tkaspers88]

[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.. hmm

Greetings,
Thijs

[ronverdonk]

Sorry, overlooked the obvious reset of $i. Should be:

[code]
if ($i == 5) {
  echo '</tr>';
  $i=1;
}   
else
  $i++;
[/code]

Ronald  ;D

[ryanlwh]

[code]if($i%5 == 0)[/code]

then you don't even need to reset.

so, modulo is the answer :)