using a variable name from a variable

samgeorge

you're confused allready?

what i need is a script that uses someones name (from a database $row_results['P1N'] ) then add how many they have scored $row_results['P1N'] + $row_results['P1S'] Then if the PHP finds the same name Again it adds the $row_results['P1S'] again untill it can find any more.

then this data is to be shown on the other side of the page in a tally chart showing the TOP GOAL scorer.

i had an idea of something like:

$.$row_results['P1N'] = $.$row_results['P1N'] + $.$row_results['P1s']

--then on the other side

echo $.$row_topscorers['Name']

which doesn't work.

How can i fix this???

url: http://www.ktcsc.co.uk/Hockey/Mens/index.php?hteam=MensX1

leatherback

Hi,

if get you right, what you need is variable variables

So: $$row_results['P1N']

samgeorge

for example my script counts how many goals are scored by saying

$Foppogoals = $Foppogoals + $row_results['Opposition Score'];

then it echos $Foppogoals to show the value..

so for goal scorers i want it to say

$$row_results['scorer'] = $$row_results['scorer'] + $row_results['Goals Scored'];

then the echo command shows

$Sam George [[Whicj this name is thaken form another query]] (so it then echos the amount of goals i have scored!

leatherback

Are you asking a question?

If this was your way of letting us know you have things working, please mark this thread resolved!?

samgeorge

now i have a list of say 50 names and i need the amount of goals scored Highest to losest How can this be done?

leatherback

Hi,

Depends on how you have them. If you have them in an array, you can sort them

-- Dont fear the manual: It is your best friend besides google --

samgeorge

go to http://www.ktcsc.co.uk/test/index.php?hteam=MensX1

this is my test page see the results shown at the bottom right? How can i sort them

i am using the function ${$From DB} = ${$From DB} + $goals

then echo $NAME echo ${$name}

leatherback

Hi,

I am not sure how you have organized your database.

But to me it sounds like you are doing something fairly straightforward i a complex way.

I assume you have a table which holds scores per per person per match?

You could then do something like:

$query = "
select name, sum('scored') as total_scored from table group by name order by total_score
";

which would toss out all your variable-variables, math's etcetc and give you hte output you need.

Have a look at the mysql website and look for select in the manual.

If I am completely off here.. you can do this:

Instead of echo-ing all to the screen, place each name & score in an array(). Then sort the arrays.

samgeorge

all my maths is done on the page i found it easier

so using an array??

<?php

$fruits = array ("lemon", "orange", "banana", "apple");
sort ($fruits);
reset ($fruits);
while (list ($key, $val) = each ($fruits)) {
echo "fruits[".$key."] = ".$val."\n";
}

where the fruits are i would put Names of the payers
then i have to put an array showing all the player names???

as u can tell im not that great at PHPing

leatherback

Hi Sam,

Don't want to be a pain here but..
I suggest you have a read in the manual look especially at array functions (Your last post suggess you have had a loko at defining an array). Give it a fiddle, and see how you go. After you have tried, post some code (In a new thrad perhaps) and we'll see where you have gotten to.

Everybody has to learn, and all beginning is dificult. But the only way to figure it out is by being stuck sometimes. I usually don't post questions untill I have been stuck for an hour, and have run out of options...

Besides that.. Look at the suggestion for querying the database I gave you before. It really is easier if you do the querying that way. Also.. I looked atthe first post, and noticed you have a database setup which may not be the most efficient for the kind of thing you are trying to do. Remember that a database table is not a display table:A table with 3 colums and 2000 records is often easier to operate then a table with 20 cols and 20 rows. Especially when creating overviews like this one.

Goodluck & read you later!

samgeorge

thanks for your help so far.......

samgeorge

i am a leg-end..

i now use the variable variable thinggy, BUT what it does it writes its value to the Database!!!!!!!!!!!!!!!!!!!!!!!!

so now i order it via the database..

i am magic mickey!