Jump to content

Php Posting Values Incorrectly


sunziun

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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"?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...