Jump to content

help.. modulo?


Tkaspers88

Recommended Posts

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
Link to comment
Share on other sites

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
Link to comment
Share on other sites

[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
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.