Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Members poll panel

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