PHP foreach loop returning extra

Question

I have a php script below that I am hoping would return all the values of a sql table. It does do this but also returns a number and value after each of the expected lines

    $condition = "usernames = '$user'  AND password = '$pass' ";
    $result = mysql_query("SELECT * FROM userbase WHERE $condition")  ;

    $row = mysql_fetch_array($result)  ;

    foreach ($row as $k => $v) {
        echo "$k / $v <br>";
        };

    ?>

The results look like this

      0 / Mick Lathrope 
      name / Mick Lathrope 
      1 / op 
      jobtitle / op 
      2 / 07998 783 989 
      phone / 07998 783 989 
      3 / mwl707 
      usernames / mwl707 
      4 / testpass
      password / testpass

All the data is there that i need But why am I also getting a number list ?

Any help please ?

Besides moving to MySQLi or PDO, look at the second argument for MySQL_fetch_array() and in particular the default value — Mark Baker
– Mark Baker, Commented Feb 16, 2013 at 15:20

Mayank K. Swami · Accepted Answer · 2013-02-16 15:25:33Z

2

Use

$row = mysql_fetch_array($result, MYSQL_ASSOC) ;

to index only by column name

edited Feb 16, 2013 at 15:25

Mayank K. Swami

57.3k23 gold badges130 silver badges148 bronze badges

answered Feb 16, 2013 at 15:23

Heberfa

4413 silver badges8 bronze badges

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

Comments

Bhavik Shah · Accepted Answer · 2013-02-16 15:21:31Z

0

because you have used mysql_fetch_array.

If you want only columns then use mysql-fetch-assoc

answered Feb 16, 2013 at 15:21

Bhavik Shah

2,2911 gold badge18 silver badges32 bronze badges

Comments

moonwave99 · Accepted Answer · 2013-02-16 15:21:36Z

0

drop mysql_* for PDO or mysqli;
you want to use mysql_fetch_assoc to get just keys and no number indexes.

answered Feb 16, 2013 at 15:21

moonwave99

22.9k3 gold badges48 silver badges71 bronze badges

Comments

Ivan Ferić · Accepted Answer · 2013-02-16 15:41:39Z

0

According to this you have to specify the result type you want, otherwise you get both: MYSQL_ASSOC or MYSQL_NUM,

Example:

while ($row = mysql_fetch_array($result, MYSQL_NUM)){...}

edited Feb 16, 2013 at 15:41

Ivan Ferić

4,76311 gold badges40 silver badges47 bronze badges

answered Feb 16, 2013 at 15:22

miguel

1

Collectives™ on Stack Overflow

PHP foreach loop returning extra

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related