请问如下的SQL语句能否实现

Question

<?php
                $adday=date("m-d "."H:i");
                $name=$_POST['name'];
                $favorite=$_POST['favorite'];
                $address=$_POST['address'];
                $postcode=$_POST['postcode'];
                $oicq=$_POST['oicq'];
                $mailbox=$_POST['mailbox'];
                $phonenum=$_POST['phonenum'];
                $word=$_POST['word'];
                $picurl=$_POST['picurl'];
                if($mailbox=="") {$email="[email protected]";}
                if($oicq=="") {$oicq="88888888";}
                if($picurl=="") {$picurl="images/text1.jpg";}
                if($name != "")
                {
                        $connect = @mysql_connect("192.168.0.112", "root", "");
                        mysql_select_db("AddBook", $connect);
                        $query = "insert into addbook values('".$name."','".$favorite."','".$address."','";
                        $query = $query.$postcode."','".$oicq."','".$mailbox."','".$phonenum."','".$word."','".$picurl."')";
                        echo "$query";
                        $result = mysql_query($query);
                        $a_row = @mysql_affected_rows($result);
                        echo "$a_row";
                        mysql_close($connect);
                }
        ?>