passing link variable

[acey]

ok this is the script

<?

$sql = "SELECT roomn FROM rooms";
$result = mysql_query($sql);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$room=mysql_result($result,$i,"roomn");
echo"$room<a href=\"http://ace.slanky.net/chat.php?room=$room\">$room</a>";
++$i;
}

?>

$room being the chat room name and i would like to pass this variable

like the following

<title></title>
<frameset rows="563,62" cols="*"> 
  <frame name="posts" src="chat2.php?room=<? $_GET['room'] ?>"  scrolling="yes" noresize frameborder="0">
  <frame name="form" src="send.php" scrolling="no" noresize frameborder="0">
</frameset>
  <noframes>

which is in chat.php ^

but its not working , any ideas?

[HalfaBee]

This should work.
HalfaBee

<? 
$sql = "SELECT roomn FROM rooms"; 
$result = mysql_query($sql); 
while ( ($row=mysql_fetch_assoc($result))!==FALSE )
{ 
    $room=$row['roomn']; 
    echo"$room<a href=\"http://ace.slanky.net/chat.php?room=$room\">$room</a>"; 
} 

?> 

[acey]

thanks for that 🙂

to make it work

i needed to add $_request['room'];

to everypage i needed to and

<frameset rows="563,62" cols="*">
<frame name="posts" src="chat2.php?room=<?echo "$room" ?>" scrolling="yes" noresize frameborder="0">
<frame name="form" src="send.php?room=<?echo "$room" ?>" scrolling="no" noresize frameborder="0">
</frameset>
<noframes>
echo

then eventually in chat2.php
$_request['room'];
$room2=$room

all i can say is , what a pain !!! 😃