Re: formating w/ table

Jas color=\"333333\"></td></tr></table>\n"; } ?> The </table> is in the loop. Place it outside & you'll be OK. Miles Thompson At 01:35 AM 2/15/2002 -0700, jas wrote:

I am having a little problem formating data retrieved from a database into table cells... So far after connecting and querying the database table the data is put into table cells, however after the first entry is displayed in the table all the other entries loose the formating, HELP? <?php require 'scripts/db.php'; $result = mysql_query("SELECT * FROM cur_inv",$dbh) or die("Could not execute query, please try again later"); echo "<table border=\"0\" class=\"newhead\" width=\"100%\"><tr><td align=\"center\" colspan=\"2\"><B>Current Inventory</B><hr color=\"333333\"></td></tr>"; $count = -1; while ($myrow = mysql_fetch_row($result)) { $count ++; echo "<tr><td width=\"30%\"><B>Type Of Car: </B></td><td>"; printf(mysql_result($result,$count,"car_type")); echo "</td></tr>\n"; echo "<tr><td width=\"30%\"><B>Model Of Car: </B></td><td>"; printf(mysql_result($result,$count,"car_model")); echo "</td></tr>\n"; echo "<tr><td width=\"30%\"><B>Year Of Car: </B></td><td>"; printf(mysql_result($result,$count,"car_year")); echo "</td></tr>\n"; echo "<tr><td width=\"30%\"><B>Price Of Car: </B></td><td>$"; printf(mysql_result($result,$count,"car_price")); echo "</td></tr>\n"; echo "<tr><td width=\"30%\"><B>VIN Of Car: </B></td><td>"; printf(mysql_result($result,$count,"car_vin")); echo "</td></tr><tr><td colspan=\"2\"><hr color=\"333333\"></td></tr></table>\n"; } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php