variables

[bagnallc]

Hi

hopefully this is an easy answer

i have the following variable

$trainerqry6=mysql_query("SELECT DISTINCT trainers.trainer_id as trainerid, trainers.trainer AS trainer
FROM trainers");

it works fine - but i want to use the same query several times in different places on the page. how do i make the variable accessible more than once

Thank you and apologies for the stupid question

[uraniumdeer]

ehm... define it in the "root" of the PHP tag i suppose

[code]
<?php
$trainerqry6=mysql_query("SELECT DISTINCT trainers.trainer_id as trainerid, trainers.trainer AS trainer
FROM trainers");
...
...
...
?>
[/code]

[bagnallc]

im sorry i dont know what you mean by this.

it is currently defined at the top of the page in the first block of php code

it works fine when called once but the second time it returns nothing

thanks again

[hvle]

$trainerqry6 is a resultset, correct me if i'm wrong.

so, it's resultset.

If you like to use it inside a function, you'll need to global it inside that function.

Resultset is special. When you fetch result, the internal pointer of result set point to the next row. So, after a while, eventually, fetch will return null to indicate the end of result.
If you need to re-use the results, you have to mysql_data_seek.
This function move the internal pointer to the location you wanted.
mysql_data_seek($trainerqry6, 0); will reset the resultset

[uraniumdeer]

Yeah... ofcourse, i was thinking it was only the querystring and not the query itself - sorry...

[bagnallc]

i now have this working. many thanks for your help