Member Info
"); printf("Name: %s %s %s\n
", $myrow["fname"], $myrow["mname"], $myrow["lname"]); printf("Address: %s, %s, %s\n
", $myrow["city"], $myrow["state"], $myrow["country"]); printf("E-mail address: %s\n

", $myrow["email"]); printf("Vehicle Info
"); printf("Model: %s %s\n
", $myrow["year"], $myrow["model"]); printf("Exterior Color: %s\n
", $myrow["ecolor"]); printf("Interior: %s %s\n
", $myrow["icolor"], $myrow["imaterial"] ); printf("Status: %s\n
", $myrow["status"]); printf("Transmisison Type: %s\n
", $myrow["trans"]); printf("Air conditioning (0=no 1=yes): %s\n
", $myrow["ac"]); printf("Sunroof (0=no 1=yes): %s\n
", $myrow["sunroof"]); printf("Limited Slip (0=no 1=yes): %s\n

", $myrow["lslip"]); printf("Modifications Info
"); printf("Engine: %s\n
", $myrow["engine"]); printf("Cam: %s\n
", $myrow["cam"]); printf("Radiator: %s\n
", $myrow["radiator"]); printf("Exhaust: %s\n
", $myrow["exhaust"]); printf("Springs: %s\n
", $myrow["springs"]); printf("Shocks/Struts: %s\n
", $myrow["shocks"]); printf("Swaybars: %s\n
", $myrow["swaybars"]); printf("Strut Tower Brace: %s\n
", $myrow["struttowerbrace"]); printf("Brakes: %s\n
", $myrow["brakes"]); printf("Short shift: %s\n
", $myrow["shortshift"]); printf("Front Spoiler: %s\n
", $myrow["frontspoiler"]); printf("Rear Spoiler: %s\n
", $myrow["rearspoiler"]); printf("Tires: %s\n
", $myrow["tires"]); printf("Wheels: %s\n
", $myrow["wheels"]); printf("Free flow air filter: %s\n
", $myrow["kn"]); printf("Seats: %s\n
", $myrow["seats"]); printf("Other: %s\n
", $myrow["other"]); } else { // show employee list $result = mysql_query("SELECT * FROM member ORDER by lname",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { printf("%s %s
\n", $PHP_SELF, $myrow["ffr"], $myrow["fname"], $myrow["lname"]); } while ($myrow = mysql_fetch_array($result)); } else { // no records to display echo "Sorry, no records were found!"; } } ?>