[Resolved] Check for existing users problem

[whitebread]

Hello,

I'm having a small problem getting my code to check for existing user names on my database. I have attached my PHP code that I'm having issues with and I was hoping that someone could see where I went wrong.

	if (isset($_POST['submit'])) {

	include('mysql_connect_login.php');

$frm_ID = $_POST['username']; 

$query = "SELECT username FROM users WHERE username= $frm=ID";
$r = mysql_query ($query);
if (mysql_num_rows($r) == 0) {
	$sql_query = "insert into users (Name, username, password, transit) Values ('{$_POST['name']}', '{$_POST['username']}', '{$_POST['password']}', '{$_POST['transit']}')";
	//run it 
	$query_run = mysql_query($sql_query);
	$query_run;

} else {
header("location: inuse.php");
}


mysql_close();
header("location: updated.php");
}

[wempy]

$query = "SELECT username FROM users WHERE username= $frm=ID";

you may want to change the $frm=ID to $frm_ID

[whitebread]

Yeah I saw that error just after I posted this but the dam thing still won't work.

[wempy]

ok, well not being psychic, it would be helpful if you let us know what error you are getting.

syntactically, it looks ok, except for the line $query_run;
on its own, don't know what you are trying to achieve there.

You could try adding exit(); after each call to header();

[whitebread]

Well sarcasm aside, there was no error message just no results. However, after trying a few things I found a problem in my structure. I guess now you don't need to be psychic to tell that I have resolved my problem.

Thanks Anyway.

[bradgrafelman]

Don't forget to mark this thread "RESOLVED" using the link at the bottom of this page.