Sql database

[redhippo]

just a noob question

how do i insert data to a sql database?

what parameters are required?

 

[Peter]

the easiest way to input data into a mysql database is too use phpmyadmin http://www.phpmyadmin.net/home_page/ (if you use cpanel it is already there for you in your cpanel just go to the mysql database area and at the botton there is a link)

If you are installing a package they ussually give you a .SQL file which is filled with sql queries that should be uploaded to the database (if they dont give you an installer that is) Alternatively they may provide you with the idnividual queries that can be input in the text box in the sql page of phpmyadmin

 

[redhippo]

hEEEEEEEEEEEEEEEEEElp

can you help out or anybody free to do so??

 

[CreativeLogic]

You should really do some reasearch. I will tell you how but you probably won't understand most of it. Here is a simple PHP query:

mysql_query("INSERT INTO table_name (column1, column2) VALUES($value1, $value2)");

That'll work most of the time. You may need to add slashes or sometimes it's better to do something like this:
mysql_query("INSERT INTO table_name (column1, column2) VALUES(" . $value1 . ", " . $value2 . ")");

And even more. It's best to put `` around column1 and column2 but not required. The reason for this is if you put spaces in the column names which is HIGHLY frowned upon. Also if you name a column a MySQL function. I've done this before and it's given me hours of headaches. Now its the first thing I check for.

 

[delta4]

have you tried phpMyAdmin?

if you want to insert thru php then you would do something like

mysql_query("insert into news set title='news title', author='news author' ");

you would insert a news title and a news author to a table called news and in which exist two fields: title and author.