4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: Ofuuzo on July 11, 2002, 12:18:47 PM

Title: Searching a field containing words and numbers
Post by: Ofuuzo on July 11, 2002, 12:18:47 PM

I have added a field to the database to show not only the keywords, description, date ... I called the field "image_date_range". I then imported from an old textfile database to 4image database the following values in "image_date_range" field:

image_Id ... image_date_range
00               ca. 1900 =>meaning approx. 1900
01               1900
02               1900-tallet => meaning 1900 to 1999
03               1950-tallet => meaning 1950 to 1959
04               1725-2001
...

I want to extend search.php (advanced search => Search the following fields) so that when a search parameter is
1800-2000, the result of the search result will be images whose date range are:
ca. 1900
1900
1900-tallet
1950-tallet
1725-2001

When the search parameter is 1900-1949, the result will be
ca. 1900
1900
1900-tallet
1725-2001

When the search parameter is 1950 - 2000, the result will be
1900-tallet
1950-tallet
1725-2001

Can you point me in which files (or functions, arguments) to do that or how I can do that?

Thanks in advance.

- Ofuuzo

Title: intrested
Post by: Jaap12 on July 24, 2002, 07:05:14 PM

i'm 2 intrested to search in other "tables" let me know

Title: Searching a field containing words and numbers
Post by: Jaap12 on July 30, 2002, 08:36:31 PM

Hi jan, can you make somthing for me? I want to pay for it.

See my question here to:

http://www.4homepages.de/forum/viewtopic.php?t=1046&highlight=