MySQL question

[K4stic]

with what function

dbExec 
dbQuery 

and how like i wonna create a table bans and to have

indexes:

username

serial

[Tete omar]

Use:

dbConnect 

[K4stic]

this using to connect to the MySQL or SQL no to create tables

[iPrestege]

'dbExec' Use this function to create a table .

[Tete omar]

MySQL syntax looks like SQLite one, so you can try reading this function:

executeSQLQuery 

Other than that , i don't know.

[K4stic]

executeSQLQuery 

This function executes an arbitrary SQL query and returns the result rows if there are any. It allows parameter binding for security (SQL injection is rendered impossible).

that function SQL only i need MySQL

[Tete omar]

And i said the syntax is same with SQLite

[Jacob Lenn]

dbQuery(handler, "CRATE TABLE IF NOT EXISTS name(column1 INT, column2 VARCHAR(255))") 

[Tete omar]

dbQuery(handler, "CRATE TABLE IF NOT EXISTS name(column1 INT, column2 VARCHAR(255))") 

Thats what i meant.

[K4stic]

so this is good?

dbQuery(handler, "CREATE TABLE IF NOT EXISTS accounts(username, password)") 

[iPrestege]

Where's handler defined at?

[K4stic]

at connection just don't show it

just asking if i do true the code

[iPrestege]

OK That's should work .

[K4stic]

Thx

[iPrestege]

You're welcome .

[Kenix]

Use dbExec if you don't want to do something with result. In your case.