Formatting Table MYSQL Query

Question

I have the following code which formats a table on a webpage like this:

echo "<table border='1'>
<tr>
<th>Room Name</th>
<th>Address</th>
<th>Phone</th>
<th>Map</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td font color=red>" . $row['NameofLocation'] . "</td>";
  echo "<td>" . $row['Address'] . ", " . $row['City'] . "  " . $row['Province'] . "</td>";
  echo "<td>" . $row['Phone'] . "</td>";
  echo "<td>" . "<a href='http://maps.google.com/maps?q=" . $row['Address'] . "+" . $row['City'] . "+" . $row['Province'] . "&hl=en'target=“_blank” >Map</a></font></td></tr>" . "</td>";
  echo "</tr>";
  }
echo "</table>";

I would like to format the table with some color and space out the columns a little more evenly. Is there a way to automate the width of each column? Specifically, it is the phone number and Map field which will remain constant.

you can use CSS for this

D. Rattansingh
– D. Rattansingh

2011-12-15 01:32:16 +00:00
Commented Dec 15, 2011 at 1:32 — D. Rattansingh
– D. Rattansingh, Commented Dec 15, 2011 at 1:32

Pritom · Accepted Answer · 2011-12-15 01:41:55Z

1

Maybe this will help you

<th style='width:50%; color:red;'>Room Name</th>
<th style='width:50%; color:red;'>Address</th>
<th style='width:80px; color:red;'>Phone</th>
<th style='width:20px; color:red;'>Map</th>

edited Dec 15, 2011 at 1:41

answered Dec 15, 2011 at 1:33

Pritom

1,3338 gold badges20 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formatting Table MYSQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related