RE: [php_mysql] Creative solution with XML,PHP,MYSQL

[Tim Ward]

you can do it with javascript. assign all of the cell contents to a
javascript 2-d array of strings (mytext[x][y]). create the table with a
<div> in each cell. create a 2-d array of object pointers pointing to each
div. you can then change the contents of each div at will (for example when
a button is pressed). i.e. divobject[x][y].innerHTML = mytext[x][new_y]. I
use this technique a lot for game writing in js.

the complication in your case is that some of the js (building the arrays
and the table) needs to be built by the php. I've never tried this but it
should work if you just echo it as you would html.

	Tim Ward
	Senior Systems Engineer

Please refer to the following disclaimer in respect of this message:
http://www.stivesdirect.com/e-mail-disclaimer.html


> -----Original Message-----
> From: Tom Knight [mailto:t.knight@stripped]
> Sent: 19 February 2001 08:53
> To: php_mysql@stripped; php_uk@stripped;
> php-general@stripped; mysql@stripped; php@stripped;
> XML-L@stripped; spider@stripped
> Subject: RE: [php_mysql] Creative solution with XML,PHP,MYSQL
> 
> 
> I hate to say it, but the only way I can see of doing this 
> offhand is with
> ecmascript & dhtml.... or does that Dynamic Data Binding 
> (only works with
> ie5, or 5.5?) do this sort of thing?
> 
> Either way, you're looking at unbounded fun catering for 
> different browsers.
> 
> > -----Original Message-----
> > From: Siim Einfeldt aka Itpunk [mailto:siim_e@stripped]
> > Sent: 17 February 2001 14:25
> > To: php_uk@stripped; php-general@stripped;
> > mysql@stripped; php_mysql@stripped; php@stripped;
> > XML-L@stripped; spider@stripped
> > Subject: [php_mysql] 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.
> >
> >
> > ------------------------ Yahoo! Groups Sponsor 
> ---------------------~-~>
> > eGroups is now Yahoo! Groups
> > Click here for more details
> > http://click.egroups.com/1/11231/1/_/19011/_/982419916/
> > 
> --------------------------------------------------------------
> -------_->
> >
> > the PHP_mySQL group is dedicated to learn more about the
> > PHP_mySQL web database possibilities through group learning.
> >
> > http://www.1sdesign.com/web/books.shtml You can get books here.
> >
> >
> 
>