Jump to content

Archived

This topic is now archived and is closed to further replies.

Broomy

PHP code problem - unexpected T VARIABLE

Recommended Posts

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]

Share this post


Link to post
Share on other sites
the problem line is: "$taxonomyTerm = 2"

you need a ";" after 2

so it should be "$taxonomyTerm = 2;"

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
if($row = db_fetch_result($result) {

Should be;


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

You just missed off a bracket :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.