phpでDB接続その2(mysql)

<?php

//MySQL接続
echo "** MySQL接続 ***********\n";

  $server = "localhost";
  $user = "root";
  $pass = "root";

  //DB接続
  $db = mysql_connect($server,$user,$pass);
  if (!$db) {
    die("接続失敗\n" . mysql_error());
    return;
  }
  else {
    echo "接続成功.\n";
  }

  //データベース選択
  $seldbflg = mysql_select_db("test",$db);
  if(!$seldbflg){
    //echo "データベース選択失敗..\n";
    //Mysql接続CLOSE..
    die("データベース選択失敗\n");
    mysql_close($db);
    return;
  }
  else{
    echo "データベース選択成功..\n";
  }

  //select実行
  $sql = "select * from emp";
  $result = mysql_query($sql, $db);
  if (!$result) {
    die("$sql::失敗\n" . mysql_error());
  }
  else{
    //SQL実行結果を配列に設定する関数は、"mysql_fetch_array("sql実行結果","配列構造(MYSQL_ASSOC or MYSQL_NUM)")"
    while ($row = mysql_fetch_array($result)){
      print $row[0].",".$row[1].",".$row[2].",";
      print $row['ID'].",".$row['EMP_NO'].",".$row['EMP_NAME'].",";
      print "\n";
    }
  }

  //insert文
  echo "★insert文\n";
  $sql = "insert into emp (emp_no,emp_name,mgr_id,hiredate,sal,dept_id,version_no) values (7985,'YUM',2,'2008-04-25',3000,2,1)";
  $result = mysql_query($sql);
  if(!$result){
    die("$sql::失敗\n" . mysql_error());
    return;
  }
  else{
    print "insert成功..\n";
  }

  //update文(パラメータに値を設定する)
  echo "★update文\n";
  $id = mysql_insert_id($db);
  $query = "update emp set emp_name = '%s' where id = %d";
  $sql = sprintf($query, mysql_real_escape_string("WWC",$db), $id);
  $result = mysql_query($sql);
  if(!$result){
    die("$sql::失敗\n" . mysql_error());
    return;
  }

  //テーブル結合
  echo "★テーブル結合\n";
  $sql = "select e.id, e.emp_no, e.emp_name,d.dept_no, d.dept_name from emp e join dept d where e.dept_id = d.id order by e.id";
  $result = mysql_query($sql);
  if(!$result){
    die("$sql::失敗\n" . mysql_error());
    return;
  }
  else{
    while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
      print $row['id'].",".$row['emp_no'].",".$row['emp_name'].",".$row['dept_no'].",".$row['dept_name'].";;";
      print "\n";
    }
  }

  //Mysql接続CLOSE..
  mysql_close($db);
echo "** MySQL接続終了.. ***********\n";
?>