zamp0e Posted June 7, 2009 Share Posted June 7, 2009 Hello, I'm back with, which im sure is, a nobrainer problem. When I run: $sql = "INSERT into users VALUES (NULL, '$_POST[name]', '$_POST[password]', CURDATE(),1,0,'$_POST[email]')"; $result = mysql_query($sql) or die ("Error in query: $sql. ".mysql_error()); The result in the table is : 4 Array Array 2009-06-07 1 0 Array The form looks like this: <form action="regaction.php" method="post"> <input type="text" name="name[]"/><br /> <br /> <input type="password" name="password[]" /><br /> <br /> <input type="text" name="email[]" /><br /> <br /> <input type="submit" name="submit" value="Registrera!" /> </form> A push in the right direction would be appreciated Note: I was not sure wich forum this would fit into, as it involves both SQL and PHP. Quote Link to comment https://forums.phpfreaks.com/topic/161278-solved-probelm-with-insert/ Share on other sites More sharing options...
Ken2k7 Posted June 7, 2009 Share Posted June 7, 2009 Remove the [] from all the input name attributes. Quote Link to comment https://forums.phpfreaks.com/topic/161278-solved-probelm-with-insert/#findComment-851069 Share on other sites More sharing options...
zamp0e Posted June 7, 2009 Author Share Posted June 7, 2009 I was under the impression that those were needed, but I must have minunderstudd what they were for. Thanks alot! Quote Link to comment https://forums.phpfreaks.com/topic/161278-solved-probelm-with-insert/#findComment-851080 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.