MySqli changes the last column in the query to the table's name

[shedokan]

I have this code:

$sql = 'select column1,column2,column3 from table;';
$result=$mysqli->query($sql) or die($mysqli->error);
while($t = $result->fetch_assoc()){
  print_r($t);
}

 

And what I get is this:

Array

(

    [column1] => value of column1

    [column2] => value of column2

    [ table ] => value of column3

)

 

Why did mysqli change column3 to table? what am I doing wrong?

 

Thanks.

[andrewgauger]

You don't want a semi colon in there.  Only use semicolons in the actual mysql cli prompt.

[shedokan]

I removed it, and it's the same problem.

[PFMaBiSmAd]

It's more likely that you have an error in your actual code, because for a table like you show, the code you did post works correctly (just tested) and that's not your actual code.

[Mchl]

Nothing wrong with this example. Show us actual query instead.

[shedokan]

The actual query has a WHERE after it, but I tried removing the WHERE and it's still problematic:

select entry,language,tokenmap from tokenize

[PFMaBiSmAd]

It's more likely that you have an error in your actual code ...

 

If you seriously want someone in a forum to help find what is wrong, you need to be upfront and provide all the relevant information that you know about the problem. That includes the code that exhibits the problem, the expected results, and the actual results.

 

Don't play around with changing names or interpreting the output you are getting. Just post actual information and actual results.

[shedokan]

I'm not, you can clearly see from my first example that somehow colum3 got the table's name in the example and in the real query tokenmap got the name of the table which is: tokenize

 

I have given all of the code which I used to test this, and the result values are not important since it's the column name that has a problem not the values returned.