ansaurus

Question

Answer 1

+6 A:

This is what mysql_fetch_array does if you don't provide a second argument: gets you an associative array where the value is mapped to both the column name and the column index.

You can provide MYSQL_ASSOCas a second argument to have only the column name (or use mysql_fetch_assoc).

Victor Nicollet 2009-12-22 17:09:42

Answer 2

+1 A:

Change

while ($r = mysql_fetch_array($res)) {

to

while ($r = mysql_fetch_array($res, MYSQL_NUM)) {

or

while ($r = mysql_fetch_array($res, MYSQL_ASSOC)) {

The default value for the 2nd argument to mysql_fetch_array() is MYSQL_BOTH which gives you back an array indexed numerically and associatively. Alternatively, you could use mysql_fetch_row() (returns a numerically indexed array) or mysql_fetch_assoc() (returns an associative array) instead of mysql_fetch_array().

Asaph 2009-12-22 17:10:06

MYSQL_NUM will work with the code that controlfreak123 has, but it generally is a bad approach, because you should never assume the select fields come out of the database in the same order. The ordering can change, if you change your CREATE TABLE a bit, or when you use SELECT field1, field2 instead of *

Anti Veeranna 2009-12-22 17:14:21

@Anti Veeranna: How is `MYSQL_NUM` any different than `MYSQL_ASSOC` if you iterate over the results using `foreach`?

Asaph 2009-12-22 17:29:58

Answer 3

+1 A:

You are probably fetching your MySQL result array in the default mode of MYSQL_BOTH.

Try this:

while ($r = mysql_fetch_array($res,MYSQL_ASSOC)) {
             echo "<tr>";
     foreach($r as $rs){
                 echo "<td>$rs</td>";
                 }
             echo "</tr>";
       }

If you don't specify the second argument to mysql_fetch_array(), then MYSQL_BOTH is used, and you end up with both an associative array index of values, and a numeric array index, like this:

array(0 => 'field 1 val', 'field1_name'=> 'field 1 val',
      1 => 'field 2 val', 'field2_name'=> 'field 2 val', etc);

Specifying either MYSQL_ASSOC or MYSQL_NUM will only retrieve either the associative values or the numerically indexed values respectively.

zombat 2009-12-22 17:10:23

Answer 4

A:

Easy.

If your SQL query is

SELECT foo FROM bar

then mysql_fetch_array returns 2 results. One with numeric index, one with the field name. Add a print_r($r) into your code to see the behaviour.

Solution? Use mysql_fetch_assoc

Anti Veeranna 2009-12-22 17:10:59

ansaurus

tags:

views:

answers:

PHP echo duplicate rows when none exist

related questions