can i put the same data in the two different drop box?

From: Krista (ywan_ip_at_hotmail.com)
Date: 12/31/03 

Date: 31 Dec 2003 11:33:05 -0800

Hi, can i load the same table in the two drop-down list?
$DBName = Krista;
$Query = "select * from Parts";
$ResultPart0 = mysql_db_query($DBName, $QueryPart, $linkID);
$ResultPart1 = mysql_db_query($DBName, $QueryPart, $linkID);
........
        <tr><td>Part Number 0 from Inventory:</td>
        <td><select name =\"Assembled_Part\">");
        $count = 0;
        while($Row0 = mysql_fetch_array($ResultPart0)){
        $count++;
        print("<option value =\"$count\">$Row0[Part_Number]</option>");
        }
        print(" </select></td></tr>

        <tr><td>Part Number 1 from Inventory:</td>
        
        <td><select name =\"Assembled_Part1\">");
        $count1 = 0;
        while($Row1 = mysql_fetch_array($ResultPart1)){
        $count1++;
        print("<option value =\"$count1\">$Row1[Part_Number]</option>");
        }
        print(" </select></td></tr>
        ....................
        ...................

when i do like this, i can load from the table , but i cannot get the
result after i click the submit button. eg.
print $_GET['Assembled_Part0'];
print $_GET['Assembled_Part1'];
it can only show the first one result, do u guys have any idea for me
to solve it? I want to get both of them. Thanks
krista

Quantcast