something is wrong I dont know what

[Paragon]

<?php
if ($submit) {

  // process form

  $db=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
  mysql_select_db (""); 

  $sql = "INSERT INTO users (username,password,ip1,ip2,ip3,user_url,user_email,user_sig) VALUES ('$username','$password','$ip1','$ip2','ip3','user_url','user_email','user_sig')";

  $result = mysql_query($sql);

  echo "Information entered.\n";

} else{

// display form
$submit = $_POST['submit'];
$username = $_POST['username'];
$password = $_POST['[password'];
$user_ip1 = $_SERVER['REMOTE_ADDR'];
$user_ip2 = $_SERVER['HTTP_X_FORWARDED_FOR'];
$user_ip3 = $_SERVER['REMOTE_ADDR'];
$user_url = $_POST['user_url'];
$user_email = $_POST['user_email'];
$user_sig = $_POST['user_sig'];

echo "$username";
echo "<BR>";
echo "$password";
echo "<BR>";
echo "$user_ip1";
echo "<BR>";
echo "$user_ip2";
echo "<BR>";
echo "$user_ip3";
echo "<BR>";
echo "$user_url";
echo "<BR>";
echo "$user_email";
echo "<BR>";
echo "$user_sig";
?>
<form action="<?php echo $PHP_SELF?>" method="POST">
  UserName*<BR>
  <input name="username" type="text" size="15">
  <BR>
  Password*<BR>
  <input name="password" type="text" size="15">
  <BR>
  URL<BR>
  <input name="user_url" type="text" size="15">
  <BR>
  Email*<BR>
  <input name="user_email" type="text" size="15">
  <BR>
  Signature<BR>
  <textarea name="user_sig" cols="35"></textarea>
  <BR>
  * Feilds are required<BR>
<input name="submit" type="submit" value="Finish Process">
</form>
  <?php
} // end if
  ?>

[kevinsequeira]

the next time when you post it would help, if you mention what the problem is or what happens when you run the code.

try this

<?php
if ($_POST['submit']) {
$submit = $_POST['submit'];
$username = $_POST['username'];
$password = $_POST['[password'];
$user_ip1 = $_SERVER['REMOTE_ADDR'];
$user_ip2 = $_SERVER['HTTP_X_FORWARDED_FOR'];
$user_ip3 = $_SERVER['REMOTE_ADDR'];
$user_url = $_POST['user_url'];
$user_email = $_POST['user_email'];
$user_sig = $_POST['user_sig'];

echo "$username";
echo "<BR>";
echo "$password";
echo "<BR>";
echo "$user_ip1";
echo "<BR>";
echo "$user_ip2";
echo "<BR>";
echo "$user_ip3";
echo "<BR>";
echo "$user_url";
echo "<BR>";
echo "$user_email";
echo "<BR>";
echo "$user_sig";
  // process form
//make proper connections to db here
  $db=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
  mysql_select_db (""); 

  $sql = "INSERT INTO users  (username,password,ip1,ip2,ip3,user_url,user_email
,user_sig) VALUES  ('$username','$password','$ip1','$ip2','ip3','user
_url','user_email','user_sig')";

  $result = mysql_query($sql);

  echo "Information entered.\n";

} else{
// display form
?>
<form action="<?php echo $PHP_SELF?>" method="POST">
  UserName*<BR>
  <input name="username" type="text" size="15">
  <BR>
  Password*<BR>
  <input name="password" type="text" size="15">
  <BR>
  URL<BR>
  <input name="user_url" type="text" size="15">
  <BR>
  Email*<BR>
  <input name="user_email" type="text" size="15">
  <BR>
  Signature<BR>
  <textarea name="user_sig" cols="35"></textarea>
  <BR>
  * Feilds are required<BR>
<input name="submit" type="submit" value="Finish Process">
</form>
  <?php
} // end if
  ?> 

reg
kevin

[tuf-web_co_uk]

you havent connected to the database properly you need to define a username, password, and a database name

$db=mysql_connect ("localhost", "USERNAME", "PASSWORD") or die ('I cannot connect to the database because: ' . mysql_error()); 
  mysql_select_db ("DATABASE_NAME");  

[Paragon]

Im not going to post my username and password on the forum. Thanks for your help.

[Paragon]

New problem is password and IPs arent being sent to the DB.

[Paragon]

cant anyone tell me why or help ? thanks

[abda53]

whats the error your getting?

[Paragon]

no error the infomation just isnt being placed in the database.

[Paragon]

ok. I figured out the IP problem, but still dont know the password problem.

[Nilanka]

Is there a any warnning messages displaying?

[Paragon]

no

[Bootsman123]

Maybe you should give a name to your form.

[agoe]

$password = $_POST['[password']; is bad, got a "[" too much.

$password = $_POST['password']; that ought to do it

[Paragon]

DOH!