falck3

Atradu problēmu ) ENGINE = MYISAM AUTO_INCREMENT =1; jābūt Bija ) TYPE = MYISAM AUTO_INCREMENT =1; Viss dēļ tā ka MySQL 5.1 vairs nelieto "TYPE"

Te ir sql kas dod man erroru! Saprotu ka tas varbūt ir dēļ manas sql versijas? ja tā tad kā labot šo sql? -- -- Table structure for table `scraffiliateusr` -- CREATE TABLE `scraffiliateusr` ( `usrid` bigint(20) NOT NULL auto_increment, `usract` int(11) NOT NULL default '0', `usrnam` varchar(100) NOT NULL default '', `usrpwd` varchar(100) NOT NULL default '', `usractkey` varchar(100) NOT NULL default '', `usrip` varchar(100) NOT NULL default '', `usreml` varchar(100) NOT NULL default '', `usrjondtetme` datetime NOT NULL default '0000-00-00 00:00:00', `usrinvby` int(11) NOT NULL default '0', `usrlstvstdtetme` datetime NOT NULL default '0000-00-00 00:00:00', `usrvst` int(11) NOT NULL default '0', `usrvsttdy` int(11) NOT NULL default '0', `usrprflstvstdtetme` datetime NOT NULL default '0000-00-00 00:00:00', `usrprfvst` int(11) NOT NULL default '0', `usrprfvsttdy` int(11) NOT NULL default '0', `usrinvlstsnddtetme` datetime NOT NULL default '0000-00-00 00:00:00', `usrinvsnd` int(11) NOT NULL default '0', `usrinvsndtdy` int(11) NOT NULL default '0', `usrinvurllstclkdtetme` datetime NOT NULL default '0000-00-00 00:00:00', `usrinvurlclk` int(11) NOT NULL default '0', `usrinvurlclktdy` int(11) NOT NULL default '0', `usrinvsndmax` int(11) NOT NULL default '0', `usrpoints` float NOT NULL default '0', `usrpointsindirect` float NOT NULL default '0', `usr24` varchar(100) NOT NULL default '', `usr25` varchar(100) NOT NULL default '', `usr26` varchar(100) NOT NULL default '', `usr27` varchar(100) NOT NULL default '', PRIMARY KEY (`usrid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Dumping data for table `scraffiliateusr` -- INSERT INTO `scraffiliateusr` (`usrid`, `usract`, `usrnam`, `usrpwd`, `usractkey`, `usrip`, `usreml`, `usrjondtetme`, `usrinvby`, `usrlstvstdtetme`, `usrvst`, `usrvsttdy`, `usrprflstvstdtetme`, `usrprfvst`, `usrprfvsttdy`, `usrinvlstsnddtetme`, `usrinvsnd`, `usrinvsndtdy`, `usrinvurllstclkdtetme`, `usrinvurlclk`, `usrinvurlclktdy`, `usrinvsndmax`, `usrpoints`, `usrpointsindirect`, `usr24`, `usr25`, `usr26`, `usr27`) VALUES (1001, 1, 'user', 'password', '', '', '', '0000-00-00 00:00:00', 0, '2008-02-24 19:05:46', 10, 11, '2008-02-24 07:40:54', 2, 1, '2008-02-24 19:06:09', 2, 1, '2008-02-24 17:40:27', 2, 1, 5, 20, 9, '', '', '', ''), (1002, 1, 'user2', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 19:05:58', 4, 8, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 11, 0, '', '', '', ''), (1003, 1, 'user3', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:22:42', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''), (1004, 1, 'user4', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:28:29', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''), (1005, 1, 'user5', 'password', '', '', '', '0000-00-00 00:00:00', 1002, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:29:26', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 10, 0, '', '', '', ''), (1006, 1, 'user6', 'password', '', '', '', '0000-00-00 00:00:00', 1003, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''), (1007, 1, 'user7', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 0, '', '', '', ''), (1008, 1, 'user8', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, 0, '', '', '', ''), (1009, 1, 'user9', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''), (1010, 1, 'user10', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''), (1011, 1, 'user11', 'password', '', '', '', '0000-00-00 00:00:00', 1005, '0000-00-00 00:00:00', 0, 0, '2008-02-20 12:38:26', 0, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 10, 0, '', '', '', ''), (1012, 1, 'user12', 'password', '', '', '', '0000-00-00 00:00:00', 1005, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''), (1013, 1, 'user13', 'password', '', '', '', '0000-00-00 00:00:00', 1008, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 0, 0, '', '', '', ''), (1014, 1, 'user14', 'password', '', '', '', '0000-00-00 00:00:00', 1009, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''), (1015, 1, 'user15', 'password', '', '', '', '0000-00-00 00:00:00', 1014, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, 0, '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `scraffiliateurlclk` -- CREATE TABLE IF NOT EXISTS `scraffiliateurlclk` ( `urlclkid` bigint(20) NOT NULL auto_increment, `urlclkusrid` bigint(20) NOT NULL, `urlclkipaddress` varchar(50) NOT NULL, `urlclktmestmp` varchar(50) NOT NULL default '0', `urlclk4` varchar(50) NOT NULL, PRIMARY KEY (`urlclkid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `scraffiliateurlclk` -- ERRORS: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 35

Varbūt zini kā izvilkt no referrals referāļus kas pievienojās pēdējās 30 dienās? ir colona signup signup int(11) No None

ir int(11) tas slikti?

Paskaidrosi sīkāk?

Username Referrals Admin 2 f1stptcupdate 9 AIS01 1 elena075 12 InternsLink 1 viking88hp 7 kelly998888 99 Ir tā man vaig lai tabulā "Referrals" (tas cipars ir kopējais skaits) skaitu veidotu no useriem kuru id ir lielāks kā 2114

jo būs tāds kā pasākums kurā tiks skaitīti tikai id > ka 2114

kā lai order by referrals bet rādītu tam referrals tos id kas ir tie pēc 2114?

Pamēģināju arī tā! Jā nau errors bet nekārto pēc `referrals`

Lietoju šo SELECT * FROM members ORDER BY `referrals` WHERE `id`>2114 Ir errors : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id`>2114 LIMIT 0, 30' at line 3 Doma parādīt sarakstu ar MEMBERS kuru `referrals` kuru `id` ir lielāks kā 2114 bez ORDER BY `referrals` viss ir ok bet tā nesanāk ko daru nepareizi?? Paldies

Ne datubāzē bet .php $lang['txt']['lastpost'] = 'Last Post'; $lang['txt']['newtopic'] = 'New Topic'; $lang['txt']['back2topic'] = 'Back to Topic'; $lang['txt']['topic'] = 'Topic'; $lang['txt']['moveto'] = 'Move to'; $lang['txt']['topictitle'] = 'Topic Title'; Ja vairākas valodas tad $lang['txt']['topictitle' tūlkos pēc valodas

foreach($lang['txt'] as $k => $v){ $lang['txt'][$k] = utf8_encode($v); } un xml faila ir <?xml version="1.0" encoding="UTF-8"?> home failā bija <meta charset="utf-8"> Uzliku tavu versiju nekas nemainās!

Varbūt mana vaina ka nepieminēju ka runa iet par mājaslapu :D

Sveiki man ir viena problēma un liekas ka pat ar mātes googles palīdzību man nesanāk to atrisināt Problēma ir : Man mājaslapā "Lietotāji Onlainā" rādās kā "Lietotâji Onlainâ" Kur varētu būt problēma? Paldies

kas ir vim?