Inserting into a mysql database- Young Entrepreneurs Making Money Online

Homepage Forum Interviews Rich List Blog Directory Creating Websites Make Money News Advertise Contact Us

Inserting into a mysql database
A beginners guide to Inserting into a mysql database

Category: Coding
Views: 1559

Inserting into a mysql database Inserting into a mysql 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.

If you would like more help with this tutorial please register and visit the forum.

About Michael

Michael Dunlop personal statement

“But I am already older than 21”, I hear you cry. Don’t worry, despite the name, the information and advice is more geared towards retiring prior to having a fake hip installed.