mysql_fetch_array fetch date fetch each element twice

Question

i hope to iterate the elements fetched from datebase
But the result looks very unexpected .
I found the code below print the $value and echo "<td id=".$key.$tag.">".$value."</td>";twice. Is there anything i misunderstood?

   function selectTable($table){
        $sql= "SELECT * FROM ".$table ;
         $result=mysql_query($sql)
                          or die(mysql_error());
        return $result;
  }

  $table = 'battery_con';
  $result = selectTable($table);
  unset($table);

 while($row = mysql_fetch_array($result)){
        ......
        foreach ($row as $key => $value) {
                  print $value; 
                  echo "<td id=".$key.$tag.">".$value."</td>";
                }       
        .....
    }

off topic, but just to warn you: the mysql_xxx() functions in PHP are deprecated. You should consider using a more modern library such as PDO for your DB code. — Spudley
– Spudley, Commented Jul 29, 2013 at 9:55

Andreas · Accepted Answer · 2013-07-29 10:20:16Z

3

You are using mysql_fetch_array which by default returns an array with two elements per column (this is what the second (optional) paramter means: result_type = MYSQL_BOTH).

One is indexed with an integer representing the column index, one is indexed with the column name.

That's why you get two entries in your list. You would set the second parameter to MYSQL_ASSOC to get just one value per column.

answered Jul 29, 2013 at 10:20

Andreas

1,7912 gold badges15 silver badges26 bronze badges

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

Comments

Sonu Sindhu · Accepted Answer · 2013-07-29 10:13:30Z

3

Please use mysql_fetch_assoc() place of mysql_fetch_array() I hope it will help

answered Jul 29, 2013 at 10:13

Sonu Sindhu

1,80216 silver badges27 bronze badges

2 Comments

andyqee Over a year ago

@sonusindhhu can you explain why?

Sonu Sindhu Over a year ago

mysql_fetch_array return two index one is integer like and second is field name

RafaSashi · Accepted Answer · 2013-07-29 10:40:19Z

1

In addition to @Andreas's answer by default mysql_fetch_array gives both associative and numeric indexes, if you don't want this you can limit it with the second parameter in your while loop:

$row = mysql_fetch_array($result, MYSQL_NUM); // numeric keys only
$row = mysql_fetch_array($result, MYSQL_ASSOC); // associative keys only

As previously mentioned by @sonusindhu you can also use mysql_fetch_row to only get numeric keys, or mysql_fetch_assoc to only get associative keys.

Update

The mysql_xxx() functions being deprecated you should consider using the mysqli_xxx() functions instead.

See the example 1 of the php manual for more details: http://php.net/manual/en/mysqli-result.fetch-array.php

edited Jul 29, 2013 at 10:40

answered Jul 29, 2013 at 10:27

RafaSashi

17.3k8 gold badges90 silver badges99 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_array fetch date fetch each element twice

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related