Ad:

PHP Discussion Thread
Unsolved
Views: 18875

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

May 3rd, 2007

PHP mysql drop down populates another drop down

Expand Post »

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

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>

Similar Threads

PHP and MySQL Web Development in PHP
master database with php mysql in Legacy and Other Languages
Flash Poll System using php/mysql for free in Graphics and Multimedia

danielwoodhead

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2007

Permalink

May 4th, 2007

Re: PHP mysql drop down populates another drop down

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.

nsstone

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jan 2006

Permalink

May 4th, 2007

Re: PHP mysql drop down populates another drop down

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

danielwoodhead

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2007

Permalink

May 4th, 2007

Re: PHP mysql drop down populates another drop down

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.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

May 6th, 2007

Re: PHP mysql drop down populates another drop down

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.

dr4g

Reputation Points: 35

Solved Threads: 5

Junior Poster

Offline

136 posts
since Apr 2007

Permalink

May 6th, 2007

Re: PHP mysql drop down populates another drop down

Click to Expand / Collapse Quote originally posted by dr4g ...

AJAX will be the easiest solution to your problem.

AJAX is the only solution

w_3rabi

Reputation Points: 18

Solved Threads: 9

Junior Poster

Offline

160 posts
since Dec 2006

Permalink

May 6th, 2007

Re: PHP mysql drop down populates another drop down

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.

dr4g

Reputation Points: 35

Solved Threads: 5

Junior Poster

Offline

136 posts
since Apr 2007

Permalink

May 7th, 2007

Re: PHP mysql drop down populates another drop down

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

w_3rabi

Reputation Points: 18

Solved Threads: 9

Junior Poster

Offline

160 posts
since Dec 2006

Permalink

May 7th, 2007

Re: PHP mysql drop down populates another drop down

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

johny_d

Reputation Points: 33

Solved Threads: 7

Junior Poster in Training

Offline

92 posts
since May 2007

Permalink

May 7th, 2007

Re: PHP mysql drop down populates another drop down

ya man
nice technique
but is it as efficient as AJAX

w_3rabi

Reputation Points: 18

Solved Threads: 9

Junior Poster

Offline

160 posts
since Dec 2006

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: php+javascript

Next Thread in PHP Forum Timeline: I purchased VBulletin...but

DaniWeb Message

Cancel Changes

User Name
Password