[Resolved] Ignore the brackets when sending to database.. HOW?

[nicknax]

Hey.

I have recently added brackets next to a field name on a drop down select list for selecting a game winner.

username (division x)

Is there a way to ignore the bits in brackets '(division x)' so just 'username' is posted to the database?

If not, I'll have to revert back without brackets 🙁

[leatherback]

What you have in the option list shoulod not affect the value you add in the value box, assuming you use the proper full html statement:

<select name='somename'>
  <option value="somevalue">somelabel</option>
  <option value="somevalue2">somelabel2</option>
  <option value="somevalue3">somelabel3</option>

</select>

So, please.. What is the dropbox that gives you a headache?

J.

[nicknax]

oh, i don't use manual ones, i use from database.

<td width="64" height="13"><font color=white>Loser:</font></td>
      <td><select size="1" name="losersname" style="background-color:lightblue">

<?php
$db=mysql_connect("localhost", db_user, dbpass);
@mysql_select_db(db_name) or die( "Unable to select database");
$sort = "division, playername ASC";
$sql="SELECT * FROM playerstable ORDER BY $sort";
$result=mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$name = $row["playername"];
$division2 = $row["division"];
?>
<option><?php echo "$name (division$division2)" ?></option>
<?php
$cur++;
}
?>
<option selected>select the loser.</option>
</select></td>

This is part of a form, the form submits to a table for my admin where we validate the username then the score is updated on the table (there's a duplicate of this for loser).

This is mucked up on the admin validation screen, cos it shows as 'username (division1)'. This (division1) bit in brackets causes the sql to not post in the correct entry.

[leatherback]

As I said: Use the full option statement, and you have no problem.

J

[nicknax]

eh? full option?

as i said just a minute ago. It selects all players from db, lists them in the select table, but with their division in brackets, making life easier for the players.

Only trouble is, this is passed on to admin table, which is used as a sql query to update the table where username = "username2" which is basically.. 'username (division2)'

I want this (division2) bit cut off when it's to be posted into the db, so it updates the score succesffuly.

[leatherback]

use:

<select name='somename'>
  <option value="somevalue">somelabel</option>
  <option value="somevalue2">somelabel2</option>
  <option value="somevalue3">somelabel3</option>
</select>

so:

<option value="<?php echo "$name ?>"><?php echo $name (division$division2)" ?></option> 

[nicknax]

ah, gotchya.

Thanks a lot for your help! 😃

[leatherback]

np.
Please mark the thread resolved (LKink at bottom page)