Posted by Chris on 07/18/06 19:43

Thanks, but I don't quite understand. Wasn't the value (for all docs.projID
rows) assigned when the query runs?

$query_search = "SELECT Distinct docURL, docTitle, docDesc, docs.projID,
groupCode, projCode, catName FROM docs
JOIN subcat on subcat.subcatID=docs.subcatID
JOIN cat on cat.catID = subcat.catID
JOIN groups on groups.groupID=proj.groupID
JOIN proj on proj.projID=docs.projID
WHERE proj.projID=docs.projID AND docURL LIKE '%$keyword%' OR docTitle LIKE
'%$keyword%' OR docDesc LIKE '%$keyword%'";

Do you mean I should initialize a variable and give it a null value, then
run the query?

Christina

<tomwerner@gmail.com> wrote in message
news:1153250073.720919.208950@s13g2000cwa.googlegroups.com...
> Hi,
>
> Technically undefined index errors should not affect your script,
> however, if you want to get rid of these warnings then make sure you
> initialise that index, the best way being assigning it a null value.
>
> Tom
>

[Back to original message]