Parse Error

PHP
1

Hi all, I would apprecaite some help with a Parse error I am suffering from. I am very new to PHP, so please be gentle.

The error message is:

Parse error: syntax error, unexpected ‘;’ in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\landp\site\Property_comp\list.html.php on line 21

I have stared at the code for hours now and can not see where my error is, i would greatly appreciate some learned assistance!

below is an excerpt of the code, line 21 shown with //

<?php

include $_SERVER['DOCUMENT_ROOT']. '/landp/site/includes/magicquotes.inc.php';

// add property comparable details - call form
if (isset($_GET['addproperty']))
{
include $_SERVER['DOCUMENT_ROOT']. '/landp/site/includes/db.inc.php';
include 'form.html.php';
exit();
}

//add property details - add to DB
if (isset ($_POST['house_name_text']))
{

	
	$house_name_text = mysqli_real_escape_string($link, $_POST['house_name_text']);
	$house_number_text = mysqli_real_escape_string($link, $_POST['house_number_text']);
	$addline1_text = mysqli_real_escape_string($link, $_POST['addline1_text']);
	$sql = 'INSERT INTO property set house_name="' .$house_name_text. '" , house_number="' .$house_number_text. '" , addline1="' .$addline1. '" ' //line 21
	
	if (!mysqli_query ($link, $sql))
2

Solved by new eyes and a good nights sleep. the error message is for list.html.php - the code was for my controller - a different piece of code entirely.

lesson learnt i think!

ty

3

There is something missing at the very end of that line.

4

Sorry - i posted a copy that i had removed the ‘;’ from the end.

i get this error:

Parse error: syntax error, unexpected ‘;’ in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\landp\site\Property_comp\list.html.php on line 21

when i have

$sql = 'INSERT INTO property set house_name="' .$house_name_text. '" , house_number="' .$house_number_text. '" , addline1="' .$addline1. '" '; //line 21

if i leave the ‘;’ off i get this error instead

Parse error: syntax error, unexpected T_IF in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\landp\site\Property_comp\TMPt2l6f8g1py.php on line 23

I assume because the code is moving into the if command below line 21

sorry for my newbie posting error!