[Exolent[jNr]]

Originally Posted by lucas_7_94 new i doesnt should be new i = 0?

Default value is 0, setting it isn't required.

[lucas_7_94]

Originally Posted by Exolent[jNr] Default value is 0, setting it isn't required.

ah okei.

[ARES[ro]]

By the way, I tried formating a huge query like this for SQLx when I was working on one of my projects and it was capped at a certain length.

[davidto1995]

now , no error found

but the data will not save

i think it may be related to MySQL Server

how to create a MySQL Server?
It needs a software?

i am not sure what i should filled in the parameters(host, username, password, database)

[fysiks]

Originally Posted by davidto1995 now , no error found but the data will not save i think it may be related to MySQL Server how to create a MySQL Server? It needs a software? i am not sure what i should filled in the parameters(host, username, password, database)

Are you saying that you haven't even connected to the MySQL database? How can you test this without connecting to a database?

[davidto1995]

Originally Posted by fysiks Are you saying that you haven't even connected to the MySQL database? How can you test this without connecting to a database?

no.
but i am confused with MySQL(heard, never dealt with it)

i google MySQL
i install a software which is provided by that website
http://www.mysql.com/downloads/mysql/(MySQL Community Server 5.5.15)

and i type in these in the script(dun know if it is correct):
host: localhost
username: root
password: (i type in the password that i registered in installation , but i searched and i found that othes did not type in anything)
database: MySQL(i dun know what shuold be filled in)

however , data did not save(because it is not saved , i am not sure that data can be loaded)

through searching , i know that i can host a MySQL database on web
btw , i dun know which supports external connection..

[Exolent[jNr]]

If no data is saved, then there's something wrong with your INSERT/UPDATE statement.

[lucas_7_94]

And you can use SQLite too.

[davidto1995]

Originally Posted by Exolent[jNr] If no data is saved, then there's something wrong with your INSERT/UPDATE statement.

YOU MEAN THAT I HAVE NO MISTAKES WITH MY
(HOSTNAME, USERNAME, PASSWORD, DATABASE)?

[Exolent[jNr]]

You should be checking if it can't connect anyway.
Using threaded queries, it gives an error code TQUERY_CONNECT_FAILED for not able to connect.
For non-threaded queries, just check if the db connection is Empty_Handle.