Jump to content

Aravinthan

Members
  • Posts

    162
  • Joined

  • Last visited

    Never

Everything posted by Aravinthan

  1. Sorry, I dont know any other solutions... There could be, but that would be suprising as how can you know what filename is already taken or not? They must be stored somewhere... You could try storing them in a text file if you want... But you are complicating your life....
  2. I made a typo, It should be: SELECT * FROM media_cat WHERE name LIKE '[0-9]%' ORDER BY name ASC
  3. Try: SELECT * FROM media_cat WHERE name LIKE [0-9]%' ORDER BY name ASC Should work...
  4. My code is made as I assument that the filenames are stored in the DB... If not it is pratically impossible to make a different name everytime...
  5. Wrong forums... But you can use LIKE command
  6. Assuming that user will always remain user, Try this: // Generate Random Numbers $x = rand(0,100); $y = rand(50,200); $z = rand(200,500); // Put them togther $filename = "user$x$y$z"; // Check to see if file name is taken $sql = "SELECT COUNT(*) FROM `database` WHERE `filename` = '$filename"; $result = mysql_query($sql) or die('Error checking FileName!<br />'.mysql_error()); // If we dont find a filename: if(mysql_num_rows($result) == '0') { // Code when thsi filename is free } else{ // Code when this filename is not free }
  7. I found the error... There was a typo in of the Division name. It works fine now!! Thanks so much for your help!
  8. Too good to last... I changed the Conference to Ouest And the first team 1 is good. Also the 2nd team. But the third team is not good.. He has the same Division as the first, and the 4th placed team has more points than him....
  9. Hi yeah it works!! Thanks so much!
  10. Oh of course, Missed that -.-
  11. OK I got some questions, $news was sent via a form right? If so, Maybe trying sending it via $_Post: $news = $_POST['id_noticia']; And also, Try running this: $updateSQL = "INSERT INTO documentos (id_noticia) VALUES ('Test')"; Just to see...
  12. Also, when you say it is not working... Do you get an error? Or it just doesnt insert the details?
  13. I dont understand... The way you are echoing now Should work, But if not try: <?php echo "" .$profile[username]. ""; ?>
  14. What do you mean? Is this part of a form? or just a plain text? If you want to send form details, you would need the submit button to send them via $_POST
  15. Oh of course!!! I will post some values of the teams tables to if you want? What is a declares? teams: `id` int(11) NOT NULL auto_increment, `nhl_home_wins` int(5) NOT NULL, `nhl_home_loss` int(5) NOT NULL, `nhl_home_ties` int(5) NOT NULL, `nhl_home_ot` int(5) NOT NULL, `nhl_away_wins` int(5) NOT NULL, `nhl_away_loss` int(5) NOT NULL, `nhl_away_ties` int(5) NOT NULL, `nhl_away_ot` int(5) NOT NULL, `ahl_home_wins` int(5) NOT NULL, `ahl_home_loss` int(5) NOT NULL, `ahl_home_ties` int(5) NOT NULL, `ahl_home_ot` int(5) NOT NULL, `ahl_away_wins` int(5) NOT NULL, `ahl_away_loss` int(5) NOT NULL, `ahl_away_ties` int(5) NOT NULL, `ahl_away_ot` int(5) NOT NULL, `nhl_games_played` int(5) NOT NULL, `nhl_wins` int(5) NOT NULL, `nhl_loss` int(5) NOT NULL, `nhl_ot` int(5) NOT NULL, `nhl_ties` int(5) NOT NULL, `nhl_gf` int(5) NOT NULL, `nhl_ga` int(5) NOT NULL, `nhl_power_play_chances` int(5) NOT NULL, `nhl_pk_situations` int(5) NOT NULL, `nhl_ppgf` int(5) NOT NULL, `nhl_pp_ga` int(5) NOT NULL, `human/cpu_switch` int(5) NOT NULL, `playoff_switch` int(5) NOT NULL, `unknown_1` int(5) NOT NULL, `team_funds` int(5) NOT NULL, `team_budgets` int(11) NOT NULL, `ahl_games_played` int(5) NOT NULL, `ahl_wins` int(5) NOT NULL, `ahl_loss` int(5) NOT NULL, `ahl_ot` int(5) NOT NULL, `ahl_ties` int(5) NOT NULL, `ahl_gf` int(5) NOT NULL, `ahl_ga` int(5) NOT NULL, `ahl_power_play_chances` int(5) NOT NULL, `ahl_pk_situations` int(5) NOT NULL, `ahl_ppgf` int(5) NOT NULL, `ahl_ppga` int(5) NOT NULL, `line9` varchar(50) NOT NULL, `nhl_last10` varchar(50) NOT NULL, `ahl_last10` varchar(50) NOT NULL, `gm_name` varchar(50) NOT NULL, `line13` varchar(50) NOT NULL, `line14` varchar(50) NOT NULL, `line15` varchar(50) NOT NULL, `line16` varchar(50) NOT NULL, `line17` varchar(50) NOT NULL, `line18` varchar(50) NOT NULL, `line19` varchar(50) NOT NULL, `line20` varchar(50) NOT NULL, `most_goals` int(5) NOT NULL, `most_goals_name(season)` varchar(500) NOT NULL, `most_assists` int(5) NOT NULL, `most_assists_name(season)` varchar(500) NOT NULL, `most_points` int(5) NOT NULL, `most_points_name(season)` varchar(5000) NOT NULL, `most_rookie_points` int(5) NOT NULL, `most_rookie_points_name(season)` varchar(500) NOT NULL, `most_penalty` int(5) NOT NULL, `most_penalty_name(season)` varchar(500) NOT NULL, `stanley_cups` varchar(500) NOT NULL, `nhl_starting_goaler` int(5) NOT NULL, `nhl_backup_goaler` int(5) NOT NULL, `nhl_defense1` int(5) NOT NULL, `nhl_defense3` int(5) NOT NULL, `nhl_defense5` int(5) NOT NULL, `nhl_defense2` int(5) NOT NULL, `nhl_defense4` int(5) NOT NULL, `nhl_defense6` int(5) NOT NULL, `nhl_left_wing1` int(5) NOT NULL, `nhl_left_wing2` int(5) NOT NULL, `nhl_left_wing3` int(5) NOT NULL, `nhl_left_wing4` int(5) NOT NULL, `nhl_center1` int(5) NOT NULL, `nhl_center2` int(5) NOT NULL, `nhl_center3` int(5) NOT NULL, `nhl_center4` int(5) NOT NULL, `nhl_right_wing1` int(5) NOT NULL, `nhl_right_wing2` int(5) NOT NULL, `nhl_right_wing3` int(5) NOT NULL, `nhl_right_wing4` int(5) NOT NULL, `nhl_pp_defense1` int(5) NOT NULL, `nhl_pp_defense2` int(5) NOT NULL, `nhl_pp_lw1` int(5) NOT NULL, `nhl_pp_center1` int(5) NOT NULL, `nhl_pp_rw1` int(5) NOT NULL, `nhl_pp_defense3` int(5) NOT NULL, `nhl_pp_defense4` int(5) NOT NULL, `nhl_pp_lw2` int(5) NOT NULL, `nhl_pp_center2` int(5) NOT NULL, `nhl_pp_rw2` int(5) NOT NULL, `nhl_pk_defense1` int(5) NOT NULL, `nhl_pk_defense2` int(5) NOT NULL, `nhl_pk_forward1` int(5) NOT NULL, `nhl_pk_forward2` int(5) NOT NULL, `line66` varchar(50) NOT NULL, `nhl_pk_defense3` int(5) NOT NULL, `nhl_pk_defense4` int(5) NOT NULL, `nhl_pk_forward3` int(5) NOT NULL, `nhl_pk_forward4` int(5) NOT NULL, `line71` varchar(50) NOT NULL, `ahl_starting_goaler` int(5) NOT NULL, `ahl_backup_goaler` int(5) NOT NULL, `ahl_defense1` int(5) NOT NULL, `ahl_defense3` int(5) NOT NULL, `ahl_defense5` int(5) NOT NULL, `ahl_defense2` int(5) NOT NULL, `ahl_defense4` int(5) NOT NULL, `ahl_defense6` int(5) NOT NULL, `ahl_left_wing1` int(5) NOT NULL, `ahl_left_wing2` int(5) NOT NULL, `ahl_left_wing3` int(5) NOT NULL, `ahl_left_wing4` int(5) NOT NULL, `ahl_center1` int(5) NOT NULL, `ahl_center2` int(5) NOT NULL, `ahl_center3` int(5) NOT NULL, `ahl_center4` int(5) NOT NULL, `ahl_right_wing1` int(5) NOT NULL, `ahl_right_wing2` int(5) NOT NULL, `ahl_right_wing3` int(5) NOT NULL, `ahl_right_wing4` int(5) NOT NULL, `ahl_pp_defense1` int(5) NOT NULL, `ahl_pp_defense2` int(5) NOT NULL, `ahl_pp_lw1` int(5) NOT NULL, `ahl_pp_center1` int(5) NOT NULL, `ahl_pp_rw1` varchar(50) NOT NULL, `ahl_pp_defense3` int(5) NOT NULL, `ahl_pp_defense4` int(5) NOT NULL, `ahl_pp_lw2` int(5) NOT NULL, `ahl_pp_center2` int(5) NOT NULL, `ahl_pp_rw2` varchar(50) NOT NULL, `ahl_pk_defense1` int(5) NOT NULL, `ahl_pk_defense2` int(5) NOT NULL, `ahl_pk_forward1` int(5) NOT NULL, `ahl_pk_forward2` int(5) NOT NULL, `line106` varchar(50) NOT NULL, `ahl_pk_defense3` int(5) NOT NULL, `ahl_pk_defense4` int(5) NOT NULL, `ahl_pk_forward3` int(5) NOT NULL, `ahl_pk_forward4` int(5) NOT NULL, `line111` varchar(50) NOT NULL, `line1_tactics` int(5) NOT NULL, `line2_tactics` int(5) NOT NULL, `line3_tactics` int(5) NOT NULL, `line4_tactics` int(5) NOT NULL, `pp1_tactics` int(5) NOT NULL, `pp2_tactics` int(5) NOT NULL, `pk1_tactics` int(5) NOT NULL, `pk2_tactics` int(5) NOT NULL, `line113` varchar(100) NOT NULL, `line114` varchar(100) NOT NULL, `line115` varchar(100) NOT NULL, `line116` varchar(100) NOT NULL, `line117` varchar(100) NOT NULL, `line1_shift` int(5) NOT NULL, `line2_shift` int(5) NOT NULL, `line3_shift` int(5) NOT NULL, `line4_shift` int(5) NOT NULL, `pp1_shift` int(5) NOT NULL, `pp2_shift` int(5) NOT NULL, `pk1_shift` int(5) NOT NULL, `pk2_shift` int(5) NOT NULL, `line119` varchar(100) NOT NULL, `line120` varchar(100) NOT NULL, `line121` varchar(100) NOT NULL, `line122` varchar(100) NOT NULL, `line123` varchar(100) NOT NULL, `line124` varchar(100) NOT NULL, `line125` varchar(100) NOT NULL, `team_name` varchar(400) NOT NULL, PRIMARY KEY (`id`) INSERT INTO `teams` (`id`, `nhl_home_wins`, `nhl_home_loss`, `nhl_home_ties`, `nhl_home_ot`, `nhl_away_wins`, `nhl_away_loss`, `nhl_away_ties`, `nhl_away_ot`, `ahl_home_wins`, `ahl_home_loss`, `ahl_home_ties`, `ahl_home_ot`, `ahl_away_wins`, `ahl_away_loss`, `ahl_away_ties`, `ahl_away_ot`, `nhl_games_played`, `nhl_wins`, `nhl_loss`, `nhl_ot`, `nhl_ties`, `nhl_gf`, `nhl_ga`, `nhl_power_play_chances`, `nhl_pk_situations`, `nhl_ppgf`, `nhl_pp_ga`, `human/cpu_switch`, `playoff_switch`, `unknown_1`, `team_funds`, `team_budgets`, `ahl_games_played`, `ahl_wins`, `ahl_loss`, `ahl_ot`, `ahl_ties`, `ahl_gf`, `ahl_ga`, `ahl_power_play_chances`, `ahl_pk_situations`, `ahl_ppgf`, `ahl_ppga`, `line9`, `nhl_last10`, `ahl_last10`, `gm_name`, `line13`, `line14`, `line15`, `line16`, `line17`, `line18`, `line19`, `line20`, `most_goals`, `most_goals_name(season)`, `most_assists`, `most_assists_name(season)`, `most_points`, `most_points_name(season)`, `most_rookie_points`, `most_rookie_points_name(season)`, `most_penalty`, `most_penalty_name(season)`, `stanley_cups`, `nhl_starting_goaler`, `nhl_backup_goaler`, `nhl_defense1`, `nhl_defense3`, `nhl_defense5`, `nhl_defense2`, `nhl_defense4`, `nhl_defense6`, `nhl_left_wing1`, `nhl_left_wing2`, `nhl_left_wing3`, `nhl_left_wing4`, `nhl_center1`, `nhl_center2`, `nhl_center3`, `nhl_center4`, `nhl_right_wing1`, `nhl_right_wing2`, `nhl_right_wing3`, `nhl_right_wing4`, `nhl_pp_defense1`, `nhl_pp_defense2`, `nhl_pp_lw1`, `nhl_pp_center1`, `nhl_pp_rw1`, `nhl_pp_defense3`, `nhl_pp_defense4`, `nhl_pp_lw2`, `nhl_pp_center2`, `nhl_pp_rw2`, `nhl_pk_defense1`, `nhl_pk_defense2`, `nhl_pk_forward1`, `nhl_pk_forward2`, `line66`, `nhl_pk_defense3`, `nhl_pk_defense4`, `nhl_pk_forward3`, `nhl_pk_forward4`, `line71`, `ahl_starting_goaler`, `ahl_backup_goaler`, `ahl_defense1`, `ahl_defense3`, `ahl_defense5`, `ahl_defense2`, `ahl_defense4`, `ahl_defense6`, `ahl_left_wing1`, `ahl_left_wing2`, `ahl_left_wing3`, `ahl_left_wing4`, `ahl_center1`, `ahl_center2`, `ahl_center3`, `ahl_center4`, `ahl_right_wing1`, `ahl_right_wing2`, `ahl_right_wing3`, `ahl_right_wing4`, `ahl_pp_defense1`, `ahl_pp_defense2`, `ahl_pp_lw1`, `ahl_pp_center1`, `ahl_pp_rw1`, `ahl_pp_defense3`, `ahl_pp_defense4`, `ahl_pp_lw2`, `ahl_pp_center2`, `ahl_pp_rw2`, `ahl_pk_defense1`, `ahl_pk_defense2`, `ahl_pk_forward1`, `ahl_pk_forward2`, `line106`, `ahl_pk_defense3`, `ahl_pk_defense4`, `ahl_pk_forward3`, `ahl_pk_forward4`, `line111`, `line1_tactics`, `line2_tactics`, `line3_tactics`, `line4_tactics`, `pp1_tactics`, `pp2_tactics`, `pk1_tactics`, `pk2_tactics`, `line113`, `line114`, `line115`, `line116`, `line117`, `line1_shift`, `line2_shift`, `line3_shift`, `line4_shift`, `pp1_shift`, `pp2_shift`, `pk1_shift`, `pk2_shift`, `line119`, `line120`, `line121`, `line122`, `line123`, `line124`, `line125`, `team_name`) VALUES (1, 11, 4, 0, 2, 10, 9, 0, 1, 10, 2, 4, 1, 5, 10, 5, 0, 37, 21, 13, 3, 0, 88, 84, 123, 109, 24, 24, 1, 1, 10, -878176, 65740834, 37, 15, 12, 1, 9, 78, 70, 92, 86, 16, 12, '22 17 134', 'WWWWWLLLWOWWTLLWWWLWWLTTLOWLWLLLLTWWT', 'LOTWLLTWWWWTLTLWWLWWTTTLWWTWLLLLLTWWW', 'ANA', '263 263 263 977', '133 133 133 0', '1037 1037 1037 929', '230 230 230 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 52, 'Teemu Selanne (1997-98)', 62, 'Paul Kariya (1998-99)', 109, 'Teemu Selanne (1996-97)', 39, 'Paul Kariya (1994-95)', 285, 'Todd Ewen (1995-96)', '', 16, 524, 677, 2268, 1766, 623, 725, 2476, 633, 2908, 2841, 1594, 2575, 280, 687, 568, 1042, 1440, 1333, 386, 2268, 623, 633, 2575, 1042, 677, 1766, 1594, 568, 386, 623, 677, 280, 2575, '16', 725, 2476, 2841, 687, '16', 1434, 2974, 851, 396, 975, 2521, 1029, 1609, 684, 2307, 2781, 921, 2375, 139, 700, 2279, 2562, 2212, 3058, 341, 975, 396, 2307, 2375, '2562', 2521, 1029, 2781, 139, '3058', 851, 2521, 684, 341, '1434', 975, 396, 2212, 921, '1434', 1, 1, 4, 3, 0, 1, 4, 3, '1649 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 6, 6, 5, 2, 8, 4, 8, 4, '0 0 0 1 2', '0 0 50000 75000 3', '750000 6590000 3 4 5', '0 0 9450000 3300000 0', '-878176 65740834 65', '0 9358817', '623 278', 'Anaheim Ducks'), (2, 6, 9, 0, 3, 7, 10, 0, 3, 10, 6, 2, 0, 5, 14, 1, 0, 38, 13, 19, 6, 0, 91, 108, 137, 148, 25, 32, 1, 0, 40, 4508780, 52900927, 38, 15, 20, 0, 3, 87, 112, 57, 115, 9, 24, '19 19 100', 'LLLLLWLLLWLTLTLTTLLWLLWWLLWOLWTTLWWWWW', 'LLLLLWLLLLLTLLWWWLWWWWWWWWWLLTLLLWWLTL', 'ATL', '1035 1035 1035 997', '19 19 19 0', '1074 1074 1074 826', '0 0 0 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 32, 'Donald Audette (2000-01)', 47, 'Ray Ferraro (2000-01)', 50, 'Ray Ferraro (2000-01)', 27, 'Tomi Kallio (2000-01)', 226, 'Jeff Odgers (2000-01)', '', 3149, 729, 316, 2319, 272, 21, 1587, 1936, 113, 1612, 327, 65, 2725, 636, 616, 2234, 307, 885, 1047, 1796, 316, 1587, 1612, 636, 885, 2319, 1936, 113, 2725, 616, 272, 21, 636, 327, '3149', 2319, 316, 1796, 616, '3149', 1006, 1699, 1662, 1345, 1788, 3124, 3035, 1509, 328, 85, 2998, 3447, 2711, 2829, 3140, 2883, 1142, 25, 2747, 2955, 1662, 3124, 328, 2711, '25', 1509, 3035, 2998, 2829, '1142', 1662, 3124, 85, 2711, '1006', 1788, 1345, 2955, 328, '1006', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '0 0 0 1 2', '0 0 50000 75000 2', '400000 6940000 3 4 5', '0 0 9450000 3375000 2', '4508780 52900927 65', '0 8441215', '616 85', 'Atlanta Thrashers'), (3, 8, 9, 0, 3, 6, 11, 0, 2, 14, 5, 1, 0, 9, 7, 3, 0, 39, 14, 20, 5, 0, 86, 105, 143, 131, 32, 26, 1, 0, 10, -1769414, 59633054, 39, 23, 12, 0, 4, 80, 66, 98, 109, 15, 17, '22 18 102', 'LWLLLLLLWWWOWWWLLLLLWLLTLTWLLWTTWTLTLWL', 'WLWWLTWTWLWWTWWWLWWWLWWWLWLLTLWWWLLWWLW', 'BOS', '1030 1030 1030 1046', '451 451 451 0', '702 702 702 1033', '329 329 329 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 76, 'Phil Esposito (1970-71)', 102, 'Bobby Orr (1970-71)', 152, 'Phil Esposito (1970-71)', 102, 'Joe Juneau (1992-93)', 302, 'Jay Miller (1987-88)', '1929, 1939, 1941, 1970, 1972', 747, 1372, 263, 1330, 1757, 712, 2297, 559, 1639, 1285, 563, 2089, 872, 1836, 1754, 185, 93, 2574, 2620, 1726, 263, 712, 1639, 872, 93, 1757, 2297, 1285, 2574, 2089, 263, 712, 185, 2574, '747', 559, 1330, 1285, 1639, '747', 650, 2696, 514, 780, 3039, 347, 2184, 663, 281, 1247, 569, 1236, 1154, 2999, 2147, 58, 3299, 1462, 2662, 3298, 347, 663, 1247, 1154, '3299', 2184, 3039, 281, 58, '2662', 514, 347, 281, 1154, '650', 780, 2184, 1462, 569, '650', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '0 0 0 1 2', '0 0 50000 75000 3', '300000 7980000 3 4 5', '0 0 9450000 3450000 2', '-1769414 59633054 65', '0 10726138', '263 58', 'Boston Bruins'), (4, 13, 4, 0, 3, 7, 9, 0, 2, 9, 10, 1, 0, 4, 13, 1, 0, 38, 20, 13, 5, 0, 98, 103, 132, 125, 26, 28, 1, 1, 40, 7622660, 58255757, 38, 13, 23, 0, 2, 67, 104, 100, 92, 21, 20, '23 19 122', 'WLTWOWOLLLWTLTWLLTWWWWLLLLTWLWTTWWTWLT', 'LLLLLLLLLLWTWTLWWLWLLLLLWWWWLWLLWLWLLW', 'BUF', '635 635 635 647', '840 840 840 0', '408 408 408 1038', '201 201 201 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 76, 'Alexander Mogilny (1992-93)', 95, 'Pat LaFontaine (1992-93)', 148, 'Pat LaFontaine (1992-93)', 74, 'Rick Martin (1971-72)', 354, 'Rob Ray (1991-92)', '', 1016, 241, 818, 398, 488, 1584, 2050, 2058, 3489, 7, 2139, 2669, 183, 1795, 793, 661, 2156, 2569, 3478, 834, 818, 2050, 3489, 183, 2156, 2058, 398, 7, 1795, 2569, 1584, 2058, 2139, 793, '1016', 488, 2050, 2569, 661, '1016', 1218, 2689, 653, 2825, 353, 2, 3085, 3024, 2726, 3037, 948, 1557, 3387, 1413, 3011, 3380, 2235, 1480, 3158, 3248, 2825, 3085, 2726, 1413, '1480', 353, 2, 948, 3380, '3158', 653, 2, 2235, 2726, '1218', 353, 2825, 1480, 3248, '1218', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '50000 0 0 1 2', '0 0 50000 75000 2', '750000 7110000 3 4 5', '0 0 9450000 3375000 3', '7622660 58255757 65', '584997 12616436', '398 3246', 'Buffalo Sabres'), (5, 13, 3, 0, 3, 11, 8, 0, 1, 11, 6, 2, 0, 9, 7, 4, 0, 39, 24, 11, 4, 0, 83, 64, 113, 82, 15, 10, 1, 1, 40, 2444478, 66665556, 39, 20, 13, 0, 6, 97, 69, 92, 89, 22, 15, '23 13 156', 'WWWWWWWWWLWWWLWWWLWTWTLWLLLLTWTLLWOWLWT', 'WWLTWWTWWLWWLLLLTTWWLWWLLWWWWLTLLTWLWWW', 'CGY', '792 792 792 502', '465 465 465 0', '187 187 187 17', '642 642 642 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 66, 'Lanny McDonald (1982-83)', 82, 'Kent Nilsson (1980-81)', 131, 'Kent Nilsson (1980-81)', 92, 'Joe Nieuwendyk (1987-88)', 375, 'Tim Hunter (1988-89)', '1989', 2222, 674, 79, 3002, 1696, 2003, 2996, 3292, 587, 1416, 1044, 208, 329, 523, 1271, 2566, 120, 1763, 869, 285, 79, 2003, 587, 329, 120, 3292, 3002, 1416, 523, 1763, 79, 1696, 523, 120, '2222', 3292, 3002, 2566, 285, '2222', 2493, 3187, 654, 450, 1433, 555, 174, 3079, 979, 1801, 2964, 809, 1688, 3159, 3360, 2982, 989, 2834, 507, 2770, 555, 174, 979, 1688, '2834', 450, 1433, 1801, 3159, '989', 654, 555, 1688, 809, '2493', 1433, 450, 507, 989, '2493', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '0 0 0 1 2', '0 0 50000 0 2', '900000 7290000 3 4 5', '0 0 9450000 3525000 0', '2444478 66665556 65', '0 12662125', '120 809', 'Calgary Flames'), (6, 13, 6, 0, 1, 12, 5, 0, 2, 13, 7, 0, 0, 2, 17, 0, 0, 39, 25, 11, 3, 0, 103, 80, 120, 95, 24, 13, 1, 1, 0, 3739935, 67838499, 39, 15, 24, 0, 0, 84, 107, 80, 88, 13, 17, '21 19 103', 'WWWWLLLTLWLLWWLWWLOWLWLWWTWWWWWWWTWTWWL', 'LLWLLLLLLLLWLLLLWWWLWWLLWLLWLLWWWLWLLWW', 'CAR', '627 627 627 294', '524 524 524 0', '941 941 941 589', '835 835 835 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 56, 'Blaine Stoughton (1979-80)', 69, 'Ron Francis (1989-90', 105, 'Mike Rogers (1980-81)', 72, 'Sylvain Turgeon (1983-84)', 358, 'Torrie Robertson (1985-86)', '', 1580, 2236, 322, 2009, 604, 51, 1768, 154, 1759, 737, 1797, 1454, 1028, 2555, 19, 2605, 454, 302, 273, 2182, 51, 322, 1797, 2555, 454, 2009, 1768, 737, 1028, 302, 322, 604, 2555, 1759, '1580', 154, 1768, 302, 454, '1580', 369, 1401, 6, 1335, 3366, 2006, 2981, 1363, 1640, 515, 2419, 3372, 1530, 2763, 1062, 1856, 2514, 3185, 822, 1328, 6, 2006, 1640, 2763, '822', 1335, 1363, 2419, 1530, '3185', 6, 2981, 1640, 1530, '369', 1335, 2006, 515, 1062, '369', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '50000 0 0 1 2', '0 0 50000 75000 2', '600000 7870000 3 4 5', '0 0 9450000 3450000 2', '3739935 67838499 65', '531932 10532255', '454 3185', 'Carolina Hurricanes'), (7, 8, 6, 0, 2, 5, 15, 0, 2, 12, 2, 2, 0, 5, 10, 5, 2, 38, 13, 21, 4, 0, 86, 112, 135, 157, 21, 29, 1, 0, 10, 7939797, 63187699, 38, 17, 12, 2, 7, 80, 72, 115, 76, 14, 15, '20 15 137', 'WLWLWWLWLOTLLLTLLLTLLWTLTLLWLWLWLLLWWL', 'WTWWWWWLLTOTLWWWWLLOLLTWWLWWTWTLLLWTWL', 'CHI', '999 999 999 1027', '864 864 864 0', '1026 1026 1026 707', '374 374 374 0', '0 0 0', '0 0 0', '-20 -20', '-20 -20', 58, 'Bobby Hull (1968-69)', 87, 'Denis Savard (1987-88)', 131, 'Denis Savard (1987-88)', 90, 'Steve Larmer (1982-83)', 408, 'Mike Peluso (1991-92)', '1934, 1938, 1961', 1937, 2610, 1569, 2292, 1073, 2573, 103, 2827, 1646, 140, 68, 142, 2577, 393, 325, 1845, 502, 2112, 2850, 2126, 2292, 502, 1646, 2577, 2112, 1569, 103, 140, 325, 2850, 2573, 1569, 1845, 68, '1937', 103, 2292, 2126, 502, '1937', 629, 680, 1818, 1405, 47, 1585, 3326, 365, 142, 1892, 1054, 366, 2907, 1308, 1313, 3115, 1810, 2731, 2483, 266, 1818, 47, 142, 1313, '2731', 365, 3326, 366, 1308, '1810', 1585, 1405, 1054, 1892, '629', 1818, 3326, 2483, 142, '629', 1, 1, 4, 3, 0, 1, 4, 3, '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', '0 0 0 0 0 0 0 0 0 0', 7, 6, 5, 2, 8, 4, 8, 4, '0 0 0 1 2', '0 0 50000 0 2', '350000 6750000 3 4 5', '0 0 9450000 3450000 2', '7939797 63187699 65', '0 10810622', '271 1585', 'Chicago Blackhawks'),
  16. Did you try echoin: $news to see if it echos something?
  17. OK so far I just got the basic -.- <?PHP $file_handle = fopen("reports.txt", "rb"); while (!feof($file_handle) ) { $line_of_text = fgets($file_handle); $parts = explode('/n', $line_of_text); print $parts[0] . $parts[1]. "<BR>"; } fclose($file_handle); ?>
  18. Sorry for posting too many at a time, But I fixed the all the typos. And it doesnt give me any errors, but it doesnt give me any result neither. Here is the fixed up code: SELECT a.*, (CASE WHEN b.scoreMax IS NULL THEN 1 ELSE 2 END) AS SortFiddle FROM (SELECT teams.*, teams_numbers.Divison, ((`nhl_wins` *2) + `nhl_ot`) AS scoreMax FROM teams LEFT JOIN teams_numbers ON teams.team_name = teams_numbers.ProName WHERE teams_numbers.Conference ='Est' AND `Divison` != `Divison` ) a LEFT OUTER JOIN (SELECT Divison, MAX((`nhl_wins` *2) + `nhl_ot`) AS scoreMax FROM teams LEFT JOIN teams_numbers ON teams.team_name = teams_numbers.ProName WHERE teams_numbers.Conference ='Est' AND `Divison` != `Divison` GROUP BY Divison ORDER BY scoreMax LIMIT 3) b ON a.Divison = b.Divison AND a.scoreMax = b.scoreMax ORDER BY SortFiddle, a.scoreMax
  19. team_numbers: `ProName` varchar(100) NOT NULL, `Divison` varchar(50) NOT NULL, `Conference` varchar(50) NOT NULL, `ProAbv` varchar(10) NOT NULL, `ProId` int(11) NOT NULL, `FarmName` varchar(100) NOT NULL, `FarmId` int(11) NOT NULL INSERT INTO `teams_numbers` (`ProName`, `Divison`, `Conference`, `ProAbv`, `ProId`, `FarmName`, `FarmId`) VALUES ('Anaheim Ducks', 'Pacifique', 'Ouest', 'ANA', 1, 'Iowa Chops', 31), ('Atlanta Thrashers', 'Sud-Est', 'Est', 'ATL', 2, 'Chicago Wolves', 32), ('Boston Bruins', 'Nord-Est', 'Est', 'BOS', 3, 'Providence Bruins', 33), ('Buffalo Sabres', 'Nord-Est', 'Est', 'BUF', 4, 'Portland Pirates', 34),
  20. Made a mistake, in my quoute it should say: The D from division is capital.
  21. Still no good... OK I will explain the Tables: Table: teams Table has all the statistics about each team. Wins, loss, points, etc Table: team_numbers Conference -> Est - Ouest Division -> The Division names ProName -> TeamName There is one mistake i saw, its in line 2, where it says Select team, it should teams. I changed that but it doesnt work Error: And I changed every division to Division But still no good...
  22. Did a few changes and this is what I got so far: SELECT a.*, (CASE WHEN b.scoreMax IS NULL THEN 1 ELSE 2 END) AS SortFiddle FROM (SELECT teams.*, ((`nhl_wins` *2) + `nhl_ot`) AS scoreMax FROM teams LEFT JOIN teams_numbers ON teams.team_name = teams_numbers.ProName WHERE teams_numbers.Conference ='Est' AND `divison` != `divison` ) a LEFT OUTER JOIN (SELECT division, MAX((`nhl_wins` *2) + `nhl_ot`) AS scoreMax FROM teams_numbers LEFT JOIN teams_numbers ON teams.team_name = teams_numbers.ProName WHERE teams_numbers.Conference ='Est' AND `divison` != `divison` GROUP BY division ORDER BY scoreMax LIMIT 3) b ON a.division = b.division AND a.scoreMax = b.scoreMax ORDER BY SortFiddle, a.scoreMax But when I run it with Php My Admin I get this error:
  23. Hi thanks so much, I got some questions. First: What do you mean by suffer? Because there is some teams that have the same points... Second: The Division is a colum in the table team_numbers.... So the code doesnt work... I tried changing: SELECT division To: SELECT teams_numbers.division But it returns empy... THanks for your help, Ara
  24. Hi, Keith, Yes I will post the complete standings of my exemple: Team 1 -> Division 1 Team 2 -> Division 2 Team 4 -> Division 3 Team 3 -> Division 2 Team 5 -> Divison 1 Team 6 -> Division 2 Team 7 -> Division 1 Team 8 -> Division 3 Team 9 -> Division 2 ... There is 15 teams in a conference, but you get the idea no? Thanks again for your help, Ara Fenway, I dont understand what you mean.... How to split the top 3 for the divisions ?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.