Retrving data from database to form
 

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

Does the <textarea> tag have a value attribute? anyway if you want data to be displayed inside a <textarea> then you do it between the opening and closing tags, in your example:
needs to be changed to :
there is also no need for '<?php $comments; ?>'.

I do think the retrieving of data could be a little better, the use of both mysql_fetch_assoc and mysql_result i can't understand.
This perhaps is a better way of doing it:

Retrving values from database and displaying in a form
 

Hi

it displays the every time text box along with the data but i want to display only one text area and value in the text box need to be changed according to the session id

i am attaching the output how it display and what is my requirement please find the two attachments and help me

Narender