Re: Re: How to place Search Results!!!

[ACJavascript]

Hey sgifford, The code you presented gave me some errors. But i think I know were your going with it.

I was thinking. Would this work.

1. User Types in string.
2. The string is checked searchs through the database. 3. Any results are then pushed into a Hash or Array 4. Then the array (hash) is sorted by least price. 5. then printed out.

Would that work??

A*C

[sgifford]

That's odd that it gave you errors. I just re-ran it, and it worked fine.

Anyways, yes, I think what you're thinking will work.

If your flat-file database gets very large, you'll want to look at using a db or dbm database, or maybe SQL. Searches will get slower as the number of items in the flatfile grows.

[ACJavascript]

hello again, Okay,, One problem hehehe,, How can I sort it lol
HELP!!! lol

[sgifford]

Do you mean how can you sort a DBM/DB database? Well, with Berkeley DB you can create a BTree database, which is sorted on some key. Otherwise, you can create a database keyed on the field you want to sort by, then extract all of the keys from the DB with keys, sort the keys, then retreive the entries in the right order based on that.

With SQL, you'd simply use an ORDER BY clause.

But you shouldn't have to worry about that unless you have a large number of records.