the value stored in the databae may be a string, not a number, try this instead:
[php]<?php if ($row_Recordset2['client1_title'] == '1'){
echo "Ms";
} elseif ($row_Recordset2['client1_title'] == '2'){
echo "Mrs";
} elseif ($row_Recordset2['client1_title'] == '3'){
echo "Miss";
} elseif ($row_Recordset2['client1_title'] == '4'){
echo "Mr";}
?>[php]