Database input Code Broken :-(

Steve_Abrahall

Hi something is killing my database input form and I'm going nuts trying to work out what it is

Input Form is as follows ____

<form action=iput.php method=GET>
 Please
Submit or update 
your
information to our Database... 
 
First Name: 
<input type=text name=first size=25 maxlength=25>



Last Name: 
<input type=text name=last size=25 maxlength=25>


Phone:
 
<input type=text name=phone size=25 maxlength=25>
 
</form>

iput.php is as follows

<?php

mysql_connect (localhost,bob,bob);
mysql_select_db (test);

mysql_query ("INSERT INTO people (first ,last ,phone)
VALUES ('$first','$last','$phone'
");

print ("$first");
print ("$last");
print ("$phone");

Thanks

Steve

weevil

You are missing a ) on this line and you should be using $GET for the variable names.
mysql_query ("INSERT INTO people (first ,last ,phone) VALUES ('$GET[first]','$GET[last]','$GET[phone]')
");
Not sure if either of those is your problem. What is the error you are getting?

Steve_Abrahall

Yep you were on the button!
Thanks weevil

Originally posted by weevil
You are missing a ) on this line and you should be using $GET for the variable names.
mysql_query ("INSERT INTO people (first ,last ,phone) VALUES ('$GET[first]','$GET[last]','$GET[phone]')
");
Not sure if either of those is your problem. What is the error you are getting?