php header function not working

[tharindu96]

the code below is not working can anyone help me?

									$query2 = "SELECT `username` FROM `users` WHERE `username` = '$new_username'";
									$query2_run = mysql_query($query2);
									if(mysql_num_rows($query2_run)==1) {
										echo 'The username '.$new_username.' already exists.';
									}else{
										$query2 = "INSERT INTO `users` VALUES ('".mysql_real_escape_string($new_email)."','".mysql_real_escape_string($new_username)."','".mysql_real_escape_string($new_passhash)."','".mysql_real_escape_string($new_firstname)."','".mysql_real_escape_string($new_lastname)."')";
										if ($query2_run = mysql_query($query2)) {
											header('Location: success.php');
										}else{
											echo 'Sorry, we could not register at this time. Please try again later.';
										}
									}

[PsychoCoder]

It sure would be nice if you provided something other than "It doesnt work". What is it doing versus what you need it to do? Are you getting any errors, if so what are they? These are very helpful pieces of information

[tharindu96]

After registering a user I want to redirect them to a page but the header function does not work.

[Dormilich]

there could be output preventing the header to work. enable error reporting to see if that’s the case.

[tharindu96]

found the answer
i had to put "exit;" after the "header("Locati on: success.php")"