Array ( [racecarsite] => [pppcarsite] => [statusvalue] => for sale [mode] => public [action] => display [userid] => [username] => [display] => displaywide [query] => [selected_stock_no] => ) SELECT year, make, model, package, body_style, VIN, stock_no, conversion, class_prep, car_number, exterior_color, interior_color, contact_name, contact_phone, contact_email, photo_1, photo_2, photo_3, photo_4, photo_5, photo_6, photo_7, photo_8, photo_9, photo_10, photo_11, photo_12, photo_13, photo_14, display_field FROM racecarinv where upper(racecarwebsite)='YES' and status='for sale' order by lpad(display_order,10,' ')

Car Inventory
mode: [ public ] status: [ for sale ] stock no: [ ] website: [ phoenixperformance.net ] action: [ display ] display format: [ displaywide ] query type: [ summary ] userid: [ : ]

year:2002 make:Chevrolet model:Z06 package:T-2 or spec Corvette Race car body_style:Under construction stock_no:1659451611 conversion:T-1, T-2, Spec Corvette class_prep:T-1, T-2, Spec Corvette car_number:TBD exterior_color:Torch red interior_color:Torch red contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com	year:2016 make:Chevrolet model:Camaro stock_no:1662091903 class_prep:SCCA T1/T2 contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com	year:2013 make:Toyota/Scion model:86 body_style:coupe stock_no:1663041423 class_prep:T-4 car_number:31 exterior_color:white interior_color:gray contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com
year:2014 make:Ford model:Mustang body_style:coupe stock_no:1664159416 exterior_color:black interior_color:red contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com	year:2008 make:Chevrolet model:C6 Z06 stock_no:1678325142 exterior_color:black contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com	year:2010 make:Chevrolet model:Corvette package:Grand Sport (C6) body_style:coupe stock_no:1678326009 contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com
year:2007 make:Chevrolet model:Corvette body_style:coupe stock_no:1478622046 class_prep:SCCA T-1 exterior_color:black contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com	year:2017 make:Toyota model:86 stock_no:1661569650 class_prep:T-4 car_number:33 exterior_color:black contact_name:Joe Aquilante contact_phone:(610) 482-0141 contact_email:JFAPhoenix32@aol.com