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> Link to comment https://forums.phpfreaks.com/topic/2575-need-help-with-form-phpmysql/ 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 Link to comment https://forums.phpfreaks.com/topic/2575-need-help-with-form-phpmysql/#findComment-8554 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.