double results in my array ( mysql_fetch_array )

by

From the manual:

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

By default, mysql_fetch_array gives both associative and numeric indexes. You don’t want this. You can limit it with the second parameter:

$query_result_array = mysql_fetch_array($query_result, MYSQL_NUM); // numeric keys only
$query_result_array = mysql_fetch_array($query_result, MYSQL_ASSOC); // associative keys only

You can also use mysql_fetch_row to only get numeric keys, or mysql_fetch_assoc to only get associative keys.

$query_result_array = mysql_fetch_row($query_result); // numeric keys only
$query_result_array = mysql_fetch_assoc($query_result); // associative keys only

More Related Contents:

  1. Php mysql tabs don’t output [closed]
  2. Update Mysql except when field not null
  3. How can I prevent SQL injection in PHP?
  4. UTF-8 all the way through
  5. SQL injection that gets around mysql_real_escape_string()
  6. Can I mix MySQL APIs in PHP?
  7. How to include a PHP variable inside a MySQL statement
  8. jQuery Validate remote method usage to check if username already exists
  9. MySQL query to get column names?
  10. How do you connect to multiple MySQL databases on a single webpage?
  11. PDO get the last ID inserted
  12. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  13. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  14. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  15. Insert/update helper function using PDO
  16. MySQLi count(*) always returns 1
  17. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  18. Formulas to Calculate Geo Proximity
  19. Get all child, grandchild etc nodes under parent using php with mysql query results
  20. mysql query result in php variable
  21. mysql_real_escape_string is undefined
  22. Unknown database error in PHP but it exists in PHPMyAdmin
  23. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  24. Can I blindly replace all mysql_ functions with mysqli_?
  25. How do detect that transaction has already been started?
  26. return multiple response data in one response
  27. CakePHP Database connection “Mysql” is missing, or could not be created
  28. MySQL Alter Table Add Field Before or After a field already present
  29. mysql error ‘TYPE=MyISAM’
  30. Storing datetime as UTC in PHP/MySQL

Leave a Comment