Wabash National's 53-foot RoadRailer®
Plate Trailers - 3 Rail Version
Official authorized model. Fully assembled. Made in the USA.
// June 7, 2004 - Copyright © 2004 - Delorey Consulting Group - All rights reserved.
#--------------------------------------------------------------------------------------------------------------------------
# Alias Fieldname Width Description Example
# --------- ----------- ----- -------------------------------------------------- ---------------------------
$tablefield1="ind"; # 018, bowser.ind AS ind, Unique part number (i.e., vnr+pn+drop_nr)
$tablefield2="vnr"; # 016, bowser.vnr AS vnr, Vendor number
$tablefield3="pn"; # 016, bowser.pn AS pn, Part number
$tablefield4="drop_nr"; # 016, bowser.drop_nr AS drop_nr, Manual entry to make 'ind' unique
$tablefield5="vendor"; # 080, bowser.vendor AS vendor, Vendor text name
$tablefield6="descr"; # 100, bowser.desc AS [desc], Part description
$tablefield7="price"; # 012, bowser.price AS price, Retail price [decimal 9,2]
$tablefield8="extprice"; # 012, bowser.extprice AS extprice, Extended price [not populated] [decimal 9,2]
$tablefield9="f1"; # 012, bowser.f1 AS f1, Not used
$tablefield10="inventory"; # 024, bowser.inventory AS inventory, Count in inventory
$tablefield11="type"; # 080, bowser.type AS type, Web page destination code(s)
$tablefield12="dir"; # 064, bowser.dir AS dir, Directory of image, document or URL
$tablefield13="image"; # 064, bowser.image AS [image], Name of image, document or URL
$tablefield14="extension"; # 064, bowser.extension AS extension, Extension of image,document or URL
$tablefield15="nrpieces"; # 012, bowser.nrpieces AS nrpieces, Number of pieces in an assembly [i.e., 'type']
$tablefield16="group"; # 080, bowser.group AS [group], Group (e.g., L-1, K-4)
$tablefield17="type_alt"; # 080, bowser.type_alt AS type_alt, Ancillary to 'type'
$tablefield18="comments"; # 080, bowser.comments AS comments, Comments
$tablefield19="dx"; # 012, bowser.dx AS dx, Used for various internal calculations
$tablefield20="dy"; # 012, bowser.dy AS dy Used for various internal calculations
#--------------------------------------------------------------------------------------------------------------------------
# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
# Host: 10.0.6.3
# Generation Time: May 16, 2005 at 04:20 PM
# Server version: 4.0.24
# PHP Version: 4.3.2
# Database : `ddelorey`
# --------------------------------------------------------
/*
CREATE TABLE table8 (
ind varchar(18) NOT NULL default '',
vnr varchar(16) NOT NULL default '',
pn varchar(16) NOT NULL default '',
drop_nr varchar(16) NOT NULL default '',
vendor varchar(80) NOT NULL default '',
descr varchar(100) NOT NULL default '',
price decimal(9,2) NOT NULL default '0.00',
extprice decimal(9,2) NOT NULL default '0.00',
f1 varchar(12) NOT NULL default '',
inventory varchar(24) NOT NULL default '',
type varchar(80) NOT NULL default '',
dir varchar(64) NOT NULL default '',
image varchar(64) NOT NULL default '',
extension varchar(64) NOT NULL default '',
nrpieces varchar(12) NOT NULL default '',
group varchar(80) NOT NULL default '',
type_alt varchar(80) NOT NULL default '',
comments varchar(80) NOT NULL default '',
dx varchar(12) NOT NULL default '',
dy varchar(12) NOT NULL default '',
PRIMARY KEY (ind)
) TYPE=MyISAM COMMENT='Bowser Inventory Table';
*/
#--------------------------------------------------------------------------------------------------------------------------
$usertable="table8";
$tablename="Bowser Inventory Table";
$createtable="create table `".$usertable."` (
`$tablefield1` varchar( 18 ) not null ,
`$tablefield2` varchar( 16 ) not null ,
`$tablefield3` varchar( 16 ) not null ,
`$tablefield4` varchar( 16 ) not null ,
`$tablefield5` varchar( 80 ) not null ,
`$tablefield6` varchar( 100 ) not null ,
`$tablefield7` decimal( 9, 2 ) not null ,
`$tablefield8` decimal( 9, 2 ) not null ,
`$tablefield9` varchar( 12 ) not null ,
`$tablefield10` varchar( 24 ) not null ,
`$tablefield11` varchar( 80 ) not null ,
`$tablefield12` varchar( 64 ) not null ,
`$tablefield13` varchar( 64 ) not null ,
`$tablefield14` varchar( 64 ) not null ,
`$tablefield15` varchar( 12 ) not null ,
`$tablefield16` varchar( 80 ) not null ,
`$tablefield17` varchar( 80 ) not null ,
`$tablefield18` varchar( 80 ) not null ,
`$tablefield19` varchar( 12 ) not null ,
`$tablefield20` varchar( 12 ) not null ,
primary key ( `$tablefield1` )
) comment = '$tablename';";
#--------------------------------------------------------------------------------------------------------------------------
$maxrecs = 7000;
$inpfield=$tablefield11; ## tablefield11 = "type"
$inpquery="SELECT * FROM ".$usertable." WHERE UPPER(".$inpfield.") LIKE UPPER('%".$inpval."%') LIMIT 0,".$maxrecs;
#-------------------------------------------------------------------------------------------------------------------------- ?>
Coupler Mate ™
Note that only one Coupler Mate™ is needed to make a train. This is the
front unit that couples the RoadRailer cars to the train. Includes operating
knuckle coupler.
Wabash National's 53-foot RoadRailer®
Plate Trailers - 2 Rail w/ Scale Wheels
// June 7, 2004 - Copyright © 2004 - Delorey Consulting Group - All rights reserved.
#--------------------------------------------------------------------------------------------------------------------------
# Alias Fieldname Width Description Example
# --------- ----------- ----- -------------------------------------------------- ---------------------------
$tablefield1="ind"; # 018, bowser.ind AS ind, Unique part number (i.e., vnr+pn+drop_nr)
$tablefield2="vnr"; # 016, bowser.vnr AS vnr, Vendor number
$tablefield3="pn"; # 016, bowser.pn AS pn, Part number
$tablefield4="drop_nr"; # 016, bowser.drop_nr AS drop_nr, Manual entry to make 'ind' unique
$tablefield5="vendor"; # 080, bowser.vendor AS vendor, Vendor text name
$tablefield6="descr"; # 100, bowser.desc AS [desc], Part description
$tablefield7="price"; # 012, bowser.price AS price, Retail price [decimal 9,2]
$tablefield8="extprice"; # 012, bowser.extprice AS extprice, Extended price [not populated] [decimal 9,2]
$tablefield9="f1"; # 012, bowser.f1 AS f1, Not used
$tablefield10="inventory"; # 024, bowser.inventory AS inventory, Count in inventory
$tablefield11="type"; # 080, bowser.type AS type, Web page destination code(s)
$tablefield12="dir"; # 064, bowser.dir AS dir, Directory of image, document or URL
$tablefield13="image"; # 064, bowser.image AS [image], Name of image, document or URL
$tablefield14="extension"; # 064, bowser.extension AS extension, Extension of image,document or URL
$tablefield15="nrpieces"; # 012, bowser.nrpieces AS nrpieces, Number of pieces in an assembly [i.e., 'type']
$tablefield16="group"; # 080, bowser.group AS [group], Group (e.g., L-1, K-4)
$tablefield17="type_alt"; # 080, bowser.type_alt AS type_alt, Ancillary to 'type'
$tablefield18="comments"; # 080, bowser.comments AS comments, Comments
$tablefield19="dx"; # 012, bowser.dx AS dx, Used for various internal calculations
$tablefield20="dy"; # 012, bowser.dy AS dy Used for various internal calculations
#--------------------------------------------------------------------------------------------------------------------------
# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
# Host: 10.0.6.3
# Generation Time: May 16, 2005 at 04:20 PM
# Server version: 4.0.24
# PHP Version: 4.3.2
# Database : `ddelorey`
# --------------------------------------------------------
/*
CREATE TABLE table8 (
ind varchar(18) NOT NULL default '',
vnr varchar(16) NOT NULL default '',
pn varchar(16) NOT NULL default '',
drop_nr varchar(16) NOT NULL default '',
vendor varchar(80) NOT NULL default '',
descr varchar(100) NOT NULL default '',
price decimal(9,2) NOT NULL default '0.00',
extprice decimal(9,2) NOT NULL default '0.00',
f1 varchar(12) NOT NULL default '',
inventory varchar(24) NOT NULL default '',
type varchar(80) NOT NULL default '',
dir varchar(64) NOT NULL default '',
image varchar(64) NOT NULL default '',
extension varchar(64) NOT NULL default '',
nrpieces varchar(12) NOT NULL default '',
group varchar(80) NOT NULL default '',
type_alt varchar(80) NOT NULL default '',
comments varchar(80) NOT NULL default '',
dx varchar(12) NOT NULL default '',
dy varchar(12) NOT NULL default '',
PRIMARY KEY (ind)
) TYPE=MyISAM COMMENT='Bowser Inventory Table';
*/
#--------------------------------------------------------------------------------------------------------------------------
$usertable="table8";
$tablename="Bowser Inventory Table";
$createtable="create table `".$usertable."` (
`$tablefield1` varchar( 18 ) not null ,
`$tablefield2` varchar( 16 ) not null ,
`$tablefield3` varchar( 16 ) not null ,
`$tablefield4` varchar( 16 ) not null ,
`$tablefield5` varchar( 80 ) not null ,
`$tablefield6` varchar( 100 ) not null ,
`$tablefield7` decimal( 9, 2 ) not null ,
`$tablefield8` decimal( 9, 2 ) not null ,
`$tablefield9` varchar( 12 ) not null ,
`$tablefield10` varchar( 24 ) not null ,
`$tablefield11` varchar( 80 ) not null ,
`$tablefield12` varchar( 64 ) not null ,
`$tablefield13` varchar( 64 ) not null ,
`$tablefield14` varchar( 64 ) not null ,
`$tablefield15` varchar( 12 ) not null ,
`$tablefield16` varchar( 80 ) not null ,
`$tablefield17` varchar( 80 ) not null ,
`$tablefield18` varchar( 80 ) not null ,
`$tablefield19` varchar( 12 ) not null ,
`$tablefield20` varchar( 12 ) not null ,
primary key ( `$tablefield1` )
) comment = '$tablename';";
#--------------------------------------------------------------------------------------------------------------------------
$maxrecs = 7000;
$inpfield=$tablefield11; ## tablefield11 = "type"
$inpquery="SELECT * FROM ".$usertable." WHERE UPPER(".$inpfield.") LIKE UPPER('%".$inpval."%') LIMIT 0,".$maxrecs;
#-------------------------------------------------------------------------------------------------------------------------- ?>
|