This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Dreamweaver > July 2005 > Alphabetical column in table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Alphabetical column in table
|
|
| goatfarmer98 2005-07-02, 7:23 pm |
| On a web page, I would like to have an alphabetical list of names in a table
format with three columns. This list will be a work in progress and therefore,
the problem I envision exists when adding additional names. What I don?t want
to do is go into Dreamweaver and insert a table row each time I want to enter
another name. I know that Excel will place a random list into alphabetical
order in a flash. How easy and what steps would it take to write a page in
Dreamweaver calling upon an Excel spreadsheet on the same server for the
alphabetical list and appropriate columns?
| |
| SnakEyez 2005-07-02, 7:24 pm |
| I wouldn't do what you want with Excel, it will be a hassle after awhile to
update the excel document, export it to DW, then clean up the HTML, then add it
to your site.
Personally I would recommend looking into databases like mysql or Access.
Both are very easy to use, and if you need simple stuff like sorting it will
make your life a lot easier because you can consistantly add new records, and
it will sort them automatically for you so you never have to update your page
again.
If you need more information on this, then please post what type of server you
are using and someone here should be able to get you going on your way.
| |
| Terry Hughes 2005-07-02, 7:24 pm |
|
"goatfarmer98" <webforumsuser@macromedia.com> wrote in message
news:da6l0b$3lj$1@forums.macromedia.com...
> On a web page, I would like to have an alphabetical list of names in a
table
> format with three columns. This list will be a work in progress and
therefore,
> the problem I envision exists when adding additional names. What I don?t
want
> to do is go into Dreamweaver and insert a table row each time I want to
enter
> another name. I know that Excel will place a random list into
alphabetical
> order in a flash. How easy and what steps would it take to write a page
in
> Dreamweaver calling upon an Excel spreadsheet on the same server for the
> alphabetical list and appropriate columns?
>
Have a look at this
http://www.kryogenix.org/code/browser/sorttable/
HTH
| |
| Mick White 2005-07-02, 11:16 pm |
| goatfarmer98 wrote:
> On a web page, I would like to have an alphabetical list of names in a table
> format with three columns. This list will be a work in progress and therefore,
> the problem I envision exists when adding additional names. What I don?t want
> to do is go into Dreamweaver and insert a table row each time I want to enter
> another name. I know that Excel will place a random list into alphabetical
> order in a flash. How easy and what steps would it take to write a page in
> Dreamweaver calling upon an Excel spreadsheet on the same server for the
> alphabetical list and appropriate columns?
>
I've written a script that does that and more, check the following:
http://mickweb.com/football/aleague/profiles2005.html
Mick
| |
| Dave Farmer 2005-07-03, 7:25 pm |
| On Sat, 02 Jul 2005 19:22:40 -0400, Mick White wrote:
> goatfarmer98 wrote:
> I've written a script that does that and more, check the following:
>
> http://mickweb.com/football/aleague/profiles2005.html
>
> Mick
Is the script available at all Mick.
| |
|
|
| goatfarmer98 2005-07-04, 7:35 pm |
| SnakEyez,
I have read and thought over the replies to my question by you, Terry, and
Mick. I very much like the idea of using a database in lieu of Excel or data
in <td>'s as there may be literally hundreds of rows of data. I am very
comfortable using Access - setting up a database would require no additional
learning. However, the rest of what I want to do is totally unknown to me. I
just emailed my host and asked them if I can have a table of data on their
server. I am somewhat comfortable with HTML and FTP. What are the steps
following the database development? Is there a on-line tutorial you would
recommend to "walk" me through this process? And of course any and all
suggestions will be greatly appreciated. I might add this is not a
professional or financial undertaking - strictly personal. In advance, thank
you for your assistance.:beer;
| |
| goatfarmer98 2005-07-04, 7:35 pm |
| Terry,
Reading your text, code and links I must admit it appears to be overwhelming.
However with that being said, this is not a professional and financial project
and therefore I could totally skip it without losing any ground but want to go
for it! I would like to have sortable columns as you do. I suspect I may have
hundreds of rows of data and believe using Access is the way I would like to
go. Your example contained database usage didnt it? How much of your code may
be copied, pasted and used by me in this project? I noticed you provided
credits to others who assisted you. I am very comfortable with Access.
MySQL, is that server type software I keep on my computer to simulate actual
server interactions? This will be a major learning curve for me but it is
something I would like to do. Any and all suggestions will be greatly
appreciated. :beer;
| |
| goatfarmer98 2005-07-04, 7:35 pm |
| Mick, thank you very much for your reply to my post. Using your code I would
have my project completed in no time. However, inasmuch as I may have hundreds
of rows of data and that I am extremely comfortable with Microsoft Access I
believe, for now, I would like to learn how to use a server database, if my
host permits it. I dont believe for one second that this will be something I
will be able to do over night. I also hope that my frustrations don't out
weigh the fun of learning. In advance, thanks for any and all suggestions and
encouragement. Frank
:beer;
| |
| David B 2005-07-04, 7:35 pm |
| goatfarmer98 wrote:
> Mick, thank you very much for your reply to my post. Using your code I would
> have my project completed in no time. However, inasmuch as I may have hundreds
> of rows of data and that I am extremely comfortable with Microsoft Access I
> believe, for now, I would like to learn how to use a server database, if my
> host permits it.
Forget Microsoft. Are you using PHP yet? If not, get it up and running,
along with mysql (and Apache server). There's a popular, user-friendly
preconfigured package called "Apache Friends" that you can find through
Google.
I dont believe for one second that this will be something I
> will be able to do over night. I also hope that my frustrations don't out
> weigh the fun of learning. In advance, thanks for any and all suggestions and
> encouragement. Frank
> :beer;
>
Yes, it can be a lot of work. I recently put several dozen dynamic
tables with sortable columns online at www.geosymbols.org/reference/
They're basically sortable via PHP, but I've tried to combine them with
Mick's script.
I'd like to use the JavaScript for quick, "WYSIWYG" sorting, then use
PHP for more complex sorting. For example, if your database is linked to
three separate tables, then you ought to be able to sort your columns by
fields in any of those tables. Suppose you have a table that list the
names of states in one column and state birds in another column, all
derived from a table named statebirds. Imagine another table named
statecapitals. You should be able to arrange the state birds according
to the name of the state capital. However, I haven't been able to get it
to work yet.
My scripts are kind of complex and not entirely bug free. But all you're
basically doing is writing a PHP script designed to display the contents
of your database. Once you get a handle on the basics, you can modify it
in countless different ways.
If all of this is completely new to you, I recommend hiring a tutor, if
you can afford it. If I could do it over again, I would gladly pay
$100-$200 to have a person come into my home and help me install and
configure Apache, PHP and mysql (and phpMyAdmin), show me how to use
them, set up virtual servers for my websites, then help me create and
display some simple databases and publish them online. It took me months
to learn how to do all of that, but you could probably do it in a day
with some help.
--
http://www.geobop.org/ (Geobop) | http://www.geoworld.org/ (GeoWorld) |
http://www.geozoo.org (GeoZoo) |
http://www.geosymbols.org (GeoSymbols) | http://www.politix.us/ (Kids'
Politix) |
http://geowebworks.geobop.org/ (Ethical Web Design) |
http://www.freedomware.us/ (Open Source Activism)
| |
| Mick White 2005-07-04, 7:35 pm |
| Dave Farmer wrote:
> On Sat, 02 Jul 2005 19:22:40 -0400, Mick White wrote:
>
>
[...][color=darkred]
>
>
> Is the script available at all Mick.
Yes, the only requirements are that the table be structured properly.
Table requires an ID, a tbody tag containing the tr's(no rowspan) and
td's (no colspan).
Mick
| |
| goatfarmer98 2005-07-04, 7:35 pm |
| David, I dont know PHP. I looked into this some time back and I believe my
host uses ASP. Would there be much of a difference?
My database will have only ONE table - which should make my job alot easier.
Actually what I want to do is list all persons with my surname who have served
in the military from the Revolutionary war to current along with possibly dates
of service, major unit, if died in service and maybe a remarks field. That is
why I say this will be an every growing list - information provided a little at
a time.
I like your suggestion about finding a tutor. I work at a major land grant
university with a hellva computer department. Will put out feelers. $200
spread out over two or three months of work - so I give up on my occasional
beer!
| |
| goatfarmer98 2005-07-04, 7:35 pm |
| Mick,
I will, thank you. Frank
| |
| David B 2005-07-04, 11:15 pm |
| goatfarmer98 wrote:
> David, I dont know PHP. I looked into this some time back and I believe my
> host uses ASP. Would there be much of a difference?
Yes, there's a difference. I wouldn't choose one or the other according
to what your host uses. As far as I know, almost all reputable hosts
support PHP. (Most may also support ASP; I know little about it.)
If you want to learn how to make dynamic tables, you need to learn one
or the other. I always promote PHP, but you should do some homework
before you decide. But rather than choose what your host uses, I'd
choose a good program, then find a host that supports it.
> My database will have only ONE table - which should make my job alot easier.
If you're only going to have one table, then you may be better off just
hiring someone to do it for you. Mick White's the local JavaScript
expert, while Gary White has given me lots of help with PHP.
> Actually what I want to do is list all persons with my surname who have served
> in the military from the Revolutionary war to current along with possibly dates
> of service, major unit, if died in service and maybe a remarks field. That is
> why I say this will be an every growing list - information provided a little at
> a time.
> I like your suggestion about finding a tutor. I work at a major land grant
> university with a hellva computer department. Will put out feelers. $200
> spread out over two or three months of work - so I give up on my occasional
> beer!
If you're as broke as I am, then forget everything I said and learn how
to do it yourself! A couple years ago, I could have afforded to pay
someone $200 outright - and I wish I had done so. :)
With a little help from newsgroups, you could probably get the Apache
Friends suit installed and configured in a couple days. If someone takes
you by the hand, you might learn how to make your database table in
another couple days. (That includes importing your data into your
table.) Then you need to learn how to make a script to display your table.
Finally, you have to create another database online and either publish
your table online or recreate it online. It doesn't seem all that
complex to me now, but it sure took me a while to get there.
--
http://www.geobop.org/ (Geobop) | http://www.geoworld.org/ (GeoWorld) |
http://www.geozoo.org (GeoZoo) |
http://www.geosymbols.org (GeoSymbols) | http://www.politix.us/ (Kids'
Politix) |
http://geowebworks.geobop.org/ (Ethical Web Design) |
http://www.freedomware.us/ (Open Source Activism)
| |
| Terry Hughes 2005-07-07, 7:17 am |
|
"goatfarmer98" <webforumsuser@macromedia.com> wrote in message
news:dac2pj$b91$1@forums.macromedia.com...
> Terry,
> Reading your text, code and links
<snip>
It's not mine mate. I only provided the link.
Terry
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|