MySQL problem

[Paaat]

Hey,
I'm having a problem executing the following code:

<?php
session_start();
require('connect.php');
if($_POST['username'])){
  $name=$_POST['username'];
  $checkUsername = mysql_query("select * from users where UserName='$name'");
  if(mysql_num_rows($checkUsername){
    echo 'Logged in successfully!';
    $_SESSION['username'] = $name;
  }
  else{
    echo 'The username or password you've entered is not valid!';
  }
}
?>

[Pro2000]

Actually, the problem you're facing is not in MySQL. :)
I think you only have to close the IF Condition bracket in the line #7 so it becomes:

if(mysql_num_rows($checkUsername)){

Another mistake is in the line #12 where you have to escape the quotation mark in "you've" like this:

echo 'The username or password you\'ve entered is not valid!';

To be more careful and avoid other errors, however, add this before the semicolon in the line #6:

or die(mysql_error())

[sv3tli0]

if(mysql_num_rows($checkUsername)){

should be

if(mysql_num_rows($checkUsername)>0){

[Pro2000]

:yawn: Oh! How could I forget to type it!

[Paaat]

Thank you. It's solved now.