Hi all

Any one can help me Regarding the query

I have the user posted data in the data base and i want to display the comments on the HTML form

But the mistake is i am able retrive the data by useing mysql_fetech_assoc using while loop but the values are not displayed on the form

Ok


My script is

<?php
global $Ans1, $Ans2, $Ans3, $Ans4, $Ans5, $comments;

$connect = mysql_connect("Localhost", "root", "") or die ("I am unable to conect with database because of".mysql_error());

$selectdb = mysql_select_db("moodledb") or die("I can't select the database because of".mysql_error());

$Join = "SELECT `mdl_al_sessionfeedback`.`sessionid`, `mdl_al_sessionfeedback`.`ans1`, `mdl_al_sessionfeedback`.`ans2`,

`mdl_al_sessionfeedback`.`ans3`, `mdl_al_sessionfeedback`.`ans4`,`mdl_al_sessionfee dback`.`ans5`,

`mdl_al_sessionfeedback`.`comments` FROM `mdl_al_sessionfeedback`, `mdl_al_sessions` WHERE (`mdl_al_sessionfeedback`.`sessionid` =
`mdl_al_sessions`.`alsessioncode`) ";

$result = mysql_query($Join) or die("Unable to execute the join query because of:".mysql_error());

$row = mysql_fetch_assoc($result);

$num = mysql_num_rows($result);

for($i=0; $i<$num; $i++)
{
$Ans1 = mysql_result($result,$i,"ans1");

$Ans2 = mysql_result($result,$i,"ans2");

$Ans3 = mysql_result($result,$i,"ans3");

$Ans4 = mysql_result($result,$i,"ans4");

$Ans5 = mysql_result($result,$i,"ans5");

$comments = mysql_result($result,$i,"comments");

echo $comments;
}
echo "<textarea name='txtComments' rows='2' cols='20' id='txtComments' value = '<?php $comments ?>'></textarea>";
?>
Narender