Need help! I need to fix this error...

Vooler said: ↑

Try this, I am sure you required this:


#First prevent SQL Injection
#if $_POST['id'] is integer use [B]intval[/B]($_POST['id']), and if it is string use [B]htmlspecialchars[/B]($_POST['id'])
#-------------------------------------------------------------------------------------------------
$id=$_POST['id']; #Talking about this for SQL Injection

// Find highest answer number.
$sql="SELECT MAX(a_id) AS `maxa_id` FROM `$tbl_name` WHERE `question_id`='$id'";
$result=[B]mysql_query[/B]($sql);

if([B]$result === FALSE[/B]) {
	echo "1:".mysql_error(); #query has error
	@mysql_close();
	die();
}

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1
if([B]mysql_num_rows[/B]($result) ==0) {
	$max_id = 1;
} else {
	$rows = [B]mysql_fetch_assoc[/B]($result);
	$max_id = $rows['maxa_id'] + 1;
}

Code (markup):

Click to expand...

Ok, Well now I just get this error -

1:Unknown column 'a_id' in 'field list'

Code (markup):

@kmap - Well this part of the script is called "add_answer.php" where it inputs the data you put into the database, so if I just installed the script it should still be able to input data into the database.

Log in or Sign up

Need help! I need to fix this error...

Carsen Well-Known Member

Log in or Sign up

Need help! I need to fix this error...

Carsen Well-Known Member

Useful Searches