Select form with database help

[Antiquated]

Hello everyone and thank you for taking the time to read this. I am very new to coding and I am helping a friend with a website. I'm trying to create a form with a <select> dropdown and filling the options with items from a database, there are very man items so I'm not sure 100% how to go about this, I have some code but I know it's wrong I'm just looking for a nudge in the right direction, any help is appreciated the code can be found below:

 

 

<div style="float:left;">
                                            <select>
                                            $team = $sql->query("SELECT * FROM teams WHERE arenaid ='$platid'");
                                                <option value="<?echo $teams>"></option>
                                            </select>
                                        </div>

 

Again, thank you for taking the time to read this and thank you also for any help you can provide.