ded

Question: When doing the sum(nationalpoints) with a LIMIT, the sum(nationalpoints) is the sum of all 50 records correct? I would rather load into arrays, so I change the FOR loop to this for($i = 0; $i < count($names); ++$i) { $playerid = $names[$i]; $query2 = "SELECT playername, sum(nationalpoints) FROM `tournamentresults` WHERE `playername` = '$playerid' and `date` >= '2012-01-01' ORDER BY `nationalpoints` DESC LIMIT 12"; $result2 = mysql_query($query2,$dbh) or die(mysql_error()); $count = 0; while($row2 = mysql_fetch_array($result2)) { $points[$i] = $points[$i] + $row2['sum(nationalpoints)']; } } But it seems to give ALL records and not just the top 12 Array ( [] => 10 [Aaron Flores] => 32 [Aaron Jameson] => 40 [Aaron Johnson] => 24

No....some players have 30 sets of points. For World Cup Points, only the 12 highest points results per player counts. I do IBMi programming and use arrays a lot. I figured this should be very simple but this command is not working: $points[$i] = $worldcuppoints; If I change that to $points[$i] = $row2['nationalpoints']; I actually get data in the $points[] but only the points from the last record read and not the sum of the top highest results for that player.

That will not work. That will grab the first 12 records of the table. I need to grab the highest 12 points for each DISTINCT player.

They are are the same table. I am first gathering the DISTINCT names of all the players from the results table and loading into the names array I am then running that array against the same to to get the first 12 results for each index of the names array Adding the points up and populating the points array with the index ID as the name I then want to merge or combine both arrays to provide the results.

I asked for help, not sarcasm.

The $points[] shows all zero's. It is like the $worldcuppoints is not being loaded into the array properly. $query = "SELECT DISTINCT playername FROM `tournamentresults` WHERE `date` >= '2012-01-01' ORDER BY `playername`"; $result = mysql_query($query,$dbh) or die(mysql_error()); $names = array(); while($row = mysql_fetch_array($result)) { $names[] = $row[0]; } for($i = 0; $i < count($names); ++$i) { $playerid = $names[$i]; $query2 = "SELECT playername, nationalpoints FROM `tournamentresults` WHERE `playername` = '$playerid' and `date` >= '2012-01-01' ORDER BY `nationalpoints` DESC"; $result2 = mysql_query($query2,$dbh) or die(mysql_error()); $count = 0; $worldcuppoints = 0; while($row2 = mysql_fetch_array($result2)) { $counter++; if ($counter > 12); { break; } $worldcuppoints = $worldcuppoints + $row2['nationalpoints']; } $points[$i] = $worldcuppoints; } $c = array_combine($names,$points); print_r($c); This is the outcome Regards, David

How do I show the totals for the top 5 for each group by? Example: Joe 29 Joe 25 Joe 24 Joe 23 Joe 31 Bill 20 Bill 29 Bill 2 Bill 8 Bill 22 Scott 25 Scott 14 Scott 19 Scott 25 Scott 29 Mike 23 Mike 19 Mike 22 Mike 28 Mike 23 Bob 22 Bob 26 Bob 22 Bob 24 Bob 21 Total points would show the following: Joe = 131 Mike = 115 Bob = 115 Scott = 112 Bill = 81 I want to rank the people by their top 3 points Joe = 85 Scott = 79 Mike = 74 Bob = 72 Bill = 71 How is this done in SQL? Is it possible? This is my current code SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC Regards, David Hascup

I have a database that results records for several thousand players. I need a report that will show the following. Rank the top players based on their top 3 finishes. I have the following for the full rankings which is working perfect SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` WHERE `gender` = '$gender' and `affiliation` <> ' ' and substr(`date`, 1, 4) = '2012' GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC The above gathers ALL nationalpoints for the player. I want to just grab the highest 3 nationalpoints for each player and then rank the players by that number. Example: Joe 12 Joe 10 Joe 8 Joe 16 Joe 15 Bob 8 Bob 16 Bob 18 Bob 18 Bob 15 Mike 24 Mike 15 Mike 16 Mike 4 Mike 2 Sam 34 Sam 12 Sam 5 Sam 24 Sam 1 David 24 David 22 David 25 David 14 David 21 National Rankings from the table above would be the following: 1. David = 106 2. Sam = 76 3. Bob = 75 4. Joe = 61 4. Mike = 61 With the idea I need, the rankings would be 1. David = 71 2. Sam = 70 3. Mike = 55 4. Bob = 52 5. Joe = 43 Regards, David

Bluehost

My website was hacked and hacked BAD. All the links send you to a russian website which then download viruses on your PC. Anyway, does anyone know or have an opinion on which software would be the best to track malware and SQL injections and viruses within a website? I have researched SiteLock, VeriSign and Sucuri but not 100% sure which is best.

Never mind......ID TEN T problem.

Not sure why this is happening? Showing No database selected The database does exist $dbh=mysql_connect ("localhost", "website_dbname", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("website_newdatabase"); $query = "SELECT * FROM `contacts` ORDER BY `rrn`"; $result = mysql_query($query,$dbh) or die(mysql_error());

That was it!!! I better check all code within the entire site for year. Thanks!

I changed the coding but still nothing.....weird. Ths first 6 listed on http://www.americandartsdatabase.com/player-rankings/included-leagues-tournaments/ does not work, but the remaining 13 works fine. Could it be a loop issue of some sort?

I have a page showing a list of events from tournaments/leagues (http://www.americandartsdatabase.com/player-rankings/included-leagues-tournaments/) If you click on the CLICK HERE link, it should come up with a page that shows the stats for that particular event. Some events it works and some it does not. 11th Annual ABDA Nationals works fine North Side Dart League does not work Below is the list of tournaments and leagues that are included in the rankings. If you wish to have your tournaments and/or leagues included in the rankings, please register and send me the stats. <?php $mynewdate = strftime("%Y-%m-%d", strtotime("-730 days")); echo "<font color=red><b>Included are leagues and tournaments from " . $mynewdate . " to today.</b></font>"; $dbh=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("database"); $query = "SELECT `event`, `date` FROM `stats` WHERE `date` >= '$mynewdate' GROUP BY `event` ,`date` ORDER BY `date`"; $rank = 0; $rankh = 0; $result = mysql_query($query,$dbh) or die(mysql_error()); ?> <table align=center width=90%> <tr> <th align="left">League/Tournament</th> <th align="left">Date</th> <th align="left">View Stats</th> </tr> <?php while($row = mysql_fetch_array($result)) { $event = $row['event']; $year = $row['date']; $url = "<a href=\"http://www.americandartsdatabase.com/player-rankings/included-leagues-tournaments/stats/?event=" . $event . "&year=" . $year . "\">Click Here</a>"; echo "<tr>"; echo "<td>" . $event . "</td>"; echo "<td>" . $year . "</td>"; echo "<td>" . $url . "</td>"; echo "</tr>"; } ?> </table> Here is the STATS code <?php $event = $_GET['event']; $date= $_GET['year']; $rank = 0; echo "<h1>Event: " . $event . "</h1><br>"; echo "<h1>Date: " . $date . "</h1><br>"; $dbh=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("database"); $query = "SELECT `firstname`, `lastname`, `games`, `points`, `event`, `date`, (`points`/`games`) FROM `stats` WHERE `event` = '$event' and `date` = '$date' ORDER BY (`points`/`games`) DESC"; $result = mysql_query($query,$dbh) or die(mysql_error()); ?> <table align=center width=100%> <tr> <th align="left">Rank</th> <th align="left">Player</th> <th align="left">Games</th> <th align="left">Points</th> <th align="left">Average</th> </tr> <?php while($row = mysql_fetch_array($result)) { $rank = $rank + 1; echo "<tr>"; echo "<td>" . $rank . "</td>"; echo "<td>" . $row['firstname'] . " " . $row['lastname'] . "</td>"; echo "<td>" . $row['games'] . "</td>"; echo "<td>" . $row['points'] . "</td>"; echo "<td>" . number_format(($row['points']/$row['games']),4) . "</td>"; echo "</tr>"; } ?> </table>

First....thank you very much for this information. Second....sorry for bothering you with this, but I cannot figure it out and it is probably very simple ok....I have read through most of the information and have keyed in the first portion for testing purposes. I have an issue. Once I hit submit, the record in the database is written without a problem, but then a screen pops up that says "Do you want to open or save this file?" When I click open, a notepad shows up reading "User Created". Shouldn't it just echo it on the user-man.php screen?

will do.....thank you

I want to create an ADMIN directory with several directory under that. I want to be certain that the user cannot log into any of the directory unless they have confirmed login. Is $_session id's the best way to go? Should I create on the flyer and attached to username? What is the best practice for this? Regards, DED

excellent....and thank you. I have to build more editing processing into the admin panel I created for the users, but until i have time to do that, the workbench will work great for me. Thanks again,

What would you suggest as the best FREE one? Workbench? Sequel Pro? Maybe another one?

I use bluehost as my website host. I use php with mySql. Is there a program that will allow me to view mySql databases without having to log into bluehost cpanel? Something that can run right on my PC? Regards, David

The banner show correctly in ALL browsers, including earlier versions of IE #header { height: 133px; } #headerwrap { height: 133px; } #logo { height: 121px; max-height: 121px; margin-left: 5px; margin-bottom: 3px; padding-top: 12px; z-index: 1; width: 600px; } http://www.digiulioformayor.com/

Never mind....got it SELECT * , (SUM(`points`)/SUM(`games`)) FROM `averages` WHERE `lastname` = 'Young' GROUP BY `lastname` ,`firstname` ORDER BY `lastname` ,`firstname` LIMIT 0 , 9999

Examples records: First Last games points average event year John Doe 17 904 53.18 ABDA Nationals 2010 John Doe 21 1132 53.90 PA States 2010 John Doe 8 414 51.75 PA States 2009 I put in this code SELECT * , SUM(`games`) , SUM(`points`) , SUM(`average`) FROM `averages` GROUP BY `lastname` ,`firstname` ORDER BY `lastname` ,`firstname` LIMIT 0 , 9999 This shows the following First Last SUM(`games`) SUM(`points`) SUM(`average`) John Doe 46 2450 158.83 For the SUM(`average`), I need it to show 53.26 which is 2450/46. I need it to show the following: First Last SUM(`games`) SUM(`points`) SUM(`average`) John Doe 46 2450 53.26

I need some help creating a query My database has the following fields: firstname lastname games points average event year Each player can have 1 - 8 records at this point I want to be able to GROUP BY firstname and lastname combined. I want to sort by the combined average. So basically I will need to sum games and points and then divide them to create the overall average.