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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
