<?php
$host="localhost"; // Host name
$username="tryingthis_tryingthis"; // Mysql username
$password="haven505"; // Mysql password
$db_name="tryingthis_kusa"; // Database name
$tbl_name="kusa_reply"; // Table name

//Ugh

// Connect to server and select databse.
// Okay, good so far
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get value of id that sent from hidden field
// ...What?
$id=$_POST['id'];

// Find highest answer number.
// I want to kill myself PHP, I hope you know that
$sql="SELECT MAX(r_id) AS r_id FROM $tbl_name WHERE question_id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);

// get values that sent from form
// I know this fucking much god DAMN
$a_name=$_POST['a_name'];
$a_email=$_POST['a_email'];
$a_answer=$_POST['a_answer'];

$datetime=date("d/m/y H:i:s"); // create date and time // I hate you

// Insert answer
// Yeah, whatever
$sql2="INSERT INTO $tbl_name(question_id, r_id, r_name, r_email, r_answer, r_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')";
$result2=mysql_query($sql2);

if($result2){
echo "Successful<BR>";
echo "<a href='view_topic.php?id=".$id."'>View your answer</a>";

// If added new answer, add value +1 in reply column
// I don't HAVE A REPLY COLUMN
$tbl_name2="kusa_enter";
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
$result3=mysql_query($sql3);

}
else {
echo "ERROR (FFFFFFFFFFFFFFF-)" // Yeah I'll kill myself. It's decided
}

mysql_close();
?>