if.....elseif....else

dirtboy

Okay call me stupid ....but help
I have a rank field in my table with 1 of the 3 values
I'm trying to display certain code depending on the rank level and I'm using the statement if.....elseif...else... can some one help me reach my goal?

this is what I'm using now but it doesn't work
I do have my own database info in it though 🙂
<br>
$db_connect = mysql_connect("localhost", "username", "password");
mysql_select_db("dbname", $db_connect);
$result = mysql_query("SELECT rank FROM yellow_page_listings WHERE username = '$username' ", $db_connect);
$num_rows = mysql_num_rows($result);
if($num_rows == "1")
{
echo "userlevel 1";
}
elseif($num_rows == "2")
{
echo "userlevel 2 ";
}
else{
echo "you have no account";
}

TheDefender

$num_rows outputs an integer and not a string. Remove the double quotes around your comparison values...

$db_connect = mysql_connect("localhost", "username", "password"); 
mysql_select_db("dbname", $db_connect); 
$result = mysql_query("SELECT rank FROM yellow_page_listings WHERE username = '$username' ", $db_connect); 
$num_rows = mysql_num_rows($result); 
if($num_rows == 1) 
{ 
echo "userlevel 1"; 
} 
elseif($num_rows == 2) 
{ 
echo "userlevel 2 "; 
} 
else{ 
echo "you have no account"; 
}

(This should work for you, assuming your query is right, and you are actually getting rows returned.)

dirtboy

I tried that code you suggested, however I used it earlier and no luck and still no luck!....bummer
should I not use $num_rows?

dirtboy

I guess let me state this:

in my mysql database I have a table.....duh and in that table I have a field named "rank" for some users the value of rank is 0
for other it is 1 and for others it is 2 so I'm trying to get the value of rank and give a special welcome message according to their rank number.....can my above code do that.....no so what do you guys sugest?

tekky

Originally posted by dirtboy
.....can my above code do that.....no so what do you guys sugest?

no...

you need to read up on [man]mysql_fetch_assoc[/man] or [man]mysql_fetch_array[/man]