does record exist?

[n_wattam]

i want to run a bit of code to see if a record exists in my database or not.

each record in my database as a unique ID, and i want to run a check on this label, on say ID 65

at the moment i am running a few crude if statement for the same result, can anyone help please.

[n_wattam]

function recordExists($id,$idval,$table,$db) {//check for id=idval in table and return TRUE or FALSE
   $result = mysql_query("SELECT * FROM ".$table." WHERE ".$id."='".$idval."'", $db) or die(mysql_error());
   if($row = mysql_fetch_array($result)) {//if we did return a record
      return 1;
   }//end if row
   return 0;
}//end fuction recordExists

[stewartship]

Try this reformatted way without all the " "

$result = mysql_query(" SELECT * FROM '$table' WHERE '$id' = '$idval' ", $db)

[laserlight]

$result = mysql_query(" SELECT * FROM '$table' WHERE '$id' = '$idval' ", $db)

That's problematic since single quotes should not be used to delimit identifiers. Double quotes should be used, or in this case for MySQL, backticks.

I suggest two possible approaches:

// #1
function recordExists($id, $idval, $table, $db) {
	$result = mysql_query("SELECT `$id` FROM `$table` WHERE `$id`='$idval' LIMIT 1", $db)
		OR die(mysql_error());
	return mysql_num_rows($result) ? true : false;
}

// #2
function recordExists($id, $idval, $table, $db) {
	$result = mysql_query("SELECT COUNT(`$id`) FROM `$table` WHERE `$id`='$idval' LIMIT 1", $db)
		OR die(mysql_error());
	return mysql_result($result, 0) ? true : false;
}