PHP - little help

[Aleh]

Hi!
I have little problem.
I have a script:

    <span >Choose a character: </span>   
    <form action='?' method='POST'>   
    <select name='postac'> <option value='0'>(Choose character)</option>";  
              
              
        $players_choose = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();  
          
        foreach($players_choose as $player)  
        {  
            $main_content .= '<option value="'.$player['id'].'"';  
            if($player['id'] == $char_id)  
            $main_content .= ' selected="selected"';  
            $main_content .= '>'.$player['name'].'</option>';  
        }  
        </select>

How to do that in a database to save the name you chose and not his ID?

 

[Vesgo]

I did not understand what you really want to do

Explain it a little bit more and i will try to help you!

 

[Zisly]

You aren't saving anything in that code.

Anyway, I'll take a guess that you want this:

   <span >Choose a character: </span>   
    <form action='?' method='POST'>   
    <select name='postac'> <option value='0'>(Choose character)</option>";  
              
              
        $players_choose = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();  
          
        foreach($players_choose as $player)  
        {  
            $main_content .= '<option value="'.$player['name'].'"';  
            if($player['id'] == $char_id)  
            $main_content .= ' selected="selected"';  
            $main_content .= '>'.$player['name'].'</option>';  
        }  
        </select>

 

[Aleh]

You aren't saving anything in that code.

Anyway, I'll take a guess that you want this:

   <span >Choose a character: </span>   
    <form action='?' method='POST'>   
    <select name='postac'> <option value='0'>(Choose character)</option>";  
              
              
        $players_choose = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();  
          
        foreach($players_choose as $player)  
        {  
            $main_content .= '<option value="'.$player['name'].'"';  
            if($player['id'] == $char_id)  
            $main_content .= ' selected="selected"';  
            $main_content .= '>'.$player['name'].'</option>';  
        }  
        </select>

Thanks for help. It works