How to display data from SQL table?

[dbykel]

I am having a problem displaying data in a certain way from an SQL table...

Take the following example of code:

$q = mysql_query("SELECT data FROM table") or die(mysql_error());

echo"
<table>
<tr>
       <th>Result</th>
</tr>";

while($row = mysql_fetch_array($q)){
extract($row);
echo"
<tr>
       <td>$data</td>
</tr>";
}
echo"</table>";

if there are 6 rows of data in the table the output will look like:

<table>
<tr>
       <th>Result</th>
</tr>
<tr>
       <td>data 1</td>
</tr>
<tr>
       <td>data 2</td>
</tr>
<tr>
       <td>data 3</td>
</tr>
<tr>
       <td>data 4</td>
</tr>
<tr>
       <td>data 5</td>
</tr>
<tr>
       <td>data 6</td>
</tr>
</table>

What php code will produce the following html output?:

<table>
<tr>
       <th colspan=3>Result</th>
</tr>
<tr>
       <td>data 1</td>
       <td>data 2</td>
       <td>data 3</td>
</tr>
<tr>
       <td>data 4</td>
       <td>data 5</td>
       <td>data 6</td>
</tr>
</table>

Thanks

[daphreeek]

Hey.

I havent tested the following code as I have no access to a PHP server at the mo, but it should be fine.

$q = mysql_query("SELECT data FROM table") or die(mysql_error());
$x=0;

echo"
<table>
<tr>
       <th>Result</th>";

while($row = mysql_fetch_array($q)){

  extract($row);

  if ($x==0){
    echo "</tr><tr>";
  }

  $x++;

  if ($x == 3){
    $x = 0;
  }

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

Something like that - im a little rusty on my php tho - but should work 🙂

[ClarkF1]

ignore

[php1306]

Hi, I had a similar problem and your code helped but i's displaying all the data on the same line instead of a more "table-like" display. Do you know how i could achieve this. I've attached what it currently looks like.

[UziTech]

I created a script that displays all tables and info in a web sql database. I am still working on it but it seems to work perfectly in chrome

http://UziTech.com/database.php

[boeta13]

php1306;10994066 wrote:

Hi, I had a similar problem and your code helped but i's displaying all the data on the same line instead of a more "table-like" display. Do you know how i could achieve this. I've attached what it currently looks like.

Have you tried using something like

 echo '<td>' . $row['data 1'] . '</td>';