[maweber98]

I need to create a drop down menu in PHP that is populated by an Mysql table. The table consists of 3 field "ID", "Breeds", and "Sizes".

Table Structure:
CREATE TABLE `Halti_Sizes` (
`Breeds` varchar(255) default NULL,
`Sizes` varchar(255) default NULL,
`ID` int(255) NOT NULL auto_increment,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

I want the drop down menu to be populated by the "Breeds" field. Once a breed is selected I want the corresponding "Sizes" and "ID" from that row to be displayed. What is the easiest way to accomplish this. Any help would be greatly appreciated. Thanks so much!

[ben.periton]

Javascript with arrays would probably be the easiest way to go, or you could try using xmlHTTPRequest function. (http://www.webpasties.com/xmlHttpRequest , http://xulplanet.com/references/objr...tpRequest.html , http://www.fiftyfoureleven.com/resou...quest/examples)

Got to go out, but Ill post a javascript example later on when I get in

[tallpaul858]

Hi There,

I wrote this script for displaying car ref numbers and names, look at http://www.lotus.uk.net/testdrive.php for an example.

This is within a form and the content of each option's value is the ID for that row, this ID is sent to the next page and can be used in another sql query to display the row you want.

SEE COMMENTS IN PHP CODE BELOW

Code Below:

<select name="car_id" class="searchboxfields">
<option value="">Select... (Leave For No Car)</option>
<option value="">-- Used Cars --</option>

PHP Code:

<?php

              

                                         include("cms/connect.php"); //connect to database



              

              $sql = "SELECT * FROM tblcar";



//query

              

              $result = mysql_query($sql);

              

              $num = mysql_numrows($result); //number of rows returned



              

              $i = 0; // $i is counter

              

              while ($i < $num) { // while loop goes through each row and extracts, in this case, ref, name (to display) and id (for sending to another page)

              //content of each row

              $id = mysql_result($result,$i,'id');

              $ref = mysql_result($result,$i,'ref');

              $name = mysql_result($result,$i,'name');

              



//outputs option values into dropdown menu

              echo("

              

              

              <option value='".$id."'>REF: ".$ref." | NAME: ".$name."</option>

              

              

              ");



              $i++;

              }

              include("cms/close.php");

              

              

              unset($id,$ref,$name);



              ?>

</select>

[Jaffizzle]

PHP Code:

<form action=<?=$_SERVER['PHP_SELF']?> method=post>

<select name="breeds" onchange="this.form.submit();">

<?php $sql="SELECT * FROM Halti_Sizes";

$result=mysql_query($sql);

while($row=mysql_fetch_assoc($result);

if($row['ID']==$_POST['breeds']) $selected="selected"; else $selected="";

echo "<option {$selected} value=\"{$row['ID']}\">{$row['Breeds']}</option>";?>

</select>

</form>



<?php

if($_POST['breeds']){

    $sql="SELECT *  FROM Halti_Sizes WHERE ID='{$_POST['breeds']}'";

    $result = mysql_query($sql);

    $row=mysql_fetch_assoc($result);

    echo "Breeds:  ".$row['Breeds']."<br>Sizes:  ".$row['Sizes']."<br>ID:  ".$row['ID']."<br>";

}

?>

give that a try, i didnt test it but im pretty sure it works.

[maweber98]

I tried the code listed, but I think there is a syntax error. I haven't been able to pin point it. All I get is a blank white page. If you could take another look and let me know if I'm doing something wrong. Thanks so much!!

[Jaffizzle]

err hold up lemme redo the code real fast there are plenty of small syntax errors

PHP Code:

<?php //include db connection here// ?>

<form action=<?=$_SERVER['PHP_SELF']?> method=post>

<select name="breeds" onchange="this.form.submit();">

<?php $sql="SELECT * FROM Halti_Sizes";

$result=mysql_query($sql);

while($row=mysql_fetch_assoc($result)){

if($row['ID']==$_POST['breeds']) $selected="selected"; else $selected="";

echo "<option {$selected} value=\"{$row['ID']}\">{$row['Breeds']}</option>"; }?>

</select>

</form>



<?php

if($_POST['breeds']){

    $sql="SELECT *  FROM Halti_Sizes WHERE ID='{$_POST['breeds']}'";

    $result = mysql_query($sql);

    $row=mysql_fetch_assoc($result);

    echo "Breeds:  ".$row['Breeds']."<br>Sizes:  ".$row['Sizes']."<br>ID:  ".$row['ID']."<br>";

}

?>

like i said the code wasnt tested, but if you have some PHP familiarity it should be pretty simple to get it working and understand the logic.