Hi Cohen,
It�s really trivial. You show put a block that tests if a student is
selected, like
<? if (strlen($_REQUEST["student_id"])>0) { ?>
DO SOME STUFF
<SCRIPT>
/* And add this simple feature to select the student passed as parameter */
/* Assuming that the select is inside a form named 'f' */
function selectOption(selectName, value) {
var s = document.f.elements[selectName];
var found = false;
for (var i=0; i<s.options.length && !found; i++) {
if (s.options[i].value==value) {
s.selectedIndex=i;
found = true;
}
}
}
selectOption('student_id',<?=$_REQUEST["student_id"]?>);
</SCRIPT>
<? } ?>
----- Original Message -----
From: "G. Cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 18, 2004 1:30 PM
Subject: [PHP-DB] php, javascript and db - your help is needed
> Hello,
>
> I have a HTML form with 2 select boxes, lets say students and courses.
When
> the from loads for the first time, I fill the students select box with
data
> from database. The courses selectbox remains empty.
> When the user selects a value from the students selectbox (onchange
event),
> I should go to the db to reterive the courses for the selected student and
> fill the courses selectbaox. I found it very complicated to do the
> interaction between javascript and php: apparently, I have to submit the
> from for the selected student id to be passed as a parameter to php (so
that
> php can access the db with the student id and retrieve his courses), and
at
> the same time I want the form to stay with the list of students, and the
> selected student. This should not be that hard, should it?! this is
> something trivial, I hope?
> I also tried using cookies, with no success.
> If someone knows how to do that, please let me know.
>
> Best Regards,
> G. Cohen
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
