Storing query result as a string

micmac

Hi all,
If i have the following query:

<?
$query = "SELECT movie_id,movie_title FROM movie ORDER BY movie_title";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
?>
                  <option value="<? echo $row['movie_id'] ?>"><? echo $row['movie_title'] ?></option>
<?
}
?>

how do i go about putting the

into a string. I want to use the string several times later.

Cheers,
micmac

okuto1973

Originally posted by micmac
Hi all,
If i have the following query:
<?
$query = "SELECT movie_id,movie_title FROM movie ORDER BY movie_title";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
?>
                  <option value="<? echo $row['movie_id'] ?>"><? echo $row['movie_title'] ?></option>
<?
}
?>
how do i go about putting the

<option value="<? echo $row['movie_id'] ?>"><? echo $row['movie_title'] ?></option>

into a string. I want to use the string several times later.

Cheers,
micmac [/B]

<?
$string="";
$query = "SELECT movie_id,movie_title FROM movie ORDER BY movie_title";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$string.="<option value=\"<?=$row['movie_id'] ?>\"><?=$row['movie_title'] ?></option>";
}
?>

now you have $string with html code......
and do what you want.....that's what do u want?it was so simple......