Tack för hjälpen! ändrade koden till följande
<?php
$con=mysqli_connect(localhost,******,******,******);
if (mysqli_connect_errno($con))
{
echo "<h1>Failed to connect to mysql server " . mysqli_connect_error() ."</h1>";
}
$title = mysqli_real_escape_string($con, $_POST['title']);
$post = mysqli_real_escape_string($con, $_POST['html']);
$author = mysqli_real_escape_string($con, $_POST['selectlist1']);
$datetime = date('y-m-d h:i:s',time());
$category = mysqli_real_escape_string($con, $_POST['selectlist2']);
$sql="INSERT INTO blogposts(title,post,author,datetime,category) VALUES('$title','$post','$author','$datetime','$category')";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
else
mysqli_close($con);
header("Location:../blog/admin.php");
?>
och nu fungerar det som det ska, hur som helst följer denna kod god praxis?