At this time after i run the next query SELECT * FROM table I recieve the next response

array(1) {
  [0]=>
  array(36) {
    [0]=>
    string(5) "31764"
    ["id"]=>
    string(5) "31764"
    ...
  }
  ...
}

As you can tell I get 2 of the identical data ("" and "id"). Can there be in whatever way I'm able to only get "id" and never ""?

Look into the documentation of [cde], the 2nd argument enables you to definitely specify what type of array to come back:

The kind of array that's to become fetched. It is a constant and may go ahead and take following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH.

Or you might only use [cde].

you are able to write the sql much like : Choose 'id' FROM table it wil just return