Feb 23, 2007 #1 SHANG Experienced Elementalist 10 Happy Years Joined Sep 14, 2006 Messages 229 Reaction score 0 how to insert data in mssql? i have config.php and etc.. im connecting to my mssql byt i dunno how to insert data in a table?
how to insert data in mssql? i have config.php and etc.. im connecting to my mssql byt i dunno how to insert data in a table?
Feb 23, 2007 #2 Y YukiNeko Junior Spellweaver 10 Happy Years 20 Happy Years Joined Mar 21, 2006 Messages 129 Reaction score 0 INSERT INTO table_name (column1, column2) VALUES (value1, value2) (note that string value fields have to be defined with quotations e.g 'mytext')
INSERT INTO table_name (column1, column2) VALUES (value1, value2) (note that string value fields have to be defined with quotations e.g 'mytext')
Feb 23, 2007 #3 M Matt Meh Vicennium 1000 Posts Trophy Point Collector 20 Happy Years Joined Aug 16, 2006 Messages 1,317 Reaction score 49 $result = mssql_query("INSERT INTO table_name (Column, Column2) VALUES ($such, $such2)");
Feb 24, 2007 #4 hacker_kts --- 500 Posts 20 Happy Years Joined Aug 18, 2004 Messages 641 Reaction score 3 Try reading this first, PHP MySQL Tutorial : Insert Data To MySQL Database
Feb 24, 2007 #5 L -Legend- Custom Title Activated Loyal Member Joined Dec 14, 2005 Messages 2,894 Reaction score 3 Lol You have to make it in access, then Import Data ( I Use MySQL its much easier to me, with a Program called "NaviCAT" easy run through etc"
Lol You have to make it in access, then Import Data ( I Use MySQL its much easier to me, with a Program called "NaviCAT" easy run through etc"
Mar 1, 2007 #6 username1 Divine Celestial 500 Posts Trophy Point Collector 20 Happy Years Joined Jul 7, 2004 Messages 852 Reaction score 5 sage MySQL and MSSQL are very similar. Learn one, and the other will become clear.