Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / how to write data to the mysql server?

Author
Message
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 11th Apr 2011 07:41
Link
I'm using dbconn, but do not have any command that writes data in the tables of the server!

Please help me!!!!!!!!!!

My project is Phenadlax!!!
Back to top
Profile PM Email
Jimmy
22
Years of Service
User Offline
Joined: 20th Aug 2003
Location: Back in the USA
Posted: 11th Apr 2011 14:39 Edited at: 11th Apr 2011 14:42
Link
http://www.w3schools.com/sql/sql_insert.asp

Edit:

Let me expound. With DBConn it should look something like this:




NaGaFailMo.
Back to top
Profile PM Website
bitJericho
23
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 11th Apr 2011 17:07 Edited at: 11th Apr 2011 17:07
Link
w3schools? Ahhhh!

http://w3fools.com/

http://dev.mysql.com/doc/refman/5.5/en/ Much better link

Also, this book is awesome: http://www.amazon.com/Sams-Teach-Yourself-MySQL-Minutes/dp/0672328631/ref=sr_1_35?s=books&ie=UTF8&qid=1302530813&sr=1-35

[center]
Join the TGC Group!
http://tehcodez.groups.live.com
Back to top
Profile PM Email Website
KISTech
18
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 11th Apr 2011 17:55
Link
Actually, it should be..



result will contain the number of rows affected by the command.

You also use the DBExecute command for UPDATE and DELETE SQL statements.

Back to top
Profile PM Email Website
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 11th Apr 2011 18:44
Link
thank you for all folks, now another question:

How do I set up mysql for a game site and access them through a IP??

My project is Phenadlax!!!
Back to top
Profile PM Email
KISTech
18
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 11th Apr 2011 19:41
Link
..answered in your other thread.

Try not to post the same question in 2 different places.

Back to top
Profile PM Email Website
Edson
15
Years of Service
User Offline
Joined: 21st Dec 2010
Location: Brasil
Posted: 12th Apr 2011 23:48
Link
ok

My project is Phenadlax!!!
Back to top
Profile PM Email
Back to top

Login to post a reply

Server time is: 2026-07-17 14:00:12
Your offset time is: 2026-07-17 14:00:12