array in PHP

[zedan_80]

Hallo

i have the following code

<?
$qry = "select name from country";
$qry = mysql_query($qry , $conn);

while($res = mysql_fetch_array($qry))
echo $res['name'];
?>

the problem is if i want to use the same data again i have to call the query again
How can i keep the data and use it many times without calling the query each time.

[Sayian]

zedan_80 wrote:

the problem is if i want to use the same data again i have to call the query again
How can i keep the data and use it many times without calling the query each time.

Use a Session to Manage and Store the value

$_SESSION['name'] = $res['name']; 

Then on each page you want to use the value , put

session_start();

At the top of the page , then where you'd like the use the value , simply write

$_SESSION['name'];

And your data will be in that variable... in ANY page in your script , But only for as long as the session lasts.

[tekky]

I think somehting like

$i=0;
while($row = mysql_fetch_assoc($res))
{
  //do what you need like echo $row['name'];
  $data[$i]['name'] = $row['name'];
$i++;
}

then you can just loop through $data[$i] to find all your vas