MYSQL Problem

[Luk-ry]

I have a problem with my script:

function sqlgetaccountinfo(playerSource)
playername = getPlayerName( playerSource )
database = mysql_connect ("localhost", "root", "*****", "mta san andreas accounts")
isNameSQL = mysql_query ( database, "SELECT * FROM name" )
outputChatBox ("x"..tostring(isNameSQL).."x", playerSource)
isTableCreated = mysql_query ( database, "CREATE TABLE playername(user char (20) );")
outputChatBox("x"..tostring(isTableCreated).."x", playerSource)
end
 
addCommandHandler("x", sqlgetaccountinfo)

It only makes a table with the name playername. How can I make that it writes the player name into the table?

PS:Sorry for my bad english

Edited August 8, 2010 by Guest

[The_Ex]

mysql_query ( database, "INSERT INTO playername VALUES ('"..playername.."')")

Should be something like that if i got you right...

Just learn SQL, you wouldn't have those questions if you had spent some time to learn SQL statements.

[dzek (varez)]

i think you dont understand SQL at all

for table creating its better to use CREATE TABLE IF NOT EXIST ...

and are you sure you need MySQL? SQLite should be enough for most uses, only for advanced things you need MySQL.

btw: you called your database "mta san andreas accounts"? And it's working??

[Luk-ry]

i think you dont understand SQL at all

for table creating its better to use CREATE TABLE IF NOT EXIST ...

and are you sure you need MySQL? SQLite should be enough for most uses, only for advanced things you need MySQL.

btw: you called your database "mta san andreas accounts"? And it's working??

Yes, the database is working

[dzek (varez)]

can i ask how you created it? its on dedicated hosting on installed on your local pc?

[Luk-ry]

It's a mysql server on my local pc

[dzek (varez)]

and how you have created database? via command line or some kind of database managing app?

[Luk-ry]

database managing app: http://www.heidisql.com/

[dzek (varez)]

free one, nice.

i used 3 applications and im still sure phpMyAdmin is best for it (but it require www server with php)..

okay, end of this little offtopic