Query outputting data twice

Question

I have the following snippet:

<?php
$query = mysql_query("SELECT * FROM users") or die(mysql_error());
echo "<table>";

while ($row = mysql_fetch_array($query))
{
    echo "<tr>";

    foreach($row as $value)
    {
        echo "<td>".$value."</td>";
    }

    echo "</tr>";

}

echo "</table>";?>

This snippet should, I think, output each piece of data from the table once. The problem is, I get it twice. So, for example

[email protected] [email protected] Joe Joe Bloggs Bloggs

Why might it be doing this?

Bart Friederichs · Accepted Answer · 2013-03-18 20:22:26Z

6

By default, mysql_fetch_array does both numeric and associative (MYSQL_BOTH), giving you two keys each.

If you want numeric keys, use

while ($row = mysql_fetch_array($query, MYSQL_NUM))

if you want associative array, use:

while ($row = mysql_fetch_array($query, MYSQL_ASSOC))

Note also, that the mysql_* functions are deprecated and you should use MySQLi or PDO instead.

answered Mar 18, 2013 at 20:22

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Britmerican Over a year ago

And a lesson was learned that day, thank you. Will mark as correct when timer permits.

michi · Accepted Answer · 2013-03-18 20:25:46Z

0

change your code:

while ($row = mysql_fetch_assoc($query)) {
...

AND... mysql_* functions are deprecated, please consider moving to mysqli_* or PDO.

There, you will find possibilities to fetch one or all rows to an array...

with numeric indices only
with associative indices only
with both (--> double output in your case)

answered Mar 18, 2013 at 20:25

michi

6,6255 gold badges35 silver badges56 bronze badges

Comments

UnholyRanger · Accepted Answer · 2013-03-18 20:26:41Z

0

MySQL Fetch Array

The function by default uses MYSQL_BOTH which will give you an associative array along with a numbered array. For example:

Table:

name | emai
joe     [email protected]

The array returned will have

$row{
    [0] = "joe",
    ['name'] = "joe",
    [1] = "[email protected]",
    ['email'] = "[email protected]",
    }

You will have to use MYSQL_ASSOC or MYSQL_NUM as the second argument

NOTICE: Do not use MySQL_* functions for they have been deprecated as of PHP 5.5. Use PDO or MySQLi_* instead

answered Mar 18, 2013 at 20:26

UnholyRanger

1,97114 silver badges24 bronze badges

Collectives™ on Stack Overflow

Query outputting data twice

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related