[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