reag27 Posted September 28, 2005 Share Posted September 28, 2005 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> Quote Link to comment Share on other sites More sharing options...
Mattyspatty Posted September 28, 2005 Share Posted September 28, 2005 try not using num and '' it may work, else the autonumber isnt a primary key which can cause a problem Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.