Spreadsheet iutput looklike in PHP

dkin

HI,

I am trying to print each record below in a Data Table format output (like a spreadsheet) and between each record I decided to leave an empty line. I tried with <Table >, <td>,<tr> and all the option, but I can not find the correct way to write it.

How can I produce this table output?

Script:
…
if ($rowsFound > 0)
{
while ($row = @ mysql_fetch_array($result))
{
print '<tr><td>'.'Driver: '. '</tr></td>'. $row["driver"].” \n”;
print '<tr><td>'.'Speed: '. '</tr></td>'. $row["speed"]. “ \n”;
print '<tr><td>'.'Nome: '. '</tr></td>'. $row["nome"]. “ \n”;
print " \n";
}
}
…

planetsim

You pretty much have it.. instead use echo. and use one of them. You dont need all the print's your using for every new line

daphreeek

hehe 🙂

before you try to use php you should learn a bit more html - it makes life lots easier.

first - the <tr> and <td> tags need 2 b inside <table> tags.

<tr> specifies a new row
<td> specifiec a new column

so try this for your code:

if ($rowsFound > 0) {
   echo "<table>\n";

   echo "<tr><td><b>Driver:</b></td>\n"; 
   echo "<td><b>Speed:</b></td>\n"; 
   echo "<td><b>Nome:</b></td></tr>\n"; 

   while ($row = @mysql_fetch_array($result)) { 
      echo "<tr><td>".$row["driver"]."</td>\n"; 
      echo "<td>".$row["speed"]."</td>\n"; 
      echo "<td>".$row["nome"]."</td></tr>\n"; 
   }

   echo "</table>\n";
}

Of course this will only work if your MySQL queries are correct.

Matt

dkin

I Changed the print to echo and how can I had lines to create a "box" (horizontal and vertical lines) for each record. and then begin a new "box" for the next record.