mysql get data into array show double data

Question

I am trying to retrieve data from MySQL. But my result shows one result 2 time.

my code

$result = mysql_query($sql);
$rows = Array();
while($row = mysql_fetch_array($result)){
  array_push($rows, $row);
}
echo json_encode($rows);

my result

[{"0":"427","id":"427","1":"Alabama","title":"Alabama"}]

RTFM: php.net/mysql_fetch_array the default fetch mode is FETCH_BOTH, which fetches string AND numeric keys — Marc B
– Marc B, Commented Jun 3, 2014 at 21:36

Community · Accepted Answer · 2023-11-17 19:22:09Z

1

By default, mysql_fetch_array will fetch the data in both: array and associative

https://www.php.net/mysql_fetch_array

To overcome this issue, specify the type:

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

Or

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

edited Nov 17, 2023 at 19:22

CommunityBot

11 silver badge

answered Jun 3, 2014 at 21:41

Jehad Keriaki

5455 silver badges10 bronze badges

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

Comments

41eight · Accepted Answer · 2014-06-03 21:43:47Z

0

mysql_fetch_array returns both an associative and numeric array, if you would like to only fetch one or the other specify the result type as either MYSQL_NUM or MYSQL_ASSOC

answered Jun 3, 2014 at 21:43

41eight

1915 bronze badges

Collectives™ on Stack Overflow

mysql get data into array show double data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related