PHPRunner 6.1 manual - Events. Check if specific record exists

To check if a specific record exists use Check if a specific record exists action.

step11-1-4

Note: Change the values listed in red to match your specific needs.

//********** Check if specific record exists ************

global $conn;

$strSQLExists = "select * from AnyTable where AnyColumn='SomeValue'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

// if record exists do something

}

else

{

// if dont exist do something else

}