Home >> Cadillac V-Series Tech Center >> Cadillac XLR-V Tech Center >> 2006 Cadillac XLR-V Tech Center >> Vehicle Identification Number Listing – 2006 Cadillac XLR and XLR-V – Step 2

Vehicle Identification Number Listing – 2006 Cadillac XLR and XLR-V – Step 2

<? $sortby = $_POST[“sortby”]; $orderby = $_POST[“orderby”]; if ($action=”Submit”) { /* checking for ascending or descending order */ if ($orderby==”flip”) { $Flop=”DESC”; } else { $Flop=”ASC”; } $output=”table”; /* decode states and then create the states part of the query based on user preferences */ $serials[0]=urldecode($serials[0]); If ($serials[0] !=”ALL”) { $counter=0; $where=”Where id LIKE ‘%$serials[$counter]%’ “; $counter=1; while ($serials[$counter] != $nothing) { $serials[$counter]=urldecode($serials[$counter]); $where .= ” OR id LIKE ‘%$serials[$counter]%’ “; $counter=$counter+1; } } /* this is the easier-to-read-but-harder-to-sort output */ if ($outputby==”normal”) { $mysql_link = mysql_connect(“localhost”,”cadillac”,”FzUGTw8bvK”); mysql_select_db(“cadillac_production”, $mysql_link); $query = “SELECT * From xlr_prod $where ORDER BY $sortby $Flop”; $mysql_result = mysql_query($query, $mysql_link); /* this loops through the results of the query */ $counter=1; while($row = (mysql_fetch_array($mysql_result))) { /* if Order by is equal to SATV or SATM or ACT or DEBT or Cost, skip schools that do not offer the information */ /* end of while loop */ } } /* the one line per state output begins here */ else { /* ################## BEGIN ROW WITH ARROWS ##################### */ print ”

Below are the results of your search. These numbers came from the Bowling Green Corvette/ XLR Assembly Plant.

Legend:

  • PVI- Primary Vehicle Identifier:  Also known as the \”Job Number\” – The number assigned to the vehicle while being built and prior to the VIN.
  • Model Numbers:  The \”V\” (6YV67) was the base XLR and the \”X\” (6YX67) was for the XLR-V. Looking at the numbers, the first production XLR-V seems to have the VIN of #507. (NOTE: There were many pre-production with the VIN ending with EX.)

<

“; /* ######################## END ROW WITH ARROWS ############################## */ /* ######################## BEGIN HEADER ROW ################################# */ print “”; print “”; print “”; print “”; print “”; print “”; print “”; print “”; print “”; print “”; /* ######################## END HEADER ROW ################################# */ $mysql_link = mysql_connect(“localhost”,”cadillac”,”FzUGTw8bvK”); mysql_select_db(“cadillac_production”, $mysql_link); $query = “SELECT * From xlr_prod $where ORDER BY id”; $mysql_result = mysql_query($query, $mysql_link); while($row = (mysql_fetch_array($mysql_result))) { if ($counter % 2) { /* if it is even, make the row’s background color white */ print “”; } else { /* if it is odd, make it light gray */ print “”; } print “”; $counter=$counter+1; } } $counter=0; print ”

“; /* ######################## SELLING DIVISION ################################# */ /* down arrow */ /* $sendcode= “sortby=sellingdiv&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=sellingdiv&orderby=flip&action=Submit”; print “\"Sort“; print ”

“; /* ######################## ORDER NUMBER ################################# */ /* down arrow */ /* $sendcode= “sortby=ordernumber&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=ordernumber&orderby=flip&action=Submit”; print “\"Sort“; print “ “; /* ######################## PVI NUMBER ################################# */ /* down arrow */ /* $sendcode= “sortby=pvinumber&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=pvinumber&orderby=flip&action=Submit”; print “\"Sort“; print “ “; /* ######################## MODEL ################################# */ /* down arrow */ /* $sendcode= “sortby=model&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=model&orderby=flip&action=Submit”; print “\"Sort“; print “ “; /* ######################## CHARGE NUMBER ################################# */ /* down arrow */ /* $sendcode= “sortby=charge&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=charge&orderby=flip&action=Submit”; print “\"Sort“; print “ “; /* ######################## SHIPPING NUMBER ################################# */ /* down arrow */ /* $sendcode= “sortby=ship&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=ship&orderby=flip&action=Submit”; print “\"Sort“; print “ “; /* ######################## VIN ################################# */ /* down arrow */ /* $sendcode= “sortby=vin&orderby=flop&action=Submit”; print “\"Sort  “; /* up arrow */ /* $sendcode= “sortby=vin&orderby=flip&action=Submit”; print “\"Sort“; print “
Selling Division Order Number PVI Number Model Charge to Dealer Number Ship to Dealer Number VIN
# “; print $row[id]; print “ “; print $row[sellingdiv]; print “ “; print $row[ordernumber]; print “ “; print $row[pvinumber]; print “ “; print $row[model]; print “ “; print $row[charge]; print “ “; print $row[ship]; print “ “; print $row[vin]; print “

“; } ?>