Columns and Rows x 4

[sgtpepper]

Hi,

I have the following piece of code. I am trying to get the results to display in 4 columns.....and unlimited rows.

Basically, I am getting the results.....in one long row....with unlimited columns.....

Can you please tell me what I am missing to accomplish this?

<?php
require('connect.php');
require('config.php');

// Below will display listings for specific ID/// //
$query="SELECT * FROM agents where office_name='Company'";

$result = mysql_query($query) or die("Query failed: ". mysql_error());

$i=0;
echo "<table width='0' align='center' cellspacing='2' cellpadding='2'>\n";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
if ($i%4==0)
{
}

print"<td width='110'><a href='agent_bio_pop.php?Id=$line[Id]' onclick=\"window.open(this.href, 'popupwindow', 'width=700,he$
echo "    <td width='1'></td>\n";
echo "    <td width='5' bgcolor='#003399'></td>\n";



$i++;
}
echo "</table>\n";

/* Free resultset */
mysql_free_result($result);

[bpat1434]

Wow. Interesting code. Not sure what you're trying to do. Most likely, you want something like:

while($row = mysql_fetch_array($result))
{
    echo "<tr>\n";
    echo "<td>".$row['field']."</td>\n
              <td>".$row['field']."</td>\n
              <td>".$row['field']."</td>\n
              <td>".$row['field']."</td>\n";
    echo "</tr>";
}

If I'm wrong, look at the code you posted, and explain it, or re-post it to what it should be. That's not syntactically correct the way you posted it. I'm guessing you edited some stuff out that you don't want us to see. Don't delete, just replace with ***** or ------.

~Brett

[sgtpepper]

This helps....but let me try to give you more detail...

By using your code the following way

while($row = mysql_fetch_array($result))
{
    echo "<tr>\n";
    echo "<td>".$row['agent_name']."</td>\n
              <td>".$row['agent_name']."</td>\n
              <td>".$row['agent_name']."</td>\n
              <td>".$row['agent_name']."</td>\n";
    echo "</tr>";
}

[.php]

I get the following results....
<table width="100%" border="1">
  <tr>
    <td>Edward Redpath</td>
    <td>Edward Redpath</td>
    <td>Edward Redpath</td>
    <td>Edward Redpath</td>
  </tr>
  <tr>
    <td>Jennifer Snyder</td>
    <td>Jennifer Snyder</td>
    <td>Jennifer Snyder</td>
    <td>Jennifer Snyder</td>
  </tr>
  <tr>
    <td>John Nelson</td>
    <td>John Nelson</td>
    <td>John Nelson</td>
    <td>John Nelson</td>
  </tr>
  <tr>
    <td>Diana Martin</td>
    <td>Diana Martin</td>
    <td>Diana Martin</td>
    <td>Diana Martin</td>
  </tr>
</table>

I would like to get....
<table width="100%" border="1">
  <tr> 
    <td>Edward Redpath</td>
    <td>Jennifer Snyder</td>
    <td>John Nelson</td>
    <td>Diana Martin</td>
  </tr>
</table>

Also, it will need to start a new row if more than 4 agent names excist

[bpat1434]

$i = 0;
echo "<tr>\n";
while($row = mysql_fetch_array($result))
{
    $i++;
    echo "<td>".$row['agent_name']."</td>\n";
    if($i%4==0)
    {
        echo "</tr>\n<tr>";
    }
} 

That should work for you.

~Brett

[sgtpepper]

Thanks Brett!

That is working really well. If I wanted to change from 4 to 5 columns do I change if($i%4==0) to if($i%5==0)

[TheDefender]

Yes...

[sgtpepper]

hmmm....it didnt work quite right.

my code is

$i = 0;
echo "<tr>\n";
while($row = mysql_fetch_array($result))
{
    $i++;
    echo "


<td>
$row[agent_name]
</td>


\n";
    if($i%6==0)
    {
        echo "</tr>\n<tr>";
        $i = 1;
    }
}

I changed it to 6 columns. Look at the results towards the bottom of this page:

http://www.uppervalleyhomesforsale.com/hanover_nh_office.php

Any ideas?

Thank you.

[bpat1434]

Here's your problem:

You are going 6 columns across, but the rows above where the script works says that it has a colspan that is 4. So that's why it's being pushed over.

Not a script issue, but rather a HTML coding flub. Just change the colspan to 6 and it should work.

<td colspan="4">

~Brett