Need help with PhP MySQL

[JustRetarded]

Hey guys i was wondering if its possible to actually split results, what i mean is that having like

5 rows showing then like a double <br> and 5 more bla bla bla... till the end of my DB.

i looked up everywhere but cant seem to find anything.

im sure its possible though lol

any advices ? thanks alot

[Capo64]

Pretty easily.

$con = mysql_connect("yadayada", "yada", "blah");
		if (!$con) {
			die('Could not connect: ' . mysql_error());
		}
		mysql_select_db("blahblah", $con);
		$result = mysql_query("SELECT * FROM db");
$i = 0;
		while($row = mysql_fetch_array($result))
		{
                      echo $row['column'];
                      $i++;
                      if ($i >= 5) {
                         echo "<br />";
                         $i = 0;
                      }
		}

that should work, if not it's something similar to that you just use a counter and when it gets to 5 you echo a br and reset it.

[JustRetarded]

works great thanks alot and actually thanks to you i learned alot of new possibilities

im stupid but learning lmao

[Taltos]

The one thing I would add to Capo64's solution would be to use modulus and then you don't have to reset the counter. Something like:

$i = 1;
if($i % 5 = 0)
    echo <br />

The % is modulus which returns the remainder of a division. Everytime it is 0, you have looped 5 times. For this particular case, Capo's solution is just as good although later you may find you get into bigger projects and the modulus technique will be more useful. Have fun!

[ToddW]

Originally Posted by Taltos

The one thing I would add to Capo64's solution would be to use modulus and then you don't have to reset the counter. Something like:

$i = 1;
if($i % 5 = 0)
    echo <br />

The % is modulus which returns the remainder of a division. Everytime it is 0, you have looped 5 times. For this particular case, Capo's solution is just as good although later you may find you get into bigger projects and the modulus technique will be more useful. Have fun!

Keep this stuff in mind for pagination too