[support] book module

Eric-Alexander Schaefer eric at gixgax.de
Wed Nov 21 07:07:19 UTC 2007


Sarah.Vardy at 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


More information about the support mailing list