Hi all

I am trying to use In_array to check if a result is avalible in the dataase,
however it only every shows me not found. my code is

$sid = session_id();
$sessioncart = odbc_exec($Conn, "SELECT sessionUserID FROM sessionTempTable");
$scar = odbc_fetch_array($sessioncart);

if (in_array($sid, $scar))
{
echo "found";
}
else
{
echo"not found";
}

Any suggests or idea where I am going wrong

Hi,

in_array syntax is correct, I suggest you, to just change your logic by adding where condition in your sql query:

$sid = session_id();
$sessioncart = odbc_exec($Conn, "SELECT sessionUserID FROM sessionTempTable where sessionUserID=".$sid." ");