mysql fetch array question

Nixon

Right, I have a problem and I honestly cannot think of a way to sort it out. I have a webpage (outlink.coolfreepage.com/index.php) and on the first page i have an array. It fetches 5 users with the highests points. I want to treat these 5 rows as seperate items. How would I do this?

Thanks, Nixon.

leatherback

Could you be a bit more specific on what you are trying to do?

Are you planning on running more queries afterwards, or??.

alanzhao

Ohh, you mean you already did

$array = mysql_fetch_array($qid);

if that's the case,


list($value1, $value2, $value3, $value4, $value5) = $array;

// or

$value1 = $array[0];
$value2 = $array[1];
$value3 = $array[2];
$value4 = $array[3];
$value5 = $array[4];

Nixon

EXCELLENT, i think youve hit the nail on the head there! Does the 0,1,2,3,4 stand for the rows? If so then thank you very much ive been pulling my hair out over this.

Thanks again.

Nixon

Now I have one more problem. How could I run a script when somebody clicks on a link?

leatherback

How about:

onClick="SomeScript()"

Nixon

Would this work somebody else said it wouldn't. How would I use the command? Would it be :

onClick"changepoints(change.php)" ?

Sorry I have no knowledge of how it works this is just a guess. Also on my array question again, it seems that when i try to print the arrays like so:

echo ($array1);

it doesnt return anything. Any ideas? All my rows are full.

Thanks, nixon.