HTML table problems with php data

MitchEvans

Hi Guys,

I am getting data from my table and each part of the data needs to be on a new row like so:

1
5
3
8

I then need to get data from another table and put it side by side with the above data - my problem is I cannot start a new column that appears at the top of the table only a new row, I want to be able to add data so my new table now looks like so:

1 / 2
5 / 4
3 / 2
8 / 3

my code is like so:


//echo data from db table 1 - these are not numbers they're variables in the actual script
echo"<table><tr><td>1</td></tr><tr><td>5</td></tr><tr><td>3</td></tr>><tr><td>8</td></tr>";
//echo data from second db table 2
  echo"<tr><td>2</td></tr><tr><td>4</td></tr><tr><td>2</td></tr>><tr><td>3</td></tr></table>";

How Do I get the data from db table 2 to appear alongside the data from table 1

It currently looks like this due to the table starting a new row etc.

1
5
3
8
2
4
2
3

I need the data from table 1 in one column and the data from table 2 in a second column side by side

igorlopez

I guess there are very many different ways but why not just put in the table delimiter for each column in each row as:

echo"<table><tr><td>1</td><td>2</td></tr><tr><td>5</td><td>4</td></tr><tr><td>3</td><td>2</td></tr>><tr><td>8</td><td>3</td></tr>"; ?>

same numbers you had in your example.
This gives me a table according to your spec.

leatherback

While you are retrieving data from the first table, do not create the output straight away. instead, store it in e.g., an array. You can then use this array to create the first cell value, and then spit out the value returned from table two:

$tmp = array();
while($row = mysql_fetch_array($result))
  {
  $tmp[] = $row;
  }

This can then of course be adjusted to use the identifier of the record as a key etcetc. But this is a basic way to do it.

Naturaly.. you are probably looking at the JOIN in mysql so that you retrieve data from both tables at the same time, and you do not even have this issue...