each candidate’s interview information

// 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');
$cname = $_POST['intervieweeName'];
$communication = $_POST['intervieweeAbilities'];
$professional = $_POST['intervieweeAppearance'];
$cskills = $_POST['intervieweeSkills'];
$busknowldge = $_POST['intervieweeKnowledge'];
$icomment = $_POST['interviewerComments'];
$query = "insert into interviewee(intervieweeName,intervieweeAbilities,intervieweeAppearance,intervieweeSkills,intervieweeKnowledge,interviewerComments)values('$cname','$communication','$professional','$cskills','$busknowldge','$icomment')";
$result = mysql_query($query) or die('unable to insert the data'.$query.'.'.mysql_error());
if ($result = 1)
echo "

successfuly inserted

";

$query = "select * from interviewee";

$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 '';
echo '';
}
echo '

Candidate Name	Communication Abilities	Professional Appearance	Computer Skills	Business Knowledge	Interview Comments
'.$row[0].'	'.$row[1].'	'.$row[2].'	'.$row[3].'	'.$row[4].'	'.$row[5].'

';
}
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);

?>