I have a table in my phpmyadmin created and i want to call it as it is on joomla site

The query that runs on joomla site is wrong ..

The table is for example with 10 fields

Field 1=names Field 2=2000 field 3=1900
name 2001 1988
name 2002 1998
name 2001 1980

I set it up on backend and the result in joomla site is

Field 1=names Field 2=2000 field 3=1900
name 2000 1900
name 2000 1900
name 2000 1900


I noticed that the query that runs is ...
Query: SELECT names, 2000, 1900 FROM tablex ORDER BY names ASC LIMIT 0, 30

I run this query to my sql and i got the same result ..

How can i fix that??

Hi,

is the name of your field 1000 and 2000?

best regards,
Viljem