Fetching rows

[eugene2009]

Hello, im pretty sure this is simple but i just dont know how to. please help

 

<?php
// Make a MySQL Connection
$query = "SELECT * FROM example"; 

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo $row['name']. " - ". $row['age'];
?>

 

HOW do i make it that it would put 5 in one row and then break?

 

for example:

 

a  b  c  d  e

f  g  h  i  j

 

instead of

 

a

b

c

etc..

[premiso]

You would want to look into the modulus (%) operator.

[eugene2009]

thats for c++

 

im pretty sure it can be done with php

[premiso]

thats for c++

 

The math is still the same, it works for PHP using the %.

 

So (1 % 2) would equal .5, give it a try:

$num = (1%2);
echo $num;

 

It calculates if there is a remainder, if there is then you have not reached that number, if it is equaled to 0, you have reached your number and would want to insert a break.

 

EDIT:

And for the PHP reference of its usage: Arithmetic Operators.

[PravinS]

Try this

 

<?php
$k = 1;
while () // your while loop
{
	// your code

	if ($k % 5 == 0)
		echo "<br>";
	$k++;
}
?>

 

 

 

[eugene2009]

awesome! it works!