Jump to content

Archived

This topic is now archived and is closed to further replies.

reag27

Need help with form php/mysql

Recommended Posts

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>

Share this post


Link to post
Share on other sites

try not using num and '' it may work, else the autonumber isnt a primary key which can cause a problem

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.