Displaying Records

[Beppe]

Hi all! I need help from you, PHP masters.

Well, I have a PHP application that interacts with a 30 records MYSQL database. I want to display 3 records per row, and not only one. How can I?

Thanks,
Beppe from Italy!

[conspi]

First connect to your database :

$connect = mysql_connect($host,$bdd_username,$bdd_password);
mysql_select_db($bdd,$connect);
$request = "SELECT * FROM $table";
$action = mysql_query($request) or die('SQL Error!<br>'.$sql.'<br>'.mysql_error());

then

while($data = mysql_fetch_array($action))
        {
	$email = $data[email];
                echo $email;
                echo ("<br>");
         }

This means that while there are entries a new $email value will be written on the page

Hope this helps

COnspi

[_SuperString]

as per the above post, but to get 3 records in a row you need to change it to this:

$i=0;
$j=0;
while($data = mysql_fetch_array($action))
{
    if($i < $j+3) {
       echo $data[email];
       $i++;
       $j++;
    } else {
       echo "<br>";
        $i++;
    }
}

[Weedpacket]

Why the extra variable?

$i=0;
while($data=mysql_fetch_array($action))
{   echo $data['email']." ";
     if(++$i%3==0) echo'<br>';
}