[RESOLVED] Horizontal Row from Query

[unitedintruth]

I am listing the contents of an sql table on a page. I can get it to list fine but it will only list vertically and all the help I can find online seems to creat the list horizontally, but simply repeats the first entry in the row in an endless neverending loop that never stops. Can someone help me get this to list the query results horizontally rather than vertical. My current results are;

home
honorroll
contact
thankyou
failed
services
listpostingspublic
experttips
error
enter_job_posting
jobpostingform
ListJobPostingsPublic
employment
select

My code is this;

<?
 	// Fetch rows from content table and display ALL pages
 	$listprofiles = mysql_query("SELECT * from content ORDER BY id");
 	$row = mysql_fetch_array($listprofiles);
 	while ($row) {
         print "<tr>";
         print "  <td width=\"30%\">";
         print "    <div align=\"left\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">";
 		print "		<a href=\"content.php?act=Edit&page_name=".$row["page_name"]."\">";
 		print 		$row["page_name"];
 		print "		</a>";
 		print "	   </font></div>";
         print "  </td>";

	$row = mysql_fetch_array($listprofiles);
}
 ?>

THANK YOU IN ADVANCE FOR ALL THE HELP, YOU GUYS ARE GREAT.

[stolzyboy]

something like this should work

UNTESTED

<? 
// Fetch rows from content table and display ALL pages 
$query = "SELECT * from content ORDER BY id;";
$result = mysql_query($query); 

echo "<tr>";
while ($row = mysql_fetch_array($result))
{ 
	echo "  <td width=\"30%\">"; 
	echo "    <div align=\"left\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">"; 
	echo "        <a href=\"content.php?act=Edit&page_name=".$row['page_name']."\">"; 
	echo         $row['page_name']; 
	echo "        </a>"; 
	echo "       </font></div>"; 
	echo "  </td>";  

} 
echo "</tr>";
?>

[unitedintruth]

That works awesome, only one problem remains. How do I now put those in like 3 columns rather than all in one so my page isn't a mile wide? Thanks again, your awesome.

[stolzyboy]

so you want it like:

link link link
link link link
link link link

??

[shu]

// Fetch rows from content table and display ALL pages
$query = "SELECT * from content ORDER BY id;";
$result = mysql_query($query);

$num_records = mysql_num_rows($result); //Total number of records in result
$num_per_row = 3; //Change to however many columns per row you desired
$i = 1;

while ($row = mysql_fetch_array($result)) {

if (($i == 1) || (($i > $num_per_row) && (($i % $num_per_row) == 1))) {
    echo '<tr>';
}

echo '<td width="30%"><div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a ref="content.php?act=Edit&page_name=' . $row['page_name'] . '">' . $row['page_name'] . '</a></font></div></td>';  

if (($i == $num_records) || (($i >= $num_per_row) && (($i % $num_per_row) == 0))) {

   //Fill in empty columns as necessary
   if (($i == $num_records) && ($i % $num_per_row != 0)) {
       $n = $num_per_row - ($i % $num_per_row);
       echo '<td colspan="' . $n . '">&nbsp;</td>';
   }

   echo '</tr>';
}

$i ++; //Increment counter

};

Whew, that was exhausting... 🙂

[unitedintruth]

Yes, that layout is what I was thinking, I tried the above code and got the folowing error:

Parse error: syntax error, unexpected ')' in /home/aplusplu/public_html/signup/edit/content.php on line 244

My line 244 is the line that reads:

if (($i == 1) || (($i > $num_per_row) && ($i % $num_per_row) == 1))) {

[shu]

Oops, I missed a left (, add one to each of the following statements:

if (($i == 1) || (($i > $num_per_row) && (($i % $num_per_row) == 1))) {

if (($i == $num_records) || (($i >= $num_per_row) && (($i % $num_per_row) == 0)))

[unitedintruth]

Error is now repaired, but I am back to one column vertical again. I left the code as written above and though it calls three columns, it is only posting one.

[shu]

My bad, forgot to increment the counter! Add this line at the end of the while loop:

$i ++;

I've modified the previous post to include it! It should work!!

[unitedintruth]

worked perfect, thank you very much. You guys are a great help.

[RobinR]

Hi All,

WHen I used this script I encounted a couple of problems, and wondered if you could help...
The first of which was that the script seems to miss out the 0's record, so it starts with the second line of the db... So I just changed it slightly to this:

<?

require( "common/common.php" );

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM TableName ORDER BY `Surname` ASC ";  // Fetch rows from content table and display ALL pages 
$result = mysql_query($query); 

$num_records = mysql_num_rows($result); //Total number of records in result 
$num_per_row = 3; //Change to however many columns per row you desired 

mysql_close();

echo "<table width=\"500\">";
$i = 1;
$j = 0;

while ($row = mysql_fetch_array($result)) { 
$id=mysql_result($result,$j,"ID");
$firstname=mysql_result($result,$j,"Firstname");
$surname=mysql_result($result,$j,"Surname");
$bio=mysql_result($result,$j,"Bio");


if (($i == 1) || (($i > $num_per_row) && (($i % $num_per_row) == 1))) { 
    echo "<tr>"; 
} 

echo "<td width=\"33%\"><div align=\"left\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><a href=\"test2.php?Name=$firstname $surname\">$surname, $firstname</a></font></div></td>";   

if (($i == $num_records) || (($i >= $num_per_row) && (($i % $num_per_row) == 0))) { 

   //Fill in empty columns as necessary 
   if (($i == $num_records) && ($i % $num_per_row != 0)) { 
       $n = $num_per_row - ($i % $num_per_row); 
       echo '<td colspan="' . $n . '">&nbsp;</td>'; 
   } 

   echo "</tr>"; 
} 

$i ++;
$j ++;//Increment counters
}
echo "</table>";
    ?>

I hope that this helps anyone else...

I was wondering however, if there was a quick and dirty way to have
<tr>
<td>1/3 of results</td>
<td> next 1/3 of results</td>
<td> last 1/3 of results</td>
</tr>

I thought about using $i = 1/3*$num_of_results - but I don't know the right syntax... any one any ideas if that's even possible?

Thanks in advance...

Robin

[RobinR]

Oh that is possible, and it works 🙂 so all is now well with the world...

$var = $num_of_results / $num_ per_row // does the maths
$var2 = ceil($var) // rounds it up to the next whole number 
so you don't miss off the last record

Thanks you all for your valuable time.

R.

[georkame]

Shu, your scripts works fine,

How can i add the title to the table?

For exaple

Name Surname Computer ID
John Doe WKS0001

thx in advance.

[georkame]

One more thing SHU, your script skips the field if no value in it, I would like to not do that.

basically it should show no data, this way the table will be alligned perfectly.