$con = mysql_connect("localhost", "10514154", "lia154");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$linkdb=mysql_select_db("mim10514154",$con);
if (!$linkdb)
{die ("Could not connect to the Database!".mysql_error());
}
$result=mysql_query("SELECT * FROM `soccer players` where Name ='".$N."'");
if (!$result)
{die ("result false".mysql_error());
}
echo"
| Name | Fullname | Date of Birth | Position | Number | Club | Period | Appearances | Goal | Club2 | Period2 | Appearance2 | Goal2 | Club3 | Period3 | Appearances3 | Goal3 | Club4 | Period4 | Appearances4 | Goal4 | National Team | Appearances in National Team | Goal in National Team |
| ".$row['Name']." | ";". $row['Full Name']." | ";echo"".$row['Date of Birth']." | ";echo"".$row['Position']." | ";echo"".$row['Number']." | ";echo"".$row['Club']." | ";echo"".$row['Period']." | ";echo"".$row['Appearances']." | ";echo"".$row['Goal']." | ";echo"".$row['Club2']." | ";echo"".$row['Period2']." | ";echo"".$row['Appearances2']." | ";echo"".$row['Goal2']." | ";echo"".$row['Club3']." | ";echo"".$row['Period3']." | ";echo"".$row['Appearances3']." | ";echo"".$row['Goal3']." | ";echo"".$row['Club4']." | ";echo"".$row['Period4']." | ";echo"".$row['Appearances4']." | ";echo"".$row['Goal4']." | ";echo"".$row['National team']." | ";echo"".$row['Appearances in National team']." | ";echo"".$row['Goal in National Team']." | ";echo"
mysql_close($con);
?>