Registration, why.?

[Mark]

<? 
  $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);  //send the query to the database
  if(empty($username) || empty($passwd) || empty($email))
	{
	echo "<b>Please fill out all fields</b>";
	}
  if(empty($data['username']))
    {
	mysql_query ("INSERT INTO Hazardnet_users (username, passwd, email) 
	VALUES ('$username', '$passwd', '$email'");

}

  if($result != false){  //make sure there were no errors;database is running
    $data = mysql_fetch_assoc( $result );


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

ok, i dont get any errors, but its not submitting anything to the database? i cant figure it out :o

http://www.hazardnet.net/?hn=register

[stolzyboy]

replace this line

$result = mysql_query($sql); //send the query to the database

with this line, it will give you better errors

$result = mysql_query($sql) or die(mysql_error()); //send the query to the database

[Mark]

still no errors?😕

[stolzyboy]

try echoing the query like

echo $query; //after the query itself

and see what the results are

[BuzzLY]

Originally posted by Mark
correct me if I'm wrong... but shouldn't these two if statements be reversed?

if(empty($data['username']))
    {
	mysql_query ("INSERT INTO Hazardnet_users (username, passwd, email) 
	VALUES ('$username', '$passwd', '$email'");

}

  if($result != false){  //make sure there were no errors;database is running
    $data = mysql_fetch_assoc( $result );


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

Seems that before you can check the contents of $data, $data needs to be set/created, right? Or am I missing something?

[stolzyboy]

yeah now that i look at it closer, it should be that way, i didn't look that far since he said he wasn't getting any errors

[Mark]

ok, so what am i supposed to do, i didnt understand 🙁

[BuzzLY]

Mark,

You need to use this command:

$data = mysql_fetch_assoc( $result );

Before you use this statement:

if(empty($data['username']))
    {
    mysql_query ("INSERT INTO Hazardnet_users (username, passwd, email) 
    VALUES ('$username', '$passwd', '$email'");

}

Can you see why?

[Mark]

yeaah, thats what i thought you meant, but i wasnt sure at all.

thanks

you have to have it before because otherwise it would be trying to do something with a variable that isnt set yet, right?

but i tried to register a name, and it still didnt put anything into mysql

[Mark]

i still need help on this, i dont know why it wont submit to MySql

<? 
  $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();	
    }
?>

[BuzzLY]

Mark, now that you have you code entered in the right order, what part of it is failing? Have you verified that you have made the connection to the database? Have you tried running the INSERT query directly in MySQL? Does that work?

You are not very consistent in your methods. At first, you set a $sql variable, then set $result = your query. Later, you simply run mysql_query with the SQL statement. Keep using your variables, and echo them to the screen so you can see where your code is failing. If it is indeed the INSERT query, then you can investigate the problem in MySQL -- perhaps you don't have the proper permissions for the user, for example.

You can't simply say "it's not working" and expect us to know just by looking at your code. If there were something glaringly wrong with the code, perhaps we could help you spot it, but the problem can be in many different areas. Investigate and pinpoint where the problem is occuring, and if you need help, be sure to let us know what you did to try to discover the problem.

Hope that sets you in the right direction... Good Luck!