DaniWeb Forum Index > Web Development > PHP

PHP mysql drop down populates another drop down

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2007

Posts: 2

Reputation: danielwoodhead is an unknown quantity at this point

Solved Threads: 0

danielwoodhead danielwoodhead is offline

Offline

Newbie Poster

PHP mysql drop down populates another drop down

May 3rd, 2007

Hi

I am tring to populate a drop down by selecting another drop down.
The first drop dwon populates from eventdata table and i want the second drop down to populate from a race table. I have tried to find the row which contains the same event id as the first drop down box and then display the team id which has the same event id.

NOTE event id and race id will have the same data in them, bad naming on my part

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
include 'config.php';
include 'opendb.php';
$sql="SELECT event_Name FROM eventdata";
$result=mysql_query($sql);
$optionsevent="";
while ($row=mysql_fetch_array($result)) {
    $event_Name=$row["event_Name"];
    $event_Name=$row["event_Name"];
    $optionsevent.="<OPTION VALUE=\"$event_Name\">".$event_Name;
}
function Generate(){
$sql="SELECT team_ID FROM race WHERE race_Name=$optionsevent";
$result=mysql_query($sql);
$optionsid="";
while ($row=mysql_fetch_array($result)) {
    $team_ID=$row["team_ID"];
    $team_ID=$row["team_ID"];
    $optionsid.="<OPTION VALUE=\"$team_ID\">".$team_ID;
}
}
?>
<html>
<head>
<title>Rally Database - Results Entry Form</title><style type="text/css">
<!--
.style1 {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 24px;
}
body {
 background-color: #CCCCCC;
}
-->
</style><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<div align="center">
  <p><strong><span class="style1">Results Entry Form</span></strong></p>
  <p align="left">Please enter select the Race ID and then the Team ID. </p>
</div>
<form method="post" action="enterresultsinsert.php">
  <label></label>
  <p>
    <label></label>
    <label></label>
    <label>Race ID
    <select name="raceid">
    <OPTION VALUE=0 onChange="Generate();" >Choose
    <?=$optionsevent?>
    </select>
    </select>
    </label>
    <label>Team ID
    <select name="teamid">
    <OPTION VALUE=0>Choose
  <?=$optionsid?>
    </select>
    </select>
    </label>
  </p>
  <p>
    <label>Stage 1 Time
    <input name="stage1" type="text">
    </label>
  </p>
  <p>
    <label>Stage 2 Time
    <input name="stage2" type="text">
    </label>
</p>
  <p>
    <label>Stage 3 Time
    <input name="stage3" type="text">
    </label>
</p>
  <label>Stage 4 Time
  <input name="stage4" type="text">
  </label>
  <p>
    <label>Stage 5 Time
    <input name="stage5" type="text">
    </label>
</p>
  <p>
    <label>Stage 6 Time
    <input name="stage6" type="text">
    </label>
</p>
  <p>
    <label>Stage 7 Time
    <input name="stage7" type="text">
    </label>
</p>
  <p>
    <label>Stage 8 Time
    <input name="stage8" type="text">
    </label>
</p>
  <p>
    <label>Total Time
    <input name="total" type="text">
    </label>
</p>
  <p>
    <label></label>
    <label></label><label>
    <input type="submit" name="Submit" value="Add Results">
    </label>
  </p>
  </form>
</body>
</html>
<?php
include 'config.php';
include 'opendb.php';
$sql="SELECT event_Name FROM eventdata";
$result=mysql_query($sql);
$optionsevent="";
while ($row=mysql_fetch_array($result)) {
    $event_Name=$row["event_Name"];
    $event_Name=$row["event_Name"];
    $optionsevent.="<OPTION VALUE=\"$event_Name\">".$event_Name;
}
function Generate(){
$sql="SELECT team_ID FROM race WHERE race_Name=$optionsevent";
$result=mysql_query($sql);
$optionsid="";
while ($row=mysql_fetch_array($result)) {
    $team_ID=$row["team_ID"];
    $team_ID=$row["team_ID"];
    $optionsid.="<OPTION VALUE=\"$team_ID\">".$team_ID;
}
}
?>
<html>
<head>
<title>Rally Database - Results Entry Form</title><style type="text/css">
<!--
.style1 {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 24px;
}
body {
 background-color: #CCCCCC;
}
-->
</style><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<div align="center">
  <p><strong><span class="style1">Results Entry Form</span></strong></p>
  <p align="left">Please enter select the Race ID and then the Team ID. </p>
</div>
<form method="post" action="enterresultsinsert.php">
  <label></label>
  <p>
    <label></label>
    <label></label>
    <label>Race ID
    <select name="raceid">
    <OPTION VALUE=0 onChange="Generate();" >Choose
    <?=$optionsevent?>
    </select>
    </select>
    </label>
    <label>Team ID
    <select name="teamid">
    <OPTION VALUE=0>Choose
  <?=$optionsid?>
    </select>
    </select>
    </label>
  </p>
  <p>
    <label>Stage 1 Time
    <input name="stage1" type="text">
    </label>
  </p>
  <p>
    <label>Stage 2 Time
    <input name="stage2" type="text">
    </label>
</p>
  <p>
    <label>Stage 3 Time
    <input name="stage3" type="text">
    </label>
</p>
  <label>Stage 4 Time
  <input name="stage4" type="text">
  </label>
  <p>
    <label>Stage 5 Time
    <input name="stage5" type="text">
    </label>
</p>
  <p>
    <label>Stage 6 Time
    <input name="stage6" type="text">
    </label>
</p>
  <p>
    <label>Stage 7 Time
    <input name="stage7" type="text">
    </label>
</p>
  <p>
    <label>Stage 8 Time
    <input name="stage8" type="text">
    </label>
</p>
  <p>
    <label>Total Time
    <input name="total" type="text">
    </label>
</p>
  <p>
    <label></label>
    <label></label><label>
    <input type="submit" name="Submit" value="Add Results">
    </label>
  </p>
  </form>
</body>
</html>

•

Join Date: Jan 2006

Posts: 3

Reputation: nsstone is an unknown quantity at this point

Solved Threads: 0

nsstone

Offline

Newbie Poster

Re: PHP mysql drop down populates another drop down

May 4th, 2007

Do you want a server-side refresh of the second SELECT object, or a "<BODY onload=..." javascript that contains all the nested option lists?

The first solution could use AJAX to rewrite the options, triggered by the onchange event of the first SELECT object.

For the second solution, google the EasySelect javascript off the web, then use php to hit your database and write the arrays that Easyselect uses to populate its SELECT options.

•

Join Date: May 2007

Posts: 2

Reputation: danielwoodhead is an unknown quantity at this point

Solved Threads: 0

danielwoodhead danielwoodhead is offline

Offline

Newbie Poster

Re: PHP mysql drop down populates another drop down

May 4th, 2007

the first solution appears to be what i want, i think this is what i have tried in the code above, call the generate function when the first one is selected

•

Join Date: Oct 2006

Posts: 232

Reputation: Rhyan is an unknown quantity at this point

Solved Threads: 24

Rhyan

Offline

Posting Whiz in Training

Re: PHP mysql drop down populates another drop down

May 4th, 2007

You will have to figure it out using AJAX requests.
Good luck, as it will turn out you have to redesign the code to match the AJAX way.

" Of all the things I've lost,
I miss my mind the most...."
Mark Twain

•

Join Date: Apr 2007

Posts: 136

Reputation: dr4g is an unknown quantity at this point

Solved Threads: 5

dr4g

Offline

Junior Poster

Re: PHP mysql drop down populates another drop down

May 6th, 2007

Yes, AJAX is your solution.
You're looking to use the onChange() javascript function within your Drop-Down box.

Upon changing the value, you'll need to re-grab the information from the database.

AJAX will be the easiest solution to your problem.

GardCMS :: Open Source CMS :: Gardcms.org

•

Join Date: Dec 2006

Posts: 160

Reputation: w_3rabi is an unknown quantity at this point

Solved Threads: 8

w_3rabi

Offline

Junior Poster

Re: PHP mysql drop down populates another drop down

May 6th, 2007

•

Originally Posted by dr4g

AJAX will be the easiest solution to your problem.

AJAX is the only solution

programming is an art ,only for those who can understand it.
- th3 php wr3nch -

•

Join Date: Apr 2007

Posts: 136

Reputation: dr4g is an unknown quantity at this point

Solved Threads: 5

dr4g

Offline

Junior Poster

Re: PHP mysql drop down populates another drop down

May 6th, 2007

That's extremley narrow minded w_3rabi.
There's a number of solutions available.

I give professional honest advice.
So i'm re-interating, that AJAX is the easiest solution to your problem.

GardCMS :: Open Source CMS :: Gardcms.org

•

Join Date: Dec 2006

Posts: 160

Reputation: w_3rabi is an unknown quantity at this point

Solved Threads: 8

w_3rabi

Offline

Junior Poster

Re: PHP mysql drop down populates another drop down

May 7th, 2007

again i would say
is there any solution that does not posts the page back to the sever and does not make your page weight like a ton
except AJAX.......
well i really would like to know about it
and anyway sorry for using the word "ONLY" after rethinking it is not so professional
word ............................

programming is an art ,only for those who can understand it.
- th3 php wr3nch -

•

Join Date: May 2007

Posts: 68

Reputation: johny_d is an unknown quantity at this point

Solved Threads: 4

johny_d

Offline

Junior Poster in Training

Re: PHP mysql drop down populates another drop down

May 7th, 2007

There is at least one other solution to the problem: you save all your data in javascript tables and use onchange() event on one drop down to populate another from respective javascript table. The javascript can be put in an external file (if the information doesn't change to often, so it can be cached by the browsers and load faster) or can be generated on the fly from php, every time the script loads, if it updates often.
I've done this for a site few years ago, when ajax wasn't an option. And it works like a charm