Php Posting Values Incorrectly

[sunziun 1]

hello everyone, it is long time ago that i visited this forum. and as i see there is better user interface. i really enjoy it. now to my issue: ap-town.php for example select options are postcodes: NW2-Cricklewood - value="40"N1-Hixton - value="44"NW2-Kilburn - value="39"

<form action="ap-town-process.php" method="post"><select name="town"><option value="" selected="selected">Destination Town</option>	 <?php while($town_rows=mysql_fetch_array($town_result)) { ?>		 <option value="<?php echo $town_rows['lhr_town_value']; ?>"><?php echo $town_rows['lhr_town_to'];?></option>	   <?php } ?>    </select><input type="submit" /></form>

ap-town-process.php

<?php $ap_town_towns=$_POST['town']; $query_towns=mysql_query("SELECT * FROM lhr_town WHERE lhr_town_value='$ap_town_towns'") or die(mysql_error());$fetch_towns=mysql_fetch_array($query_towns); ?> <form action="ap-town-execute.php" method="post"> <input type="text" name="ap_town_dropoff" value="<?php echo $fetch_towns['lhr_town_to'];?>" readonly="readonly" /> <input type="submit" /></form> 

the drop in ap-town.php takes the values from the database and would be processed at ap-town-process.php. if i select NW2-Cricklewood in the ap-town-process.php it would give me N1-Hixton altough the values are completly different. in some cases the values are the same, but the but the names area names different. please help me fix this issue.

[DubStepper 0]

A representation of the database may help us solve this.

[sunziun 1]

Hello DubStepper, that sounds good..but tell me how!?

[justsomeguy 1,135]

The obvious answer is that there are several rows that have the same value for lhr_town_value. MySQL isn't going to return a result that doesn't match the conditions you specify. If it is returning a row then it matched the WHERE clause, so you have multiple records with the same values.

[sunziun 1]

thanks justsomeguy, your hint was helpful. to make each value unique i've just added i. e. 45.0001, 45.0002, 43.0003 instead of just 45, 45, 43. this way the return of MySQL works fine. by the way, how do i set this topic to "solved"?

Edited January 6, 2012 by sunziun

[justsomeguy 1,135]

You don't need to set it to solved, but you can edit the subject if you want to.