NEW!! NEW!!
NEW!!
CD Catalog
CD catalog has 1,000's of photos of Bowser products
plus photos and information about the companies we distribute. Companies
include the following:
// June 7, 2004 - Copyright © 2004 - Delorey Consulting Group - All rights reserved.
#--------------------------------------------------------------------------------------------------------------------------
# Alias Fieldname Width Description Example
# ---------- ----------- ----- -------------------------------------------------- ---------------------------
$tablefield1 = "seq"; # 088, Record count of Vendor in "table8"
$tablefield2 = "account"; # 011, Vendor account number
$tablefield3 = "drop"; # 011, Vendor account drop number [to make unique]
$tablefield4 = "name"; # 088, Name of Vendor
$tablefield5 = "products"; # 088, Text description of product line
$tablefield6 = "url"; # 088, Link to web page (e.g., "http://www.delorey.com"), set default='f006'
$tablefield7 = "url2"; # 030, Link to specials page, set default='f007'
$tablefield8 = "url3"; # 030, Link to suplink page, set default='f008'
$tablefield9 = "active"; # 088, Record active if = "specials", "suplink", "supplier" and/or "dealer", default='f009'
#--------------------------------------------------------------------------------------------------------------------------
# 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 table1 (
seq varchar(12) NOT NULL default '',
account varchar(12) NOT NULL default '',
drop varchar(12) NOT NULL default '',
name varchar(88) NOT NULL default '',
products varchar(88) NOT NULL default '',
url varchar(88) NOT NULL default '',
url2 varchar(30) NOT NULL default '',
url3 varchar(30) NOT NULL default '',
active varchar(88) NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM COMMENT='Bowser Links';
*/
#--------------------------------------------------------------------------------------------------------------------------
$usertable="table1";
$tablename="Bowser Links";
$createtable="create table `".$usertable."` (
`$tablefield1` varchar( 12 ) not null ,
`$tablefield2` varchar( 12 ) not null ,
`$tablefield3` varchar( 12 ) not null ,
`$tablefield4` varchar( 88 ) not null ,
`$tablefield5` varchar( 88 ) not null ,
`$tablefield6` varchar( 88 ) not null ,
`$tablefield7` varchar( 30 ) not null ,
`$tablefield8` varchar( 30 ) not null ,
`$tablefield9` varchar( 88 ) not null ,
primary key ( `$tablefield4` )
) comment = '$tablename';";
#--------------------------------------------------------------------------------------------------------------------------?>Incorrect parameter count in the call to native function 'UPPER' |