Parašė Lietuvos_pilietis· 2008 Rugs. 5 12:09:29
#14
member pollsql cia jo? man sql neideda kazko...
Create database tables.
$inf_newtable_[1] = "ip_polls (
poll_id smallint(5) unsigned NOT NULL auto_increment,
poll_title varchar(200) NOT NULL default '',
poll_opt_0 varchar(200) NOT NULL default '',
poll_opt_1 varchar(200) NOT NULL default '',
poll_opt_2 varchar(200) NOT NULL default '',
poll_opt_3 varchar(200) NOT NULL default '',
poll_opt_4 varchar(200) NOT NULL default '',
poll_opt_5 varchar(200) NOT NULL default '',
poll_opt_6 varchar(200) NOT NULL default '',
poll_opt_7 varchar(200) NOT NULL default '',
poll_opt_8 varchar(200) NOT NULL default '',
poll_opt_9 varchar(200) NOT NULL default '',
poll_votes_0 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_1 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_2 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_3 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_4 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_5 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_6 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_7 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_8 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_9 smallint(5) unsigned NOT NULL NULL default '0',
poll_ips text NOT NULL default '',
poll_started int(10) unsigned NOT NULL default '',
poll_ended int(10) unsigned NOT NULL default '0',
PRIMARY KEY (poll_id)
) TYPE=MyISAM;";
Per sql kaip teisynga forma turetu ardoditi kad pavyktu ja tiesiogiai idet?
Create tables
"ip_polls (
poll_id smallint(5) unsigned NOT NULL auto_increment,
poll_title varchar(200) NOT NULL default '',
poll_opt_0 varchar(200) NOT NULL default '',
poll_opt_1 varchar(200) NOT NULL default '',
poll_opt_2 varchar(200) NOT NULL default '',
poll_opt_3 varchar(200) NOT NULL default '',
poll_opt_4 varchar(200) NOT NULL default '',
poll_opt_5 varchar(200) NOT NULL default '',
poll_opt_6 varchar(200) NOT NULL default '',
poll_opt_7 varchar(200) NOT NULL default '',
poll_opt_8 varchar(200) NOT NULL default '',
poll_opt_9 varchar(200) NOT NULL default '',
poll_votes_0 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_1 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_2 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_3 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_4 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_5 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_6 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_7 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_8 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_9 smallint(5) unsigned NOT NULL NULL default '0',
poll_ips text NOT NULL default '',
poll_started int(10) unsigned NOT NULL default '',
poll_ended int(10) unsigned NOT NULL default '0',
PRIMARY KEY (poll_id)
) TYPE=MyISAM;";
Bet kažko nepavyksta...
Redagavo Lietuvos_pilietis· 2008 Rugs. 5 13:09:27