Dispaly contents of array in one table cell and contents of a database in the next

maxwell_

I am trying to loop through, and display, the contents of an array
in a table cell, and loop through and display the content of a database
field in the cell next to it. I would like the database loop to continue
even though the array loop is complete.
Using the following code I am getting the contents of the array only.
I also tried reworking the code and ended up with the data side by side
as required however the rows repeated the same number of times as
there is rows in the database.

$results = $mysqli->query("SELECT message FROM contact");

echo '<table width="100%" border="1" cellspacing="0" cellpadding="0">';

$colors = array("red", "green", "blue", "yellow"); 

$arrlength = count($colors);   

while($row = $results->fetch_assoc())
$numRows = $results->num_rows;
{
	  $arrlength = count($colors); 

      for($x = 0; $x < $arrlength; $x++) {

		  $colors[$x];
	 if ($x>$numRows){

		 break;

		 }   

   echo ' <tr align="center" height="40"><td>' . $colors[$x] . '</td><td>' . $row["message"] . '</td></tr>';
}
}
echo '</table>';

dalecosp

Set $numrows to be the larger of the size of the array, or the size of the result set, and loop from zero to $numrows.

maxwell_

Hi,
My database table called contact contains 8 rows
Using the following code the second table cell correctly displays the contents of the db column
called message on each of the rows 1 to 8.
The array called colors contains 4 items, I would like the first table cell on rows 1 to 4
to display red then green....
The first table cell on rows 5 to 8 should be empty.

$results = $mysqli->query("SELECT message FROM contact"); 

echo '<table width="100%" border="1" cellspacing="0" cellpadding="0">'; 

$colors = array("red", "green", "blue", "yellow");
$arrlength = count($colors);    

while($row = $results->fetch_assoc()) {
$numRows = $results->num_rows;

echo ' <tr align="center" height="40"><td></td><td>' . $row['message'] . '</td></tr>'; 

} 
echo '</table>';

sneakyimp

I would suggest getting all of your array and database results into variables first and then outputting the <table> and <tr> tags if you can. Your code would be less confusing.