php查询中正确的字符串语法

在php中，我有一行代码，查询数据库以查找自用户上次登录以来在聊天室内发布的消息的#。我还想为字符串查找数据中的子字符串。消息也是如此(用户的"昵称")。谁能告诉我如何正确地语法

$row1 = mysql_fetch_array(mysql_query("SELECT count(d.msgid) as con,d.msgid FROM `data` as d where d.room= '".$row['room']."' and d.msgid>(select u.lastmsgnotified from user as u where u.id='".$row['id']."') order by d.msgid desc limit 0,1"));

$row2 = mysql_fetch_array(mysql_query("SELECT count(d.msgid) as con2,d.msgid FROM `data` as d where d.room= '".$row['room']."' and d.msgid>(select u.lastmsgnotified from user as u where u.id='".$row['id']."') and strpos(d.message,$row[nickname])!==false order by d.msgid desc limit 0,1"));

if(intval($row2['con2'])>1){
        sendGCM($row2['con2']." New Alerts in ".$row['room'],$row['deviceid']);
    }else if(intval($row2['con2'])>0){
    $rok = mysql_fetch_array(mysql_query("select u.*,m.* from user as u, `data` as m where u.id=m.userid and m.msgid=".$row2['msgid']));
        if($rok['nickname']=='')
        $rok['nickname'] = 'A User';
        sendGCM($rok['nickname']." Has Alerted you in room '".$rok['room']."'",$row['deviceid']);
    }