| | |
Retrving data from database to form
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Aug 2008
Posts: 3
Reputation:
Solved Threads: 0
Hi
Can any one help me
I have the data in the database and i retrive it using mysql_fetch_assoc using while loop and i am trying to display it it on HTML form it is not displayed can any one help me
U can find my script
Can any one help me
I have the data in the database and i retrive it using mysql_fetch_assoc using while loop and i am trying to display it it on HTML form it is not displayed can any one help me
U can find my script
php Syntax (Toggle Plain Text)
<?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_sessionfeedback`.`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>"; ?>
Last edited by cscgal; Sep 9th, 2008 at 11:50 am. Reason: Added code tags
i think the last line is not correct...
try instead:
textarea doesn't have value attribute...
try instead:
php Syntax (Toggle Plain Text)
echo "<textarea name='txtComments' rows='2' cols='20' id='txtComments'><?php echo $comments ?></textarea>";
Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..
•
•
Join Date: Aug 2008
Posts: 3
Reputation:
Solved Threads: 0
Hi shanti
Here what my requirement is by executing the above sql query i got total 108 rersults
and i want display the comments one for one session and 5 Radio button values which is also featched from the same table and i have changed the lost line
printf("<textarea rows=4 cols=20>%s</textarea>\n<br>", $comments);
for every i got one text box along with the comment
and i am attaching my final form also
can u help me
in the form it display default radio button value instead of orginal values
Here what my requirement is by executing the above sql query i got total 108 rersults
and i want display the comments one for one session and 5 Radio button values which is also featched from the same table and i have changed the lost line
printf("<textarea rows=4 cols=20>%s</textarea>\n<br>", $comments);
for every i got one text box along with the comment
and i am attaching my final form also
can u help me
in the form it display default radio button value instead of orginal values
![]() |
Other Threads in the PHP Forum
- Previous Thread: Image file upload to thumbnail
- Next Thread: sessions in shopping cart
| Thread Tools | Search this Thread |
apache api array auto beginner binary broken cache cakephp checkbox class cms code codingproblem cron curl customizableitems database date display dynamic echo email error errorlog file files filter folder form format forms forum function functions gc_maxlifetime global google headmethod href htaccess html image include insert ip javascript joomla limit link login mail malfunctioning memmory memory menu mlm multiple mysql nodes oop parameter parsing paypal pdf php phpmysql popup query question radio random recursion recursiveloop remote script search select server sessions snippet source space sql static survey syntax system table trouble tutorial up-to-date update upload url validator variable video web youtube






