| | |
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 basic beginner broken cache cakephp class cms code computing confirm countingeverycharactersfromastring cron curl customizableitems database date delete dynamic echo email error fcc file filter folder form forms forum freelancing function functions gc_maxlifetime google header headmethod howtowriteathesis href htaccess html iframe image include incode ip javascript joomla limit link login malfunction match memmory memory menu method mod_rewrite multiple mysql navigation neutrality oop pagerank parsing paypal pdf php phpmysql query question random recursiveloop root script search select server sessions sms snippet soap source space sql support! system table template thesishelp trouble tutorial upload url variable video web window.onbeforeunload=closeme; youtube






