PHP Errror - why?

[furious5]

My code keeps failing over after the first line of this code is executed.

I have added brackets, however the code still falls over.

Does anyone have any ideas what is wrong?

Error I am getting is
Parse error: parse error, unexpected T_IF in d:\web\result.php line 142

if($title!= "") 
$sql = "SELECT jobid, date, title, description, location, industry, salary FROM job WHERE title='".$jobid."'"

if($sector!= "") 
$sql_where .= " AND industry = '$sector'"; 

if($location!= "")
$sql_where .= " AND location = '$location'"; 

$limit_sql = " LIMIT ".$start.",".$pagelimit; 

$sql = $sql.$sql_where.$limit_sql;

[ahundiak]

Unless you dropped it while pasting then your first $sql = line is missing a semi-colon.

And you might want to add a few spaces when making the final query string or you may be disappointed by the results.

[furious5]

Ah yes it was the semi colon - thank you.

Can you explain what you mean by your last comment regarding spacing the final querystring?

[kevinsequeira]

its just the missing ; cause the different parts of the query have spaces before them

$sql_where .= " AND industry = '$sector'";

reg
kevin

[Norman_Graham]

I know it's a waste of my time saying this, but a parse error due to unexpected something on line X means a syntax error ... which means check your syntax - a good idea is to check it somewhere near the line number mentioned in the error message - before deciding that the code "doesn't work".

Thank you for your attention

Norm