COnnect To MySQL Problem...

[suigion]

Hi All,

 

I am new in PHP. I try to insert data into MySQL Table, table name is "member".But, nothing happen. The table still contains 0 row.

Here is the code:

 

<?php

$user = $_POST["username"];

$email = $_POST["email"];

$password = $_POST["password"];

 

$db = mysql_connect("localhost","root","suigion");

mysql_select_db("blogzone",$db);

$sql = "INSERT INTO member(Username, Email, Password) VALUES ('$user','$email','$password')";

mysql_query($sql,$db);

mysql_close($db);

 

?>

 

Can anyody tell me what's wrong with the code???

Thanks in advance...

[trq]

Change this....

 

mysql_query($sql,$db);

 

to...

 

if (mysql_query($sql,$db)) {
  echo "success";
} else {
  echo "Query failed...<br />" . mysql_error() . "<br />$sql<br />";
}

 

What do you get?

[trq]

Actually, change your query while your at it.

 

$sql = "INSERT INTO member (Username, Email, `Password`) VALUES ('$user','$email','$password')";

 

Password is a reserved word.

[suigion]

Hi,

I have try your suggestions, but the browser display nothing. It just blank...

Do I need to install additional things??

I have install MySQL and PHP 5...

 

Thanks...

[pranav_kavi]

initally try tis,

mysql_connect("localhost","root","suigion") or die("Unable to connect to database...");
mysql_select_db("blogzone") or die("Unable to select database...");

[suigion]

thanks for your idea, but the problem is not solved yet. I think I have to configue the PHP so that it can support MySQL operation.

Did anybody know how to change the php.ini file ???

 

Thnks