Hello
I need help with a form I created, I'm having trouble storing information from the form in a mysql database, the field that seems to be updating is the auto_increment the rest of the fields you just gives me blank, I just started using php/mysql 5 days ago, I have tried several options none seem to work
I'll apreciate all the help I can get, here is the form and script
<html>
<body>
<form action="page2.php" name="forward" method="post">
Name:<input type="text" name="name" value=<? echo $name; ?>">
Address:<input type="text" name="address" value=<? echo $name; ?>">
Career:<input type="text" name="career" value <? echo $career; ?>">
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<html>
<body>
<?php
$link=mysql_connect("localhost","root");
mysql_select_db("text");
$sql="insert into table1";
$sql .="(num,name,address,career)";
$sql .="values('','$name', '$address', '$career')";
mysql_query($sql);
?>
</body>
</html>