View call return the result x 2

Question

I have a problem with a view call in php:

 $query = "SELECT * FROM contact_numers_view";
 $result=mysql_fetch_array(mysql_query($query));
 //conversion from array to string
 $separater = implode(",", $result);

on echo $separater I should get a number 100020 but instead of this I get it doubled like 100020, 100020

Any hint about what is wrong?

The view is:

CREATE VIEW contact_numers_view AS
            SELECT COUNT(*) FROM contacts;

please provide what is the result by printing the output for `$result` — prava, Jun 04 '14 at 10:30
`array(2) { [0]=> string(6) "101912" ["COUNT(*)"]=> string(6) "101912" }` that is the var_dump result. I don't understand why there are 2 arrays. — SilenceIsGolden, Jun 04 '14 at 10:32

score 1 · Accepted Answer · edited May 23 '17 at 10:32

1

mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both

see http://in3.php.net/mysql_fetch_array

Use result_type as MYSQL_NUM

In you code do as follows,

 $query = "SELECT * FROM contact_numers_view";
 $result=mysql_fetch_array(mysql_query($query), MYSQL_NUM);
 //conversion from array to string
 $separater = implode(",", $result);

And moreover mysql_* functions are officially deprecated (as of PHP 5.5. It's likely to be removed in the next major release)

See here Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 10:32

Community

1
1

answered Jun 04 '14 at 10:33

Dushyant Joshi

3,672
3
28
52

`MYSQL_NUM` was the solution. Thank you! – SilenceIsGolden Jun 04 '14 at 10:38

View call return the result x 2

1 Answers1