form and mysql problem

xxwurmxx

ok its adding the ID but not the rest tell me whats wrong

<form action="insert.php" method="post">
Name: <input type="text" name="name"><br>
Web: <input type="text" name="web"><br>
<input type="Submit">
</form>

and here is insert.php

<?
$username="root";
$password="worm";
$database="worm";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO links VALUES ('','$name','$web')";
mysql_query($query);

mysql_close();
?>

can someone tell me why its not inserting name and web

xxwurmxx

someone anyone please

ScubaKing22

Try using $POST['name'] and $POST['web'] since you're accessing variables in the HTTP_POST_VARS array and not in the insert.php page.

xxwurmxx

can u repost the code so i know how it should look cause im gettign a error the way i did it

ScubaKing22

Two things: Please don't post your question in multiple forums. Also this is a forum for help, not complete code. So all I am going to say is declare $name & $web to $HTTP_POST_VARS['name'] & $HTTP_POST_VARS['web'], respectively.

xxwurmxx

Now it doesnt even store anything in the table

<?
$username="root";
$password="worm";
$database="worm";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO links VALUES ('', HTTP_POST_VARS['name'], HTTP_POST_VARS['web'])";
mysql_query($query);

mysql_close();
?>

ScubaKing22

You can see if there are any errors by using mysql_error():

<? 
$username="root"; 
$password="worm"; 
$database="worm"; 

mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
$name=HTTP_POST_VARS['name'];
$web=HTTP_POST_VARS['web'];

$query = "INSERT INTO links VALUES ('','$name','$web')"; 
mysql_query($query);
if (mysql_error())
echo mysql_error(); 

mysql_close(); 
?>

xxwurmxx

Parse error: parse error, unexpected '[' in E:\html\a\insert.php on line 8

sarahk

<?  

$username="root";  

$password="worm";  

$database="worm";  

mysql_connect(localhost,$username,$password);  

@mysql_select_db($database) or die( "Unable to select database");  

$name=$HTTP_POST_VARS['name']; 
$web=$HTTP_POST_VARS['web']; 

$query = "INSERT INTO links VALUES ('','{$name}','{$web}')";  

mysql_query($query); 
if (mysql_error()) 
echo mysql_error();  

mysql_close();  

?>

xxwurmxx

that worked thanks