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... avishek.gc@gmail.com