No output

Kudose

Hello all. In this following code, everything works just fine except when all for the last statment (the part will it says it will be online shortly). If you try to make it fail it will, but if you try to make it pass then it will display nothing. Any help getting it to display the correct information would be appreciated.

include('connect.inc.php');
			$exempt = array("webmaster", "admin", "administrator", "adminstration", "god", "system", "unknown", "owner");
			if($username) { $username = strtolower($username); } //make the username lowercase
			if(!$username){ echo "<p class='style1' align='center'>You did not select a username.</p>"; }
			elseif(in_array($username, $exempt) == TRUE){ echo "<p class='style1' align='center'>We apologize, but ".$username." is blacklisted.<br>Please try again.</p>"; }
			else { //if no errors
			$email = $username.$domain;
			$query = mysql_query("SELECT * FROM taken_emails WHERE email='$email'") or die(mysql_error());
			$rows = mysql_num_rows($query) or die(mysql_error());
				if($rows == "1") { // if email is taken
					echo "<p class='style1' align='center'>We apologize but ".$email." has already been selected by another user. <br>Please try again.</p>";
						} else { //if name is not taken
							echo "<p class='style1' align='center'>We apologize but our e-mail purchase form will be online shortly.</p>";
						} // end if email is taken check
				}// end error check

THANKS!

freebie

I believe your problem here is this line:

$rows = mysql_num_rows($query) or die(mysql_error());

don't do it like that. The 0 rows is being interpreted as false (I think) and thus dying.

try this

if(mysql_num_rows($query)>0){
//.. do something
}else{
// .. do something else
}

cl_stef

That's right, the values 0 and false have the same meaning in almost any programming language. I don't know how PHP handle boolean values but I think your notation is risky.

$email = $username.$domain;
Are you sure this is correct? Haven't you missed an '@' somewhere? (Just an idea).

And about this line:
if($rows == "1")
mysql_num_rows returns an integer, doesn't it? Even if this may not change anything, it is better to avoid the " " because it makes the PHP engine consider 1 as a string.

cl_stef

If you are not 100% sure about your mysql request, just echo it and copy/paste it on phpmyadmin.
Sometimes, this helps a lot .