check user if exist?

[solidcodes]

hi i know this is very basic,

but i'm currently freakin out because for some reason my codes don't work.

here is my codes below,

$query = "SELECT firstname, lastname FROM member WHERE firstname='$fname' AND lastname='$lname'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
		$row = mysql_fetch_array($result);
		$fname2 = $row['firstname'];
		$lname2 = $row['lastname'];

By the way i want to check the full name since the first and last name is in
separate column.

Is there something wrong with my codes?

Can you show me your style please.

Thank you.

[corbyboy]

What error are you getting?

The first thing I always do to debug my MYSQL code is to echo out $query just before I execute it to ensure all the variables have been inserted correctly.

[Jake Arkinstall]

$FirstName = MySQL_Real_Escape_String($FirstName);
$LastName = MySQL_Real_Escape_String($LastName);
$Query = "SELECT 1 FROM users WHERE FirstName='{$FirstName}' AND LastName='{$LastName}'";
$Result = MySQL_Query($Query) or exit("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
if(MySQL_Num_Rows($query) > 0){
    //User exists. $FirstName is already set to the firstname, $LastName is already set to the last name.
}else{
    //user doesn't exist
} 

[oxodesign]

Try this:

<?php
    $fname = "YourName";
    $lname = "YourLastName";

    $query = "SELECT firstname, lastname FROM member 
            WHERE firstname = '$fname' AND lastname = '$lname' LIMIT 1";
    $result= mysql_query($query) or die("Error: " . mysql_error());
    
    if(mysql_num_rows($result) == 1){
        $row = mysql_fetch_array($result);
        $fname2 = $row['firstname'];
        $lname2 = $row['lastname'];
    }else{
        echo "No user found!";
    }
?>