how do you display three records then start a new row?

[DrewM]

I'm doin a script and I want 3 resaults and then start a new row can some one tell me what code to use?

[Sean S]

do you want all the first three results in one row? so like

---------------------------
| result_1 result_2 result_3 |
---------------------------
| result_4 result_5 result_6 |
---------------------------

[DrewM]

yes that is.

[Sean S]

Ok I'm no php professional, but this is what I did once for a client of mine and it seemed to work. Basically it displays the results upto 3 columns per row or 3 results per row, once the 3 results has been displayed, it goes to the next row.

$number, this variable controls the total amount of data you want to display.

also you have to change this part

SELECT id, image, link, category FROM $table

to whatever your table is setup to.

and last, change this the same way,

$row[link]

PHP Code:

<?php
$username="database_username";
$password="database_password";
$database="database_name";
$table="table_name"; //the sql table name that you want to pull out the data from
$number="6"; //the total amount of results that you want to display

$i = 1;
$e = 2;

//number of columns of the table generated
$column = 3;

//connecting to mysql
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); 

$getresults = mysql_query("
    SELECT id, image, link, category FROM $table  
    ORDER BY id ASC
    LIMIT $number");
    
echo "<table><tr>";
while($row = mysql_fetch_array($getresults))
{
echo "<td>";

echo "<p>$row[link]</p>";
       
echo "</td>";

if ($i == $column) {

echo "</tr><tr>"; 

$column = 3*$e;

$e++;

}  
    
$i++;

}

echo "</table>";    

?> 
<br />

hope this helps

[DrewM]

Originally Posted by Sean S

Ok I'm no php professional, but this is what I did once for a client of mine and it seemed to work. Basically it displays the results upto 3 columns per row or 3 results per row, once the 3 results has been displayed, it goes to the next row.

$number, this variable controls the total amount of data you want to display.

also you have to change this part

SELECT id, image, link, category FROM $table

to whatever your table is setup to.

and last, change this the same way,

$row[link]

PHP Code:

<?php
$username="database_username";
$password="database_password";
$database="database_name";
$table="table_name"; //the sql table name that you want to pull out the data from
$number="6"; //the total amount of results that you want to display

$i = 1;
$e = 2;

//number of columns of the table generated
$column = 3;

//connecting to mysql
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); 

$getresults = mysql_query("
    SELECT id, image, link, category FROM $table  
    ORDER BY id ASC
    LIMIT $number");
    
echo "<table><tr>";
while($row = mysql_fetch_array($getresults))
{
echo "<td>";

echo "<p>$row[link]</p>";
       
echo "</td>";

if ($i == $column) {

echo "</tr><tr>"; 

$column = 3*$e;

$e++;

}  
    
$i++;

}

echo "</table>";    

?> 
<br />

hope this helps

how can this be done with vb?

[Sean S]

I personally did it by putting the forum's db info and connecting to forum's database.

[DrewM]

oh well I'll just use what you gave me.

[Code Monkey]

Just go to a place like Sitepoint.com and do a search for the term "Modulus" and you will find loads of info on easy solutions. I would answer direct but I'm headed off to work.

[DrewM]

Can you there wasn't any thing at sitepoint

[Code Monkey]

Really?