How to print 3 columns table

anton_fraser

Hi, I need to print data from my database in 3 columns table, like first row to be in first column second in second, third in third and then 4th in 1st columt, 5th in second etc

I have no ide how to do that seen a few tutorials on the web but none helped, if you could suggest me some tutorial or just post some help here please...

sheephat

search this forum for, while looping and mysql_fetch_array

im sure there are hundreds if not thousands of threads around here

leatherback

Hm.. If you have done a series of tutorials. Why don't you show us what you have tried, and why it didn;t work matey.

anton_fraser

Here is one that actually does something not just showing loads of errors I can't correct but for some reason it gives me 4 columns with just one entry in the forth column

<?php 
		  $numcols = 3; // how many columns to display
$numcolsprinted = 0; // no of columns so far

// includes
include('conf.php');
// check for record ID
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ('Unable to connect!');
// select database
mysql_select_db($db) or die ('Unable to select database!');
// generate and execute query
$query = "SELECT cvcatid, cvcatname FROM cvcategories";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_row($result))
{
$tn = $row[0];
$in= $row[1];

if ($numcolsprinted == $numcols) {
print "</tr>\n<tr>\n";
$numcolsprinted = 0;
}
// output row from database
echo "<td>$in $tn</td>\n";
// bump up row counter
$numcolsprinted++;

} // end while loop

$colstobalance = $numcols - $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {

} 
print "<TD></TD>\n";


}

// if no records present
// display message
else
{
?>
<font size="-1">No categories currently available</font>
<?php
}
// close database connection
mysql_close($connection);
?>

anton_fraser

It prints my rows in 4 columns for some reason and makes a mess out of my page, it appears nothing like it should here is the code

<?php 
		  $numcols = 3; // how many columns to display
$numcolsprinted = 0; // no of columns so far

// includes
include('conf.php');
// check for record ID
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ('Unable to connect!');
// select database
mysql_select_db($db) or die ('Unable to select database!');
// generate and execute query
$query = "SELECT cvcatid, cvcatname FROM cvcategories";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_row($result))
{
$tn = $row[0];
$in= $row[1];

if ($numcolsprinted == $numcols) {
print "</tr>\n<tr>\n";
$numcolsprinted = 0;
}
// output row from database
echo "<td>$in $tn</td>\n";
// bump up row counter
$numcolsprinted++;

} // end while loop

$colstobalance = $numcols - $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {

} 
print "<TD></TD>\n";


}

// if no records present
// display message
else
{
?>
<font size="-1">No categories currently available</font>
<?php
}
// close database connection
mysql_close($connection);
?>

anton_fraser

I've got it, i missed some HTML tags it should have been like this

<?php 
		  $numcols = 3; // how many columns to display
$numcolsprinted = 0; // no of columns so far

// includes
include('conf.php');
// check for record ID
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ('Unable to connect!');
// select database
mysql_select_db($db) or die ('Unable to select database!');
// generate and execute query
$query = "SELECT cvcatname FROM cvcategories";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_row($result))
{
$tn = $row[0];
$in= $row[1];

if ($numcolsprinted == $numcols) {
print "</tr>\n<tr>\n";
$numcolsprinted = 0;
}
// output row from database
echo "<td>$in $tn</td>\n";
// bump up row counter
$numcolsprinted++;

} // end while loop

$colstobalance = $numcols - $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {

} 
print "<TD></TD>\n";
?>
</table> 
<?php

}

// if no records present
// display message
else
{
?>
<font size="-1">No categories currently available</font>
<?php
}
// close database connection
mysql_close($connection);
?>

HalfaBee

A good start would be formatting your code.
You are missing <table> tags there will be a </tr> before the first row.
There is a redundant for loop after the while().
and an extra <TD></TD>

<?php
$numcols = 3;// how many columns to display
$numcolsprinted = 0;// no of columns so far
// includes
include( 'conf.php' );// check for record ID
// open database connection
$connection = mysql_connect( $host, $user, $pass ) or die( 'Unable to connect!' );// select database
mysql_select_db( $db ) or die( 'Unable to select database!' );// generate and execute query
$query = 'SELECT cvcatid, cvcatname FROM cvcategories';
$result = mysql_query( $query ) or die( "Error in query: $query. " . mysql_error() );// if records present
if( mysql_num_rows( $result ) > 0 )
{// iterate through resultset
	// print article titles
	while( $row = mysql_fetch_row( $result ) )
	{
		$tn = $row[ 0 ];
		$in = $row[ 1 ];

	if( $numcolsprinted == $numcols )
	{
		print "</tr>\n<tr>\n";
		$numcolsprinted = 0;
	}// output row from database
	echo "<td>$in $tn</td>\n";// bump up row counter
	$numcolsprinted++;
}// end while loop
$colstobalance = $numcols - $numcolsprinted;

for( $i = 1; $i <= $colstobalance; $i++ )
{
}

print "<TD></TD>\n";
}// if no records present
// display message
else{
	?><font size="-1">No categories currently available</font><?php
}// close database connection
mysql_close( $connection );
?>

anton_fraser

Thanx it's working great now :-) need to change half of the website now