Aravinthan

I have nothing... I start coding but I hit a wall, and erase that try again, and I hit a wall... I tought of using a code wildteen came up with, but that code uses lines to split... But in this text file, the lines change from 1 game to another... So that really messes me up...

Hi, I am having kinda of an issue. Ok so what I want to do is, show the 8 teams from 1 conference. SO far so good.... Here is the code which does that: SELECT * FROM teams LEFT JOIN teams_numbers ON teams.team_name = teams_numbers.ProName WHERE teams_numbers.Conference ='Est' AND `divison` != `divison` Order by ((`nhl_wins` *2) + `nhl_ot`) DESC But here is the tricky part, There is 3 division in 1 conference. So what I want is: The top 3 teams must not be in teh same division. For exemple: Division 1 Division 2 Division 3 So for exemple the team with the most points, in division 1 will be placed in the top 3 even if the a team that has more points but is 2nd Division 2. I dont know if I am explaining well... For people who know it, its the same as the NHL way of ranking.... Let say there is 15 teams, in 1 conference and 5 teams in each division. Teams(ordered by most points): Team 1 -> Division 1 Team 2 -> Division 2 Team 3 -> Division 2 Team 4 -> Division 3 Team 5 -> Division 1 Team 6 -> Division 2 Team 7 -> Division 1 Team 8 -> Division 3 Team 9 -> Division 2 ... So the rankings should be: Team 1 -> Division 1 Team 2 -> Division 2 Team 4 -> Division 3 ( Although Team 3 has more points, he cant be third, as there is already a team from division 2 in the top 3) .. The rest are orderd by points... Is there a way of doing this?

Hi guys, Ok so here is the problem, I got 2 complicated text files, that I need to read... First file(reportss.txt): Here is the second file(boxscores.txt): This is only the 1st data. There is alot like this, so what I want to do is: - Insert the 2500(gameID) in a MYSQL coloum named id - Insert: in a Mysql coloum name result - Insert: In home_team scoring - Insert: In away_team_scoring - Insert this: In boxscore - Insert this: In three_stars - Insert : Notes for Toronto Maple Leafs: In Home_team_notes Notes for New York Islanders: in away_team_notes Other notes: in other_notes And sometimes, after like 10-30 games there is farm team results, that appears underneath the other notes, So that goes in: farm_team_results I tried to make something for almost 2 weeks now, without getting anything... So it's time for me to see the experts, Any help is appreciated, Thanks Ara

Oh wow thank you so much!!!!!

I need the whole table information, There is some game results that I have to get in a while Loop(php)

How can Group By be useful here?

year and month are seperate colums Here is the colums: -id -year -month -home_team -away_team and there is more

Hi guys, I was wondering, I have this MYSQL Select code: SELECT * FROM `schedule` WHERE `month` = '12 'AND `year`='2009' AND `home_team`='16' OR `away_team`='16' ORDER BY `day` ASC It shows results from every month and every year... Why is that? The only 2 thing that it takes into consideration is the home_team and away_team and the Order By....

Hi, OK so I dont get the problem. The link says: And %20 = Space %27 = single quote... So far so good right no? Well not quite, I put it in a variable: $player = $_GET['name']; And when I echo it out: Where did that slash comes from? In the link, there is no slash.... Thanks for your help, Ara

And now it works... Thanks alot, but do you know why it didnt work? Is it cuz mysql_query() was in a result itself or soemthing?

Of course! Thanks

Hi, MadTechie, there is no error... The code just stops.... The rest is blank.... dirtynight, I added it but, it is still blank.... I dont know whats going wrong... I tried running the code alone on php my admin, and is able to find the data....

Hi, I have a little problem. I am fetching data from MYSQL database, with the fied name, Name. Ok so the thing is some of the name have single quotes in them. SO when I want to pass it via $GET to another page, it doesnt show the full name... The other page, takes the value and prints information for that name... I tried addslahses, without any help... Is there a word-around? Thanks for your help, Ara

Yeah, but I need that line know? I mean, I need that line to get the player's name....

It works when I take that line off... It works

It shows nothing... The page stops displaying after that line...

Hi, I am having problem with a very very simple code. I use it alot and it never caused me this much of trouble. Its been like 2-3 hours that I am trying to figure it out... :facewall: Ok here is the code: $result = mysql_query("SELECT * FROM history ORDER BY `id` DESC LIMIT 0,5",$link); while($row = mysql_fetch_array($result)) { $history = "" .$row['history']. ""; $playerid = substr($history, 0, 4); $getp = mysql_query("SELECT * FROM `players` WHERE `id` = '$playerid' ",$link); $player_name = mysql_fetch_array($getp) or die(mysql_error()); $Player = "" .$player_name['name']. ""; echo "$Player $history<br/>"; } ?> I echoed $playerid, alone and it shows it well... I tried running the Select sql, in PHP MyAdmin, it works.. Its only: $player_name = mysql_fetch_array($getp) or die(mysql_error()); That seems to be bugging, but I have no idea why.... Thanks, for your help, Ara

Thansk for your quick replies!!

Hi, Thanks it works!!! But can I put some spaces between the 2 tables?

Hi, I am trying to put 2 tables next to each other... But it keeps going on the bottome, even if there is alot of space next to each other... WHy is that? Here is the table code: <table> <caption>Meilleurs Buteurs</caption> <thead> <tr> <th>Nom</th> <th>PJ</th> <th>Bts</th> </tr> </thead> <tfoot> <tr> <th colspan='3'> </th> </tr> </tfoot> <tr> <td>Name</td> <td>PJ</td> <td>Goals</td> </tr> <tr class="odd"> <td>Name</td> <td>PJ</td> <td>Goals</td> </tr> <tr> <td>Name</td> <td>PJ</td> <td>Goals</td> </tr> </table> <table> <caption>Meilleurs Pointeurs</caption> <thead> <tr> <th>Nom</th> <th>PJ</th> <th>Pts</th> </tr> </thead> <tfoot> <tr> <th colspan='3'> </th> </tr> </tfoot> <tr> <td>Name</td> <td>PJ</td> <td>Points</td> </tr> <tr class="odd"> <td>Name</td> <td>PJ</td> <td>Points</td> </tr> <tr> <td>Name</td> <td>PJ</td> <td>Points</td> </tr> </table>

It works now, Thanks. All i did is take away the As there is no reason to espace that .... Thanks again!

Nicely tought But, Its not working, I am thinking maybe I am placing it wrong... So here is the code: </tfoot> <?php error_reporting(0); $link = mysql_connect ("localhost", "", "") or die("mysql_error()"); mysql_select_db ("liguehs_league", $link); $class = "class=\'odd\'"; $action = $_GET['action'] ; switch ($action) { case "all": // Toute les equipes $result = mysql_query("SELECT * FROM `teams` ",$link); while($row = mysql_fetch_array($result)) { if ($class == "class=\'odd\'") { // this will rotate the value. $class = ""; }else{ $class = "class=\'odd\'"; } echo "<tr $class><td><a href='team.php?name=" .$row['team_name']. "'>" .$row['team_name']. "</a></td>"; Its only part of it.... But seems ot not be working

Hi, Thanks for your reply, But it isnt what I mean, I have a CSS stylesheet, that changes the background color of the table row. But for that I need to put: class='odd' To be a different colors....

Hi guys, Here is my problem, I am extracting data from a MYSQL table and formatting it into a table. But what I want is that the first row should be: <tr> The second one to be: <tr class='odd' > Third one: <tr> And so on.... I am pretty sure its simple ,but I cant put my finger on it.... :facewall: :facewall:

It works thank you su much!!!!