On Sun, 18 Jul 2004 13:24:01 -0700, Marcjon <marcjon@xxxxxxxxxxx> wrote:
> You could use a if/while construct. Something like:
>
> <select name=\"courses\">
> <?php
> if ($_POST['studentselect']){
> $result = mysql_query("SELECT courses FROM students WHERE student_name =
> '" . $_POST['studentselect'] . "'");
>
> while ($row = mysql_fetch_assoc($result))
> {
> echo "<option value=".$row['course'].">".$row['course']."</option>";
> }
> }
> ?>
> </select>
>
> Basically you would submit the form, and if a student was selected, it
> would populate the list with their courses from the database.
>
> --
> Marcjon
>
>
>
> ----- Original message -----
> From: "G. Cohen" <gilac@xxxxxxxxxxxxxx>
> To: php-db@xxxxxxxxxxxxx
> Date: Sun, 18 Jul 2004 19:30:49 +0300
> Subject: 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 is a server-side language, so any further processing can only be
done when the browser sends a new request. You have to refresh *some*
page to get new data.
It is possible to use a hidden iframe to send a request, then parse it
with JS and display it in the main page, but this isn't trivial.
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
