Hi
I have created a form, for users to enter the name of a file and it
then gets displayed. This works..

I've editted it so the form now search through a few different fields
and tries to match..
This works EXCEPT !!

The field FileKeywords never seems to get searched.. Or more to the
poitn the results are never returned..

Have I screwed up the SQL Query or the writting of the results ??


//Get the number of results
$SearchResult=mysql_query("SELECT * FROM Files WHERE FileTitle LIKE
'%$SearchString%' || FileDescription LIKE '%$SearchString%' ||
FileKeywords LIKE '%$SearchString%' ORDER BY FileTitle") or
die(mysql_error());
$NumberOfResults=mysql_num_rows($SearchResult);

//Get the number of pages
$NumberOfPages=ceil($NumberOfResults/$Limit);

$SearchResult=mysql_query("SELECT * FROM Files WHERE FileTitle LIKE
'%$SearchString%' || FileDescription LIKE '%$SearchString%' ||
FileKeywords LIKE '%$SearchString% 'ORDER BY FileTitle LIMIT " .
($page-1)*$Limit . ",$Limit") or die(mysql_error());

While($row = mysql_fetch_object($SearchResult)) {

Echo "  <a href=\"filestore/" . $row->FileLink . "\"><img
border=\"0\" src=\"smallicons/" . $row->FileIcon . ".gif\" width=\"20\"
height=\"20\"> $row->FileTitle</a> - " . $row->FileDescription .
"<br><br>";


Many Thanks for your help !!

Echo " <a href=\"filestore/" . $row->FileLink . "\"><img
border=\"0\" src=\"smallicons/" . $row->FileIcon . ".gif\" width=\"20\"
height=\"20\"> $row->FileTitle</a> - " . $row->FileDescription .
"<br><br>";

what do the forward slashes after filestore and smallicons mean?

strawberry wrote:

> Echo " <a href=\"filestore/" . $row->FileLink . "\"><img
> border=\"0\" src=\"smallicons/" . $row->FileIcon . ".gif\" width=\"20\"
> height=\"20\"> $row->FileTitle</a> - " . $row->FileDescription .
> "<br><br>";
>
> what do the forward slashes after filestore and smallicons mean?

Thats the path.

smallicons/ fileIcon !

jerryyang_la1 [at] yahoo.com wrote:
> strawberry wrote:
>
> > Echo " <a href=\"filestore/" . $row->FileLink . "\"><img
> > border=\"0\" src=\"smallicons/" . $row->FileIcon . ".gif\" width=\"20\"
> > height=\"20\"> $row->FileTitle</a> - " . $row->FileDescription .
> > "<br><br>";
> >
> > what do the forward slashes after filestore and smallicons mean?
>
> Thats the path.
>
> smallicons/ fileIcon !

OK - I think you have to escape the closing quotation marks:

\"
filestore/
\"

Sorted !!

|| FileKeywords LIKE '%$SearchString% ' ORDER BY FileTitle LIMIT " .

The problem was an extra space, the aboe line should have read:

|| FileKeywords LIKE '%$SearchString%' ORDER BY FileTitle LIMIT " .

<jerryyang_la1 [at] yahoo.com> wrote in message
news:1159104007.301710.20820 [at] i3g2000cwc.googlegroups.com...
>
> strawberry wrote:
>
> > Echo " <a href=\"filestore/" . $row->FileLink . "\"><img
> > border=\"0\" src=\"smallicons/" . $row->FileIcon . ".gif\" width=\"20\"
> > height=\"20\"> $row->FileTitle</a> - " . $row->FileDescription .
> > "<br><br>";
> >
> > what do the forward slashes after filestore and smallicons mean?
>
> Thats the path.
>
> smallicons/ fileIcon !
>

I see you fixed your SQL problem but... how about,

Echo " <a href='filestore/{$row->FileLink}'><img border='0'
src='smallicons/{$row->FileIcon}.gif' width='20'
height='20'>{$row->FileTitle}</a> - {$row->FileDescription}<br><br>\n\r";

....I find this alot easier on the eyes... to include multi-dimensional
arrays ($a['one']['two']) or object properties (as above) you just need to
enclose them in {} within your double quoted strings... and not only that
but now your php code actually looks 99.9% of what you actually expect the
output to be.

Norm
--
FREE Avatar hosting at www.easyavatar.com