[Resolved] Select Menu

NZ_Kiwi

OKay i've got a two db and one has the information i need but the names ect are link by a id.. the second db has the names ect in english... i want to use the first db to find all my options but i want to match the id off the second one to then show the name....

have a look at my code...

for some reason it does not work... any idea why??

<select size="1" name="main_comp_id" style="font-family:Verdana; font-size:10pt">
<option value"0"> ------- SELECT ------- </option>
<?php
$result2 = mysql_query ("SELECT * From results_comp_run order by comp_run_id");
$row2 = mysql_fetch_array($result2);

$main_comp_id = $row["main_comp_id"];

$result = mysql_query ("SELECT * From results_comp where comp_id = $main_comp_id");
while ($row = mysql_fetch_array($result)) {
?>

<option value="<?php echo $row["comp_id"]; ?>"><?php echo $row["comp_name"]; ?></option>

<?php
}
?>
</select>

vornn

Confused?

Let's get this right.

Two tables..

1 value in each table to act as primary key, also used to create a relationship between tables.

You want to get a list, using a field from table 1, of everything in table two which matches.

Am I right?

NZ_Kiwi

Originally posted by vornn
Confused?

Let's get this right.

Two tables..

1 value in each table to act as primary key, also used to create a relationship between tables.

You want to get a list, using a field from table 1, of everything in table two which matches.

Am I right?

Yeah sorry very hard to explain!! but rest easy i've got it sorted... thanks anyway