tricky loop question

[michaelowen]

hello everybody,

I have written the following loop that works realy great. What it does is allows a user to input results and this program will then loop through and allot points and an overall order.

My question is that what i need to do it combine many of these loops into one program and then output and sort the final points.

points (as you can see in the code) are allotted by an equation that relies upon the place and number of entries (which are not constants)

---

$run_query = "SELECT FROM ....WHERE sex = 'male' and one_time > 0 order by one_time";
$run_result = mysql_query($run_query);
$numrows = mysql_numrows($run_result);
$i=1;
while($run_row = mysql_fetch_array($run_result)){
$mydataorder = $run_row[user] + $i;
$mydatafirst = $run_row['first_name'];
$mydatalast = $run_row['last_name'];
$mydataage = $run_row['age'];
$mydataplace = $run_row['one_place'];
$mydatateam = $run_row['team'];
$mydataoneplace = $run_row['one_time'];
$mydataonepoints = ROUND(1000-($mydataorder-1)(1000/$numrows));
echo "<tr><td>".$mydataorder."</td><td>".$mydataplace."</td><td>".$mydatafirst. "&nbsp" .$mydatalast."</td><td>".$mydataage."</td><td>".$mydatateam."</td><td>".$mydataoneplace."</td><td>".$mydataonepoints."</td></tr>";
$i++;

}

for example, i now have event TWO, and i change all the loops to show event two....how can i combine these two and have an OVERALL POINTS field.

-mike

[leatherback]

Hi,

Unless I do not understand youre question..

Couldn't you just add a line:

$totalcount = $totalcount + $mydataonepoints;
after you have calculated the $mydataonepoints?

J.

[michaelowen]

let's look at it more like this:
how could i combine and sort the results of these two depending on the TOTAL points (one+two)....however since the number of participants is different they have to be looped seperately.

---

//EVENT ONE QUERY
$run_query = "SELECT FROM ....WHERE sex = 'male' and one_time > 0 order by one_time";
$run_result = mysql_query($run_query);
$numrows = mysql_numrows($run_result);
$i=1;
while($run_row = mysql_fetch_array($run_result)){
$mydataorder = $run_row[user] + $i;
$mydatafirst = $run_row['first_name'];
$mydatalast = $run_row['last_name'];
$mydataage = $run_row['age'];
$mydataplace = $run_row['one_place'];
$mydatateam = $run_row['team'];
$mydataoneplace = $run_row['one_time'];
$mydataonepoints = ROUND(1000-($mydataorder-1)(1000/$numrows));
echo "<tr><td>".$mydataorder."</td><td>".$mydataplace."</td><td>".$mydatafirst. "&nbsp" .$mydatalast."</td><td>".$mydataage."</td><td>".$mydatateam."</td><td>".$mydataoneplace."</td><td>".$mydataonepoints."</td></tr>";
$i++;
} //EVENT TWO QUERY

$run_query = "SELECT FROM ....WHERE sex = 'male' and two_time > 0 order by two_time";
$run_result = mysql_query($run_query);
$numrows = mysql_numrows($run_result);
$i=1;
while($run_row = mysql_fetch_array($run_result)){
$mydataorder = $run_row[user] + $i;
$mydatafirst = $run_row['first_name'];
$mydatalast = $run_row['last_name'];
$mydataage = $run_row['age'];
$mydataplace = $run_row[two_place'];
$mydatateam = $run_row['team'];
$mydatatwoplace = $run_row[two_time'];
$mydatatwopoints = ROUND(1000-($mydataorder-1)(1000/$numrows));

$i++;
}

---

how do i loop and sort by $mydataonepoints+$mydatatwopoints

is that any clearer?

-Michael

[leatherback]

Hi,

Looking at your two queries I am wondering whether you do not have a basic flaw in your database design. How is your database setup?

I am not sure, but IF you do the two queries on the same table, with just on or two different fields in the output, you :

• should consider whether htese two fields are not actually the same, but with different times
• Look into using a combined statement when retrieving your recors.

I am sorry, but do not see how you setup your database/routines..

J.

[michaelowen]

database is fine and the individual loops work great..

it's the theory i need help with.

-mike