How to remove column name while retrieving data

Why not use taifuns method which is not depends on any extension.


Maybe because he didn’t know that the service there was so bad ? :frowning_face:

Especially when you start with Kodular you just make mistakes and for the community is actually there.

I also had problems with Kodular and SQL at the beginning. I’m almost desperate no matter what extension I used, I just couldn’t get SQL up and running. Only @Taifun then explained to me in a subordinate clause that I cannot write on the assets folder while the app is running.

Information that should actually be somewhere in the documentation, right?
regards Franz

1 Like

That extension just is the puravida method. Even he uses the script from him. Exactly the same scriot

The .php script you are using in the DEEP HOST extension is from that link I posted above. You will use the blocks that are on the page. And it will use the same .php script.
DEEP HOST does not respond to our emails.

1 Like

I already mentioned taifuns method not extension which depends only on blocks of web with post method

1 Like

Here we have more information about MySQL, maybe you can get some ideas.

the result which will be returned from the MySQL database is a table in csv format
usually you convert that table into a list of lists using the list from csv table block
and now if you want to remove the header row, just use the remove list item block together with index 1


See I have a table in MySQL

When I am calling this data see my blocks:-

In list which I have called is showing on top of my result as like.

I don’t wants to show this.
Please suggest me method to remove this.

Can you show related blocks?


These are only blocks for this.

Use this block in Got_All_Columns event before setting lable text to values:


But @vknow360 I am not using global variable in it

He is only defining process.
In global variable use what you get from mysql.

@ShaikhSajidAli I am calling all columns so what to place in global variable? Please help me

What you get in all columns.
From which list you are working use that list after getting data

Can you please share me blocks for this.

Hi @Sanvi
Sorry but you are not trying to solve your problem yourself.
I know you have joined commuity (perhaps Kodular also) 2 days ago so everything is new to you.And this is the best time to learn from yourslef by trial and error method.
Most of the best Developers have replied on this topic giving you a lot of hints to solve your problem but I think you are interested in solving problems and want ready made blocks which you can copy-paste in creator.
So I admit that I am unable to help you and this ‘guilt’ forces me to do this:

I am sorry si.r

see again my last answer assuming, you are trying to get several columns

A very good way to learn App Inventor or Kodular is to read the free Inventor’s Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks.
There is a free programming course here Course In A Box and the aia files for the projects in the book are here: App Inventor 2 Book: Create Your Own Android Apps
How to do a lot of basic things with App Inventor are described here: How do you...? .

Also do the tutorials Tutorials for MIT App Inventor to learn the basics of App Inventor, then try something and follow the Top 5 Tips: How to learn App Inventor


U can remove coloumn names by running a query but don’t use extension for mysql use PHP scripts which allows u to run queries and then use this query to remove column names

– without column headings
select column_name ‘’
from Table;

Try this query and it will work​:+1:

1 Like