Asked before, no one helped :(

[Mark]

ok, hi, i asked for some help before and no one really helped 🙁 i know your not "required" to help me but please, i dont have any clue why its not working..

problem: when i try to register, it does not submit to mysql, it does nothing, i'm probably missing somthin really dumb (cause i'm a retard) but please, can some one help? thanks in advance.

<? 
  $dbconn = mysql_pconnect("localhost","l3lade","****");  //establish connection w/db
  $result = mysql_select_db("Hazardnet", $dbconn); //establish connection w/db
  $sql = "SELECT * FROM Hazardnet_users WHERE username='$username'";  //query to return all results where the username equals the username they signed up with
  $result = mysql_query($sql) or die(mysql_error());  //send the query to the database
  if(empty($username) || empty($passwd) || empty($email))
	{
	echo "<b>Please fill out all fields</b>";
	}

  if($result != false){  //make sure there were no errors;database is running
    $data = mysql_fetch_assoc( $result );
	}
  if(empty($data['username']))
    {
	mysql_query ("INSERT INTO Hazardnet_users (username, passwd, email) 
	VALUES ('$username', '$passwd', '$email'");

}

  else{
	echo "<b>There was a problem!</b> ", mysql_error();	
    }
?>

[sarahk]

I use a database class so can't tell you straight off if there's something wrong with your mysql but...

<? 
  if(!isset($username) || !isset($passwd) || !isset($email))
    {
    echo "<b>Please fill out all fields</b>";
    exit;  // but really, I need to refresh the form
    }
  $dbconn = mysql_pconnect("localhost","l3lade","****");  //establish connection w/db
  $result = mysql_select_db("Hazardnet", $dbconn); //establish connection w/db
  $sql = "SELECT count(*) as cnter FROM Hazardnet_users WHERE username='$username'";  //query to return all results where the username equals the username they signed up with
  $result = mysql_query($sql) or die(mysql_error());  //send the query to the database

  if($result != false)
  {  //make sure there were no errors;database is running
    $data = mysql_fetch_assoc( $result );
    if($data['cnter'] == 0)
    {
      // this was almost certainly falling over with bad syntax added an additional )
      $sql = ("INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";
      echo "$sql<br>";
      mysql_query( $sql );
    }
    else
    {
      echo "<b>Username exists</b> ";    

    }
    else
    {
      echo "<b>There was a problem!</b> " . mysql_error() . "<br>";    

    }
?>

[Mark]

Thanks Sara, buttt.. a problem?

<? 
  if(!isset($username) || !isset($passwd) || !isset($email))
    {
    echo "<b>Please fill out all fields</b>";
    exit;  // but really, I need to refresh the form
    }
  $dbconn = mysql_pconnect("localhost","l3lade","****");  //establish connection w/db
  $result = mysql_select_db("Hazardnet", $dbconn); //establish connection w/db
  $sql = "SELECT count(*) as cnter FROM Hazardnet_users WHERE username='$username'";  //query to return all results where the username equals the username they signed up with
  $result = mysql_query($sql) or die(mysql_error());  //send the query to the database

  if($result != false)
  {  //make sure there were no errors;database is running
    $data = mysql_fetch_assoc( $result );
    if($data['cnter'] == 0)
    {
      // this was almost certainly falling over with bad syntax added an additional )
      $sql = ("INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";
      echo "$sql<br>";
      mysql_query( $sql );
    }
    else
    {
      echo "<b>Username exists</b> ";    

    }
    else
    {
      echo "<b>There was a problem!</b> " . mysql_error() . "<br>";    

    }
?>

you forgot (? i think) a ")".. on this line.

// this was almost certainly falling over with bad syntax added an additional )
      $sql = ("INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";

when i put it there. it gives me an error, when i try to register:
Parse error: parse error, unexpected T_ELSE in C:\Documents and Settings\Mark\Desktop\My Web Sites\Hazardnet\check.php on line 27

[sarahk]

Nooooo

it's

      $sql = "INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";

You have brackets around the column names and around the values, nowhere else.

that's why I separated the sql statement from the mysql call as there were so many double quotes, single quotes and brackets around the place it was hard to keep track.

hope this helps.

[Mark]

well, if you look in your first post, you put a ( at the beginning.. 🙁

after correcting the "problem" it still gives me the same parse error. 🙁 help me sara 🙁

[cgraz]

change

    mysql_query ("INSERT INTO Hazardnet_users (username, passwd, email) 
    VALUES ('$username', '$passwd', '$email'");

to

$query = "INSERT INTO Hazardnet_users (username, passwd, email) 
    VALUES('$username', '$passwd', '$email')";
print $query . "<br>"; // if you print it, you can see if your variables are being passed properly

$strSQL = mysql_query($query) or die(mysql_error()); // use mysql_error()) to determine if there are any errors

By printing the query string and using mysql_error(), you will quickly be able see what your problem is.

Cgraz

[Mark]

that doesnt help...

[chads2k2]

With this statement

$sql = ("INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";

You are trying to just add a User correct?
Why not do it this way...

$sql = ("INSERT INTO Hazardnet_users VALUES ('$username', '$passwd', '$email')";

You dont need the (username,passwd,email) because it knows what fields you have and how many fields are nessaccary (I can't spell) to make a valid input. Try that and I will check back tomorrow.

[cgraz]

neither does your response. What does the code I gave you print?

Cgraz

[chads2k2]

LOL @ Cgraz

[sarahk]

Yeah, I had an echo of that $sql in there too, hoping it would help.

The advice to drop the column names only works if the columns are in that order with no other fields infront, like an autoindex.

If it's printed out and then copied into phpMyAdmin you can see the error more clearly.

Maybe Mark could tell us what he has done - without posting all his code - and what line gives errors.

[Mark]

okay geezus, first off. the code i had FIRST.. (mine) when i tried to add a user, it gave NO ERROR <--- none. BUT... it did not submit the user to mysql.. ok? when i tried sara's. it gives me this error when i try to add a user.

Parse error: parse error, unexpected T_ELSE in C:\Documents and Settings\Mark\Desktop\My Web Sites\Hazardnet\check.php on line 27

[xblue]

Mark,

I think a lot of people are trying to help you.

The example code was just missing one closing }.
I added error checking for the update query, too.

if ($result != false) {
    //make sure there were no errors;database is running
    $data = mysql_fetch_assoc($result );
    if ($data['cnter'] == 0) {
        // this was almost certainly falling over with bad syntax added an additional )
        $sql = "INSERT INTO Hazardnet_users (username, passwd, email) VALUES ('$username', '$passwd', '$email')";
        mysql_query($sql ) or die("Error: ".mysql_error()." in query: ".$sql);
    } else {
        echo "<b>Username exists</b> ";
    }
} else {
    echo "<b>There was a problem with the select query!</b> " . mysql_error() . "<br>";
}