Skipping first line of db

[TapeGun007]

Here is my code:

    <form method="post" action="state.php">
        <select name="state" id="state" onchange="this.form.submit()">
        <option></option>
        <?php
            $sql = "SELECT * FROM States";
            $rs=$con->query($sql);
            $rs->data_seek(0);
            $row = $rs->fetch_assoc();
            while($row = $rs->fetch_assoc()){
                $StateID = $row[StateID];
                // Check to see which state was selected so it stays in drop down box.
                if($StateID==$StateSelected){
                    $selected = " selected";
                }else{
                    $selected = "";
                }
            echo "<option value='".$StateID."'".$selected.">".$row['StateName']."</option>";
            }
        ?>
        </select>
    </form>

I am befuddled as to why when pulling the state from the db, that the first state Alaska does not show up in the drop down.  I double checked that Alaska is in fact in the db as the first entry.  I know this has to be one of those stupid things that I am not seeing for some reason.

[mac_gyver]

look at your code, between where you are executing the sql query and where you are looping over the data from that query.

[TapeGun007]

Bwahaha.  Ok ok ok. I KNEW it was something very stupid.

 

Thanks man.

 

Something I think I just stare too hard and need another set of eyeballs.