Author Topic: Searching a field containing words and numbers  (Read 5807 times)

0 Members and 1 Guest are viewing this topic.

Offline Ofuuzo

  • Newbie
  • *
  • Posts: 29
    • View Profile
Searching a field containing words and numbers
« 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

Offline Jaap12

  • Full Member
  • ***
  • Posts: 108
    • View Profile
intrested
« Reply #1 on: July 24, 2002, 07:05:14 PM »
i'm 2 intrested to search in other "tables" let me know

Offline Jaap12

  • Full Member
  • ***
  • Posts: 108
    • View Profile
Searching a field containing words and numbers
« Reply #2 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=