21 Nov
2007
21 Nov
'07
7:07 a.m.
Sarah.Vardy@student.griffith.edu.au schrieb:
|<?php $node_result = db_query(db_rewrite_sql('SELECT n.nid, n.title, b.parent, f.filepath FROM {node} n INNER JOIN {book} b ON {n.vid = b.vid} n join {image_attach} nr on (n.nid = nr.nid)INNER JOIN {files} f ON nr.iid = f.nid WHERE n.nid = %d && f.filename = 'thumbnail''), $nid);
Your query string ends after "f.filename = ", because you put the whole string in single quotes ['] and "thumbnail" as well. Replace either ones with double quotes ["].
HTH, Eric