forum trouble

[simmsy]

hi was just wondering why anyone knew why this lets me post a topic then 1 reply then keeps coming back as error this is the add_answer.php code:

<?php

$host="localhost"; // Host name

$username="fightwat_simms"; // Mysql username

$password="Joannegiles30"; // Mysql password

$db_name="fightwat_users"; // Database name

$tbl_name="forum_answer"; // Table name

 

// Connect to server and select databse.

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

$id=$_POST['id'];

 

// Find highest answer number.

$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";

$result=mysql_query($sql);

$rows=mysql_fetch_array($result);

 

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1

if ($rows) {

$Max_id = $rows['Maxa_id']+1;

}

else {

$Max_id = 1;

}

 

// get values that sent from form

$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

 

// Insert answer

$sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_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

$tbl_name2="forum_question";

$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";

$result3=mysql_query($sql3);

 

}

else {

echo "ERROR";

}

 

mysql_close();

?>

[AdRock]

Are you sure the $sql2 query is being executed?

 

To check put after thw query var_dump($sql2) and it should tell you what is being put in the query, you may have variables that aren't set becuase to get ERROR, $result2 can't be taken