<?php
$host = "localhost";
$username = "myuser";
$password = "isgiosgdL";
$db_name = "mydb123";
mysql_connect($host, $username, $password) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error_db());
$myusername = mysql_real_escape_string($_POST['username']);
$mypassword = mysql_real_escape_string($_POST['password']);
$sql = "SELECT `username` FROM `members` WHERE `username`='$myusername'
and `password`='$mypassword'";
echo $sql;
$result=mysql_query($sql) or die('Query Error: ' . mysql_error() . "<br
/>\n$sql");
echo $sql;
echo $result;
$count = mysql_num_rows ($result); // moved this line to AFTER you've executed the query
echo mysql_num_rows($result);
if($count>0)  {     session_start();     $_SESSION['logged_in'] =
true;
header("Location: login_success.php");     exit;  }
else {     echo "Wrong Username or Password"; }
?>