Echo Data into 2 HTML table cells? It won't stop repeating!

PHPAnx

Instead of printing results in one long html table cell, I want to list them in two cells side by side. As I have it now it is REPEATING the data in both cells that are side by side. I don't want this. Should be like below:

Like so:

1 6
2 7
3 8
4 9
5 10

instead of:

1
2
3
4
5
6
7
8
9
10

Here is my current code for the echo:

$conn = mysql_connect("$location","$username","$password");
if (!$conn) die ("Could not connect MySQL");
mysql_select_db($database,$conn) or die ("Could not open database");

$color1 = "#ffffff";
$color2 = "#cccccc";
$row_count = 0;

$sql="SELECT * FROM tours WHERE $show LIKE ('%".addslashes($search)."%') ORDER BY toursDate LIMIT $offset, $sqllimit";

$result=mysql_query($sql);
$numRows = mysql_num_rows($result);

$error = mysql_error($conn);
if($error)
{ echo("SQL : $sql<p>Error : $error<p>"); }

if (mysql_num_rows($result)<1)
{ echo("<table border='0' cellspacing='0' cellpadding='0' width='750'><tr><td class='title'><strong>Sorry, no matches could be found at this time.</strong><br><br></span></td></tr></table>"); }
else
{
echo("<table border='0' cellspacing='0' cellpadding='0' width='750'><tr><td><table border='0' cellspacing='1' cellpadding='2' width='100%'><tr><td colspan='3' class='title'><strong>Search results for \"<span class='titlered'>$search</span>\"</strong><br><br></td></tr><tr><td class='text'><strong>Artist</strong></td><td></td><td class='text'><strong>Artist</strong></td></tr>");

$counter=0;
while(($counter<$limit)&&($row = mysql_fetch_array($result)))
{
$id = $row["toursID"];
$artist = $row["toursArtist"];
$date = $row["toursDate"];
$city = $row["toursCity"];
$state = $row["toursState"];
$venue = $row["toursVenue"];

 $row_color = ($row_count % 2) ? $color1 : $color2; 

 echo "<tr><td bgcolor=$row_color class='text'>$artist</td>"; 
 echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>"; 
 echo "<td bgcolor=$row_color class='text'>$artist</td></tr>"; 

 $counter++;
 $row_count++;  
}

echo "</table></td></tr></table>";
}

tomhath

echo "<tr><td bgcolor=$row_color class='text'>$artist</td>"; 
echo "<td>    </td>"; 
echo "<td bgcolor=$row_color class='text'>$artist</td></tr>";

What exactly did you expect these three lines to do (besides display $artist in two adjacent cells)?

It would be much easier to display the data like this, since that's the order you are retrieving the rows. Is that acceptable?

1 2
3 4
5 6
...

PHPAnx

I could definitely live with that, but would still prefer the latter.

Please post though, I'm very very interested in seeing what you have come up with.

PHPAnx

Originally posted by tomhath
echo "<tr><td bgcolor=$row_color class='text'>$artist</td>"; 
echo "<td>    </td>"; 
echo "<td bgcolor=$row_color class='text'>$artist</td></tr>"; 
What exactly did you expect these three lines to do (besides display $artist in two adjacent cells)?

It would be much easier to display the data like this, since that's the order you are retrieving the rows. Is that acceptable?

1 2
3 4
5 6
... [/B]

Actually display more than just "$artist" Listed just that for easability in reading my post.

Also want to display the other variables listed:
$artist
$date
$city
$state
$venue

Thanks!

tomhath

Should be something like this (untested). Write one set of cells for each row from the query, alternating left and right side of the HTML table similar to the way you alternate colors.

The problem is that the HTML table has to be built a row at a time, so trying to build it a column at a time the way you originally wanted would be difficult.

$counter=0; 
while(($counter<$limit)&&($row = mysql_fetch_array($result))) 
{ 
  $artist = $row["toursArtist"]; 
  // other fields ...

  if ($counter % 2) {
    echo "<td bgcolor=$row_color class='text'>$artist</td></tr>"; 
    $row_count++; 
  } else {
    $row_color = ($row_count % 2) ? $color1 : $color2; 
    echo "<tr><td bgcolor=$row_color class='text'>$artist</td>"; 
    echo "<td>&nbsp;</td>"; 
  }
  $counter++; 
} 
if ($counter % 2) {
  echo "<td>&nbsp;</td></tr>"; 
}

PHPAnx

tomhath... a million thanks. It works. If you are able to figure out a way to have it list like:

1 3
2 4

instead of:

1 2
3 4

I would be very interested still.

Nevertheless, thank you for the code help. I had a terrible time with the logic on this and you got it! Thanks!

tomhath

To display them a column at a time, I would start by reading half the rows into an array. Then build the HTML table while reading the other half of the rows (left side cell from the array, right side from the row just fetched). Not that much more code than you already have.