PHP code problem - unexpected T VARIABLE

[Broomy]

Hi. I have this code that someone wrote for me, but it gives me an error if I try and use it as follows:

Parse error: syntax error, unexpected T_VARIABLE

The line with the error refers to $sql = "

I'm useless at PHP but i'm hoping that someone might be able to point out what the problem might be.

Thanks for any help.

[code]<?php

$currentNodeCreated = $node->created;
$taxonomyTerm = 2 //this should not be hardcoded, it should be pulled from the node details for the current node taxonomy

$sql = "
  SELECT node.title, node.nid
  FROM {node}, {term_node}
  WHERE node.nid = term_node.nid
  AND node.tid = $taxonomyTerm
  AND node.created < $currentNodeCreated
  AND node.status = 1
  ORDER BY node.created DESC
  LIMIT 1";
$result = db_query($sql);
if($row = db_fetch_result($result) {
  $output .= l($row->title, "node/".$row->nid);
}
?>[/code]

[chris9902]

the problem line is: "$taxonomyTerm = 2"

you need a ";" after 2

so it should be "$taxonomyTerm = 2;"

[Broomy]

Thanks for the help, I appreciate it. That problem is now fixed but i'm not met with this error:

Parse error: syntax error, unexpected '{' on the line that refers to this:

if($row = db_fetch_result($result) {

Any more help would be great,

Thanks again.

[phil88]

if($row = db_fetch_result($result) {

Should be;


if($row = db_fetch_result($result)) {

You just missed off a bracket :)

[Broomy]

Ah, i'm good at this!  :-\

Thanks for that.