How To Check If Name Exist In The Sql Table Matching With Id?

[lovephp]

guys how do i do this

 

$id = $_REQUEST[''id'];

$name = $_SESSION[''name'];

 

if(Name Exist In Field == "Matching With Requested ID" ){

echo "show results";

}else{

echo "error";

}

[berridgeab]

Do you wish to match the given data to a record in a database?

[lovephp]

yes thats right from database i want to match whether the name exist in table field with the id requested

[Pikachu2000]

$query =  "SELECT COUNT(1) FROM table WHERE id = $id AND name = '$name'";
if( $result = mysql_query($query) ) {
 $array = mysql_fetch_row($result);
 if( $array[0] === 1 ) {
	  // name and id exist
 } else {
	  // name and id don't exist
 }
} else {
 // query resulted in an error
}