[RESOLVED] help with the else statement

Simonhurst

hi guys
i made a simple db check for a username what it does is check to see if username exists and if it does give details but if no username exists its supposed to say yup that free kind of affair now the first part works well but the else part just shows the page with no text in it ??

heres the code

$R01 = mysql_query($Q01) or die(mysql_error());
while ($row = $db->sql_fetchrow($R01))
{

// Present results based on validity.
if (mysql_num_rows($R01) > 0)
{
echo "<p align=center><b>$username</b><br> Is allready taken <br> please choose a diffrent username!<br><br><a href=check.php>GO BACK</a></p>";
} else
  {
         echo "<p align=center><b>Hello $username <br>has not been taken </p>";
        }
}
}

can any one see what ive done wrong ?

thanks

thorpe

you dont really need the while seeing as you'd only ever expect one result.

if (mysql_num_rows($R01) > 0) 
{ 
    echo "<p align=center><b>$username</b><br> Is allready taken <br> please choose a diffrent username!<br><br><a href=check.php>GO BACK</a></p>"; 
} else { 
    echo "<p align=center><b>Hello $username <br>has not been taken </p>"; 
}

other than that, your if else looks ok.

Simonhurst

hi thorpe

thanks very much that was excatly the problem :o

cheers

halojoy

Simonhurst

Above all posts in thread you see a blue menu bar:
Thread Tools - Search this Thread -Rate Thread - Display Modes

In 'Thread Tools'
you find Mark This Thread as Resolved

Now that our fiend thorpe
kindly solved this very quickly
You can mark this thread Resolved.
So nobody else keeps on trying to solve it

/halojoy
had not much to do here
🙂

Simonhurst

thanks for the info

and done 😃