Jump to content

Recommended Posts

hey. heres the code...pretty simple.

<?php
mysql_connect("localhost", "root", "pancakes1") or die(mysql_error());
mysql_select_db("related") or die(mysql_error());

$result = mysql_query("SELECT * FROM action ORDER by name ASC")
or die(mysql_error());  

while($row = mysql_fetch_array($result)){       
echo $row[0];
echo '<br>';
}
?>

 

how do i create a results table and put 10 results in each column??

Link to comment
https://forums.phpfreaks.com/topic/83281-putting-results-in-columns/
Share on other sites

i want it

 

1 3

2 4

 

 

this is what that link is telling me too add after i carry ou tthe query

if($result && mysql_num_rows($result) > 0)
{
    $i = 0;
    $max_columns = 3;
    while($row = mysql_fetch_array($result))        
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)
          echo "<tr>";

       // make sure we have a valid product
       if($product != "" && $product != null)
          echo "<td>$product</td>";
    
       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns) 
       {
           echo "</tr>";
           $i=0;
       }  // end if 
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i < $max_columns)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td> </td>";
}
?>

 

but i'm confused as too where i specify the max amount of rows in the column.

You don't, when you write a table you do it row by row, adding columns each time. Therefore it just makes as many rows as needed.

 

However if you wanted a max then you'd use a variable to count within the while loop and when the max count is reached it exits the while.

i want it

 

1 3

2 4

 

If you want it this way and to teeter out then you got even more work to do cos you gotta either know the max rows (and cols) and end up with...

 

1 3

2 4

 

again, or you need to know as before but truncate and miss data to produce...

 

1 5

2 6

 

best way to think about it is to write it down and consider how you did it (but also try to think like the code is written!). It might all sound confusing, but with a little thought it's all really simple... all else fails, try some trial and error!

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.