$val)
{
$post[$key] = htmlentities($val);
}
//Uppkoppling mot mySql.
$link = mysql_connect('localhost', 'root', 'xxx');
if (!$link) {
die('Kunde inte öppna DB: ' . mysql_error());
}
//Välj databas som ska användas.
mysql_select_db("Diary", $link);
//Bygg lista med kolumner
$query='describe trainings;';
$result=mysql_query($query);
$columnList="";
while ($trRow = mysql_fetch_array($result))
{
$field=$trRow["Field"];
$type=$trRow["Type"];
$columnList[$field]=$type;
}
//Bygg lista med existerande träningsformer
$query='select distinct(trainingTypeName) name from trainings order by 1;';
$result=mysql_query($query);
$trainigTypesList="";
while ($trRow = mysql_fetch_array($result))
{
$trainigTypesList=$trainigTypesList.'