How to create a table and insert records and retrieve data?

<?php
// mysql Connection
mysql_connect("localhost", "root", "pass") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

//emp table create
mysql_query("CREATE TABLE emp(id INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(id),empname VARCHAR(30), empid INT)") or die(mysql_error());

//insert records to emp table
mysql_query("INSERT INTO emp (empname, empid) VALUES('melvin', '101' ) ") or die(mysql_error());

mysql_query("INSERT INTO emp (empname, empid) VALUES('rudie', '102' ) ")  or die(mysql_error());

// get data
$result = mysql_query("SELECT * FROM emp")or die(mysql_error());
$rec = mysql_fetch_array( $result );

// print the result
echo "empname: ".$rec['empname'];
echo "empid: ".$rec['empid'];
?>