HELP!!insert data in database using user input

[avishek.gc]

[b]in one area i got stuck,when i try to insert data into database, it is not working,suppose when i take user input from a form and try to echo user input in other page it is working...but when i try to insert that user input into my database...it is not inserted in database.do i have to change anything in php.ini file..
i am using the following code..but data is not inserted in the database. my insert.php is given(where i am taking only name and roll as an input from a form and try to insert it into database but it is not working...data is not inserted....the php file is given below...[/b][size=4]


<?php
$link = mysql_connect('localhost', 'root', '*****');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'connected succesfully';
mysql_select_db('mydb');
$query = "INSERT INTO new (name,roll) values ($_POST['name'],$_POST['roll'])";
$result = mysql_query($query);
mysql_free_result($result);
mysql_close();

?>
PLEASE HELP ME IF ANYBODY KNOWS THE ANSWER.........
THANKS A LOT FOR READING...
[email protected]

[drekha]

Were you able to solve the problem .i am having the same problem and working on it since a week.I am using MSAccess as data base and Apache as a server.But I am not able to insert in my table through form
iF YOU KNOW THE ANSWER PLEASE ...HELP.