Hello,
Below is the code to create and populate a database,
I would like to add more (11, & (12,
What is the limiting factor, what indicates how many Values I can have?
…
$db_desc = “Creating <b>payment_options</b> table”;
$db_query = “CREATE TABLE " . DB_PREFIX . "payment_options
(
id
int(11) NOT NULL auto_increment,
name
varchar(100) NOT NULL default ‘’,
logo_url
varchar(255) NOT NULL default ‘’,
PRIMARY KEY (id
)
) ENGINE=MyISAM COMMENT=‘Table with payment methods’ AUTO_INCREMENT=11 ;”;
$db_desc = “Populating <b>payment_options</b> table”;
$db_query = “INSERT INTO " . DB_PREFIX . "payment_options
VALUES
(4, ‘Cash Sale’, ‘uplimg/img_CashSale.png’),
(5, ‘PayPal’, ‘uplimg/img_PayPal.png’),
(6, ‘Bangkok Bank’, ‘uplimg/img_BangkokBank.png’),
(7, ‘TMB Bank’, ‘uplimg/img_TMBBank.png’),
(8, ‘KasiKorn Bank’, ‘uplimg/img_KasiKornBank.png’),
(9, ‘Ayudhya Bank’, ‘uplimg/img_AyudhyaBank.png’),
(10, ‘Siam Commercial Bank’, ‘uplimg/img_SiamCommecialBank.png’);”;
(11, …
(12, …