the interviewer’s name, position, and date of interview

// Open connection to MYSQL server
$connection = mysql_connect('localhost','root') or
die('Unable to connect to MYSQL server');

// Select database for use
mysql_select_db('sholhutz') or die('Unable to select database');

$query = "insert into interviewer(interviewerName,interviewerPosition,interviewerDate) values ('Josephine','Manager',' ')";
$result = mysql_query($query) or die('unable to insert the data');
if ($result = 1)
echo "

successfuly inserted

";

$query = "select * from interviewer";

$result = mysql_query($query) or
die('Error in query:'.$query.'.'.mysql_error());

// Check if records were returned
if(mysql_num_rows($result) > 0)
{
// Print HTML Table
echo '';
echo '';

// print each row line by line

while($row = mysql_fetch_row($result))
{
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
}
echo '

ID	Name	Position	Date
'.$row[0].'	'.$row[1].'	'.$row[2].'	'.$row[3].'

';
}
else
{
// print error message
echo ' No Records found';
}

// Once processing is complete clear the result set
mysql_free_result($result);

// Close connection to MySQL server
mysql_close($connection);

?>