[Resolved] Inserting into Database

ofSHIZ

<?php
$username = $_POST['username'];
$password = $_POST['password'];
$bnet = $_POST['bnet'];
$race = $_POST['race'];
$rank = $_POST['rank'];
$email = $_POST['email'];
$aol = $_POST['aol'];
$msn = $_POST['man'];
$yahoo = $_POST['yahoo'];
$icq = $_POST['icq'];

  $db = mysql_connect("localhost","hfwf") or mysql_die ("Unable to Connect to Mysql."); 
  mysql_select_db("hfwf_uk_db", $db);

$result = mysql_query("INSERT INTO `members` (`username`, `password`, `bnet`, `race`, `rank`, `email`, `aol`, `msn`, `yahoo`, `icq`) VALUES ('$username', '$password', '$bnet', '$race', '$rank', '$email', '$aol', '$msn', '$yahoo', '$icq'");
$query = mysql_query("$result", $db);
if( mysql_num_rows($result) == 0 )
     { echo("The Information that you have entered could not be submitted, please contact the webmaster if the problem occurs again."); }
else
     {
	 { echo("Succesful!"); }
	 }

 /*

 { echo("The Information that you have entered could not be submitted, please contact the webmaster if the problem occurs again."); }
else
     {
$query = mysql_query('$result', $db);
     }
*/
?>

This code is for a regisration script, and for some reason it give me.. "The information that you.." when I try to do a register.. can someone please help me out with this? Why wont it add the stuff into MySQL??

cgraz

better error checking would be to use mysql_error(), not to see how many results were returned.

$query = mysql_query($result, $db) or die(mysql_error());

Cgraz

ofSHIZ

By adding that, I get this error
Parse error: parse error in /data/members/free/tripod/uk/h/f/w/hfwf/htdocs/member.php on line 17

cgraz

put double quotes around $result and try again.

Cgraz

ofSHIZ

it still doesnt work..
I dont get an error, just a blank page..
im using http://www.tripod.co.uk as my server

ofSHIZ

Anyone? Please.. I've been working on some sort of login regisration ever since I got PHP, its kinda one of the reasons that I wanted a server with PHP and MySQL.
Thanks
Brandon Trecki

lanjoky

$result = mysql_query("INSERT INTO members (username, password, bnet, race, rank, email, aol, msn, yahoo, icq) VALUES (\"$username\", \"$password', \"$bnet\", \"$race\", \"$rank\", \"$email\", \"$aol\", \"$msn\", \"$yahoo\", \"$icq\"");

Try that and see if that helps ... if not post the error produced

barand

$result = mysql_query("INSERT INTO members (username, password, bnet, race, rank, email, aol, msn, yahoo, icq) VALUES ('$username', '$password', '$bnet', '$race', '$rank', '$email', '$aol', '$msn', '$yahoo', '$icq'");

You need your final " outside the )

hth

ofSHIZ

Ehh, sorry cgraz, I messed up. I had a server messup and my uploading didn't work to well, so I re did it.. with the mysql error. I get a error message that stated:
Query was empty.
I have no idea..

cgraz

ok ok, i completely missed this.

$result is your query, and you execute it there. So $result is executed by mysql. Then, you take $query and try to execute $result. That means yo'ure running mysql_query twice. What you need to do is change your code to the following:

$result = "INSERT INTO `members` (`username`, `password`, `bnet`, `race`, `rank`, `email`, `aol`, `msn`, `yahoo`, `icq`) VALUES ('$username', '$password', '$bnet', '$race', '$rank', '$email', '$aol', '$msn', '$yahoo', '$icq'"; 
$query = mysql_query("$result", $db) or die(mysql_error());

Notice how $result no longer has mysql_query() performed on it, but it's performed on it when $query is created?

Give this a try. This should solve your problem.

Cgraz

ofSHIZ

Ok, I see what you mean by that.. I can't believe I didn't catch that.. or why I put that.. anyways.. I get a new error..
Don't you just love errors ?
You have an error in your SQL syntax near '' at line 1
I'll try to solve it right now..

cgraz

try this

$result = "INSERT INTO members (username, password, bnet, race, rank, email, aol, msn, yahoo, icq) VALUES ('$username', '$password', '$bnet', '$race', '$rank', '$email', '$aol', '$msn', '$yahoo', '$icq')";  

$query = mysql_query($result, $db) or die(mysql_error());

Cgraz

ofSHIZ

Now I get my Echo that says, "The information.."
Ill post the code before that page, and my MySQL Table setup

ofSHIZ

I love you cgraz..
Nevermind that last post, I have to switch the echo messages around or something.
I went in PHPMYADMIN, and my table only had 1 record before.. and now it has 3! So I went to my meberlist.. and there it was.
Thanks alot..!

cgraz

Originally Posted by ofSHIZ
I love you cgraz..

Thank you, but I still think we should see other people . . . .

jk 😃 Glad you got it working.

Cgraz