MySQL Error, Convert SQL -> MySQL

I usually write stuff in sequel, can someone help me convert this, i’m having problems.

[code=php]
$look_up_user_info = mysql_query(“SELECT * FROM `user_system` WHERE `Email_Address` = ‘$email_address’ AND `List_Code` = ‘$free_gift'”, $dbconn);
while($view_column = mysql_fetch_array($look_up_user_info)) {
$lui_first_name = trim(”.$view_column[‘First_Name’].”);
$lui_last_name = trim(”.$view_column[‘Last_Name’].”);
$lui_customer_id = trim(”.$view_column[‘Customer_Ref_ID’].”);
}

if(mysql_fetch_row($look_up_user_info))
{
$result = mysql_do($dbconn, $look_up_user_info);
mysql_do($dbconn, $look_up_user_info);

echo “good”;
}
else
{
echo “bad”;
}
[/code]

I just want a yes or no if query finds the record that is searched for, if not, display bad.

Also in #PHP _↴