Inserting into a sql database

Retire at 21 · 12-10-2006, 01:36 PM

Welcome to the tutorial, inserting into a mysql database is pretty easy.

Code:

mysql_query();

This is the code often used when using mysql query's

Code:

$tablename = 'table_name';
mysql_query("insert into $tablename (row1,row2) values('row1 value','row2 value') ");

This will insert into the table table_name and into the rows row1 and row2, we've also gave the rows some values.

You can add stuff to the end of insert querys like

Code:

mysql_query("insert into table_name (row1,row2) values('row 1 value','row 2 value') limit 1 ");

This will make sure the querry only takes place once.

Register @ Retire at 21 If you like this tutorial

12-10-2006, 01:36 PM	#1 (permalink)
Retire at 21 Status: Junior Member Join Date: Dec 2006 Posts: 25 Trader Rating: (0) TD$: 0.00 Donate	Inserting into a sql database Welcome to the tutorial, inserting into a mysql database is pretty easy. Code: mysql_query(); This is the code often used when using mysql query's Code: $tablename = 'table_name'; mysql_query("insert into $tablename (row1,row2) values('row1 value','row2 value') "); This will insert into the table table_name and into the rows row1 and row2, we've also gave the rows some values. You can add stuff to the end of insert querys like Code: mysql_query("insert into table_name (row1,row2) values('row 1 value','row 2 value') limit 1 "); This will make sure the querry only takes place once. Register @ Retire at 21 If you like this tutorial

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode