Re: php, javascript and db - your help is needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux