<div>
logudotcom thanks, I need to look inside.<br />
Ray, what do you ask?
</div>


<div>
I think jQuery is how Google does its auto-suggest, and if it is good enough for Google, it should meet your needs. &nbsp;Are we talking about Excel files (xls) or XML Style Sheets (xsl)? &nbsp;Why would you not want to use a data base table?
</div>


<div>
Hi Ray, The file is .xls extension.<br />
I'm not familiar with JQuery but it seems that this is the direction and I should study it.<br />
as I said there are many lines (&gt; 50,000) so transferring the xls to MySQL DB is not suitable.<br />
It looks like I need to transfer the xls to XML file.<br />
Thanks, Aryeh.
</div>


<div>
50,000 rows is nothing to a MySQL DB; you may be underestimating the power of MySQL. &nbsp;If you want to do lookups I can guarantee that the data base is a better technology than XML. &nbsp;XML is a markup language and that makes it suitable for data transfer but it's not the right tool for storage and retrieval.
</div>


<div>
I agree that XML is not the best choice. I need to see if there is really a problem using MySQL to hold large number of rows table. Thanks for the discussion.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
My site is Joomla (php) based. I have an Excel (xls) file<br />
that I need to preform a Web search on it.<br />
The search should have the fields as the columns of the table<br />
and have the auto complete feature.<br />
e.g. if there are fields called &quot;Avenue&quot; and another &quot;Avabla&quot;.<br />
and the user type &quot;av&quot; it should suggest both options.<br />
Also, since the xsl file has many rows (&gt; 50,000), I prefer to transform it to a different format (like Xml maybe?) and not to an SQL table.<br />
Thanks, Aryeh.
</div>
</div>


Hello,
My site is Joomla (php) based. I have an Excel (xls) file
that I need to preform a Web search on it.
The search should have the fields as the columns of the table
and have the auto complete feature.
e.g. if there are fields called "Avenue" and another "Avabla".
and the user type "av" it should suggest both options.
Also, since the xsl file has many rows (> 50,000), I prefer to transform it to a different format (like Xml maybe?) and not to an SQL table.
Thanks, Aryeh.

auto complete Web serach

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Joomla is a free and open-source content management system (CMS) for publishing web content. It is built on a model–view–controller web application framework that can be used independently of the CMS. Written in PHP, Joomla uses object-oriented programming (OOP) techniques and software design patterns, stores data in a MySQL, MS SQL  or PostgreSQL database, and includes features such as page caching, RSS feeds, printable versions of pages, news flashes, blogs, search, and support for language internationalization.