Your /table is inside your loop. So it is executed once to terminate the
table. After that, the browser just sees the rest as straight text.
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:35 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] formating w/ table
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%\trtd
align=\center\ colspan=\2\BCurrent Inventory/Bhr
color=\33\/td/tr;
$count = -1;
while ($myrow = mysql_fetch_row($result)) {
$count ++;
echo trtd width=\30%\BType Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_type));
echo /td/tr\n;
echo trtd width=\30%\BModel Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_model));
echo /td/tr\n;
echo trtd width=\30%\BYear Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_year));
echo /td/tr\n;
echo trtd width=\30%\BPrice Of Car: /B/tdtd$;
printf(mysql_result($result,$count,car_price));
echo /td/tr\n;
echo trtd width=\30%\BVIN Of Car: /B/tdtd;
printf(mysql_result($result,$count,car_vin));
echo /td/trtrtd colspan=\2\hr
color=\33\/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
