Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE o
Hi,
I am new to PHP, but was hoping for help with the following error message. I think the line of code is from the following:
PHP Code:
if ($docs_exclus) $docs_exclus = "AND l.id_document NOT IN ($docs_exclus) ";
} else $docs_exclus = '';
//// Images sans documents
$images_liees = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l "."WHERE l.id_".$type."=$id AND l.id_document=docs.id_document ".$docs_exclus."AND docs.mode='vignette' ORDER BY docs.id_document");
$ret .= "\n<p></p><div id='liste_images'>";
Any help would be appreciated.
Mark
Last edited by wirehopper; 11-06-09 at 07:08 AM.
Reason: PHP tags
if ($docs_exclus) $docs_exclus = "AND l.id_document NOT IN ($docs_exclus) ";
} else $docs_exclus = '';
//// Images sans documents
$images_liees = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l "."WHERE l.id_".$type."=$id AND l.id_document=docs.id_document ".$docs_exclus."AND docs.mode='vignette' ORDER BY docs.id_document");
$ret .= "\n<p></p><div id='liste_images'>";
Mark
To this:
PHP Code:
if ($docs_exclus){
$docs_exclus = "AND l.id_document NOT IN ($docs_exclus) ";
} else {
$docs_exclus = '';
}
//// Images sans documents
$images_liees = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l "."WHERE l.id_".$type."=$id AND l.id_document=docs.id_document ".$docs_exclus."AND docs.mode='vignette' ORDER BY docs.id_document");
//// Documents associes
$res = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l WHERE l.id_".$type."=$id AND l.id_document=docs.id_document AND docs.mode='document' ORDER BY docs.id_document");
$documents_lies = array();
while ($row = spip_fetch_array($res))
$documents_lies[]= $row['id_document'];
if (count($documents_lies)) {
$res = spip_query("SELECT DISTINCT id_vignette FROM spip_documents WHERE id_document in (".join(',', $documents_lies).")");
while ($v = spip_fetch_array($res))
$vignettes[]= $v['id_vignette'];
$docs_exclus = ereg_replace('^,','',join(',', $vignettes).','.join(',', $documents_lies));
if ($docs_exclus) {
$docs_exclus = "AND l.id_document NOT IN ($docs_exclus) ";
} else {
$docs_exclus = '';
}
//// Images sans documents
$images_liees = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l "."WHERE l.id_".$type."=$id AND l.id_document=docs.id_document ".$docs_exclus."AND docs.mode='vignette' ORDER BY docs.id_document");
//// Documents associes
$res = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l WHERE l.id_".$type."=$id AND l.id_document=docs.id_document AND docs.mode='document' ORDER BY docs.id_document");
$documents_lies = array();
while ($row = spip_fetch_array($res)) {
$documents_lies[]= $row['id_document'];
}
if (count($documents_lies)) {
$res = spip_query("SELECT DISTINCT id_vignette FROM spip_documents WHERE id_document in (".join(',', $documents_lies).")");
while ($v = spip_fetch_array($res)) {
$vignettes[]= $v['id_vignette'];
$docs_exclus = ereg_replace('^,','',join(',', $vignettes).','.join(',', $documents_lies));
}
}
if ($docs_exclus) {
$docs_exclus = "AND l.id_document NOT IN ($docs_exclus) ";
} else {
$docs_exclus = '';
}
//// Images sans documents
$images_liees = spip_query("SELECT docs.id_document FROM spip_documents AS docs, spip_documents_".$type."s AS l "."WHERE l.id_".$type."=$id AND l.id_document=docs.id_document ".$docs_exclus."AND docs.mode='vignette' ORDER BY docs.id_document");
Linear Mode
