Can I add more to this Database?

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, …

the semi-colon

:slight_smile:

Thank you r937 :slight_smile: