remove unwanted row in php array

Question

I am displaying data from database using PHP. I am using JSON. but during result, I got unwanted array. This is sample:

while($row = mysql_fetch_array($result))
{
    echo "<pre>"; print_r($row); echo "</pre>";
    //$output[]=$row;
}

Output:

Array
(
    [0] => Ravi Ad
    [title] => Ravi Ad
)

Here I saw , a extra column is displaying name [0]. i hate it and making problem in parsing . May any once can remove it ? i am trying this result:-

Array
(
    [title] => Ravi Ad
)

thank you

Prasanth Bendra · Accepted Answer · 2013-02-08 10:57:20Z

1

try mysql_fetch_assoc

while($row = mysql_fetch_assoc($result))
    {

    echo "<pre>"; print_r($row); echo "</pre>";
    //$output[]=$row;
    }

NOTE : mysql_* is deprectaed in new version of php use mysqli or PDO

ref: http://php.net/manual/en/function.mysql-fetch-array.php

answered Feb 8, 2013 at 10:57

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

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

1 Comment

fsw Over a year ago

this. or read the big red warning here php.net/manual/en/function.mysql-fetch-array.php and use PDO

Manigandan Arjunan · Accepted Answer · 2013-02-08 10:58:44Z

1

use mysql_fetch_assoc($result) instead of mysql_fetch_array($result)

This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

answered Feb 8, 2013 at 10:58

Manigandan Arjunan

2,2651 gold badge25 silver badges43 bronze badges

Collectives™ on Stack Overflow

remove unwanted row in php array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related