PHP query not showing all results in html table : <p>So I have the following query to show all users from my database: </p>

<pre><code>&lt;ul class="names"&gt;
                    &lt;table&gt;
                        &lt;tr&gt;
                            &lt;th&gt;Navn&lt;/th&gt;
                            &lt;th&gt;Email&lt;/th&gt;
                            &lt;th&gt;Score&lt;/th&gt;
                        &lt;/tr&gt;
                    &lt;?php
                    $connection = mysql_connect('localhost', 'users', 'password'); //The Blank string is the password
                    mysql_select_db('users');

                    $query = ("SELECT * FROM oneusers"); //You don't need a ; like you do in SQL
                    $result = mysql_query($query);

                    $row=mysql_fetch_array($result);

                    while($row = mysql_fetch_array($result)){   //Creates a loop to loop through results
                    echo "&lt;tr&gt;&lt;td&gt;" . $row['iUserName'] . "&lt;/td&gt;&lt;td&gt;" . $row['iUserEmail'] . "&lt;/td&gt;&lt;td&gt;" . $row['iUserCash'] . " DKK&lt;/td&gt;&lt;/tr&gt;";  //$row['index'] the index here is a field name
                    }

                    mysql_close(); //Make sure to close out the database connection
                    ?&gt;
                    &lt;/table&gt;
                &lt;/ul&gt;
</code></pre>

<p>But for some reason it doesnt show all the data. </p>

<p>In only shows the user with iUserId 2 and not one. </p>

<p>Does anyone have an idea of what might be wrong? </p>

<p>I can log in with iUserId 1's credentials, and it shows fine the info on the login page. </p>

<p>But not here :S</p>
