MEMBERS PROFILE with MYSQL [long]

[corruption]

so i'm trying to collect data from people, then store it in a database for starters.

ex:
<form action="USERS.PHP" method="post" name="newuser">
<table>
<tr>
<td>First Name:</td>

<td><input name="fname" type="text" maxlength="20"></td>
</tr><br>

so on and son on for like 11 different fields

then users.php looks like this

 mysql_query("INSERT INTO brothers (fname, lname, address, phone, Email, major, year, in, big, little)
VALUES( '$fname', '$lname', '$address', '$phone', '$Email', '$major', '$year', '$in', '$big', '$little')") or die (mysql_error());

[pablodelapena]

so whats your problem? looks ok to me?

maybe try this?

$query = "INSERT INTO brothers
(fname, lname, address, phone, Email, major, year, in, big, little) 
VALUES
( '".$_POST['fname']."', '".$_POST['lname']."', '".$_POST['address']."', '".$_POST['phone']."', '".$_POST['Email']."', '".$_POST['$major']."', '".$_POST['$year']."', '".$_POST['in']."', '".$_POST['big']."', '".$_POST['little']."')";

$result = mysql_query($query);

Essentially thats exactly the same but, I feel, more correct?

Anyways, yeah whats your problem?

[corruption]

my problem is that it doens't ever actually send information or at least input it to the mysql database. I guess i forgot to mention this. I believe they are really both equally correct. Besides the point however, on another forum, i was told that i should use GET instead because it's used for larger pieces of data. Any comments on this?

[pablodelapena]

Depends what your doing really. GET is justa s good as POST except it is limited to the size of the URL, 255 characters.

If you are going to be passing large amounts of data then POST is the way forward.

I still don't understand your question though🙁

A simple debugging thing you can do is at the top of the script echo out all the info which SHOULD have been sent along followed by an [man]exit()[/man] function. If it is not being echoed out find out why, if it is check your query.

[corruption]

ok so this is what i did to test it i think it was right....

<?php
//include connection script
require 'CONN.PHP';
//see if variables have been sent properly
echo '$fname';
echo '$lname';
echo '$address';
echo '$phone';
echo '$in';
echo '$major';
echo '$big';
exit();

then it goes on into the converting things to simple variables
a) is that correct??
b) there was no output what now?

edit -> also tried this piece
<?php
//include connection script
require 'CONN.PHP';
//see if variables have been sent properly
echo $POST['fname'];
echo $POST['lname'];
echo $POST['address'];
echo $POST['phone'];
echo $POST['in'];
echo $POST['major'];
echo $_POST['big'];
exit();

[pablodelapena]

I have no idea!😕

Double check your HTML coding for the form to make sure its all ok!

Possibly try removing the quotes and leave it as echo $variable;

Im brainstorming, i really dont see whats wrong here. sorry!

[corruption]

So i got it to post to a blank page all the variables. Then i added my connection script. Now there was an error there so that's fixed. Now i added the part about sending it to a database which it appears that it does because the database discovers a new record. However The Record is blank any ideas on what's going on here?

[pablodelapena]

in your query are the VALUES surrounded by quotes? i.e : INSERT INTO table (col1) VALUES ('something')

?

[corruption]

this is what it looks like...

<? mysql_query("Insert INTO brothers(fname, lname, phone, email, number, major, big, little)
 		      VALUES('$fname', '$lname', '$phone', '$email', '$number', '$major', '$big', '$little')") or die (mysql_error());
			  ?>