Re: Creative solution with XML,PHP,MYSQL

Siim, You can do this with a combination of XML and XSL. I remember a demo from Microsoft's XML area that did exactly what you ask: Click a column and have it sort. I believe it was an example having to do with Stock listings. Basically XSL lets you use come programming/looping constructs when displaying data from an XML file. The downside is that it currently only works with IE 5 and greater. It might not be the best overall solution, but if you are looking at the issue from a "can it be done" point of view, then yes, it can actually be done. It just might not be usable. Tim Frank >>>>>>>>>>>>>>>>>> Original Message >>>>>>>>>>>>>>>>>> <<<<<<<<<<<<<<<<<< On 17/02/01, 9:23:00 AM, siim_e@pshg.edu.ee (Siim Einfeldt aka Itpunk) wrote regarding [PHP] Creative solution with XML,PHP,MYSQL: > Hi everybody, > I want to implement ordering something on a website without refreshing the > page. Lets say i have four columns in the html table - name,age,skill and > phone. All these are links - under these are the information, eg: > Name Age Skill Phone > Siim 23 php 051... > Tony 18 html 132... > Now, when i click on the name, it should order the listings by name, if I > click on the age, I get the listing ordered by age and etc,etc. Generally > it is easy to do it, but how to do it without refreshing the page every > time I want to order by something else? > It should be possible with XML; I get the data from mysql database with > php, I write it into an array and ... now how could I make it function the > way I just described? Could someone point me some already written code or > explain me in detail how to do it? > Thank you, > Siim Einfeldt > PS: Sorry about sending this message to so many lists, but I haven`t seen > this kind of code anywhere, but at the same time I know it is possible.. > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net