PHP_MYSQL.为什么我的数据总是无法写入数据库？

在php页面提交了数据之后，发现无法写入mysql。。求解


<?php


    $name = $_POST['name'];
    // echo $name.'<p>';
       $phone = $_POST['phone'];
    // echo $phone.'<p>';
       $dizhi= $_POST['dizhi'];
       $youbian = $_POST['youbian'];
    $email = $_POST['email'];
    //echo $email.'<p>';

       $tel= $_POST['tel'];
       
       $ypname= $_POST['ypname'];
       $shuliang1= $_POST['shuliang1'];
       $shuliang2= $_POST['shuliang2'];
       $c1= $_POST['c1'];       
    //echo $info.'<p>';
   // $ip = getenv ('REMOTE_ADDR');
   
   
    $mysql_server_name="localhost";
    $mysql_surname    ="root";
    $mysql_password   ="123456";
    $mysql_database   ="asturn";



   
   
    $sql = "INSERT INTO gbook ( id , ypname , shuliang1 , shuliang2 , c1 , name , time_at, phone, dizhi, youbian, tel  ) VALUES ('', '$ypname', '$shuliang1', '$shuliang2', '$c1','$name', '$phone','$dizhi','$youbian','$ip', NOW( ),  );";
    $conn=mysql_connect( 'localhost','root','123456');
       mysql_select_db($mysql_database,$conn);
    $result = mysql_query($sql);
    $id = mysql_insert_id();
    mysql_close($conn);
    //echo   "留言成功，三秒后将自动转到留言板首页 ";
    echo   " <meta   http-equiv=refresh   content=5;url=show.php> ";
?>

[ 本帖最后由 a7535510 于 2011-5-17 12:17 编辑 ]

已解决

[ 本帖最后由 a7535510 于 2011-5-17 14:42 编辑 ]