Double Selecting Data From MySQL

Question

Hey so i am trying to grab data from mysql database and i am getting double the data in my table when i grab the data from mysql?

Here is the code i am using to make the graph.

$query = "SELECT id,username FROM users";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
    foreach($row as $id => $val)
    {
        echo 
        "<tr>
        <td>" . $row['id'] . "</td>
        <td>" . $row['username'] . "</td>
        <td></td>
        <td></td>
        </tr>";
    }
}

This is the result: enter image description here

score 1 · Answer 1 · answered Nov 19 '14 at 06:07

Use onli sing loop...while loop or foreach...you are using both the loops e.g foreach inside while..Use that

$query = "SELECT id,username FROM users";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{

        echo 
        "<tr>
        <td>" . $row['id'] . "</td>
        <td>" . $row['username'] . "</td>
        <td></td>
        <td></td>
        </tr>";

}

score 1 · Accepted Answer · answered Nov 19 '14 at 06:08

Use only single loop

while($row = mysql_fetch_assoc($result))
{
      echo 
        "<tr>
        <td>" . $row['id'] . "</td>
        <td>" . $row['username'] . "</td>
        <td></td>
        <td></td>
        </tr>";
}

instead of double loop

while($row = mysql_fetch_assoc($result))
{
    foreach($row as $id => $val)
    {
        echo 
        "<tr>
        <td>" . $row['id'] . "</td>
        <td>" . $row['username'] . "</td>
        <td></td>
        <td></td>
        </tr>";
    }
}

Wow thank you feeling stupid since it was a quick easy fix haha. — Terrii, Nov 19 '14 at 06:09

score 1 · Answer 3 · answered Nov 19 '14 at 06:11

1

Use "mysql_fetch_array" instead of "mysql_fetch_assoc":

$query = "SELECT id,username FROM users";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
    echo 
    "<tr>
    <td>" . $row['id'] . "</td>
    <td>" . $row['username'] . "</td>
    <td></td>
    <td></td>
    </tr>";
}

answered Nov 19 '14 at 06:11

Partha Mitra

130
7

Whats the difference between the two do you know? – Terrii Nov 19 '14 at 06:13
1

@Terrii Check the difference from this [answer](http://stackoverflow.com/questions/1536813/mysql-fetch-array-mysql-fetch-assoc-mysql-fetch-object) – Gunaseelan Nov 19 '14 at 06:14
mysql_fetch_assoc(): Fetch a result row as an associative array – Partha Mitra Nov 19 '14 at 06:16
mysql_fetch_array(): Fetch a result row as an associative array, a numeric array and also it fetches by both associative & numeric array. – Partha Mitra Nov 19 '14 at 06:17

Double Selecting Data From MySQL

3 Answers3