databases?

ok, so i know static web site design, but i don't know how to do dynamic pages.
i am trying to create a web site that when you click on certain areas of a
map, it will display information that is pulled from 2 different excel
documents. can someone please explain how to go about doing this? would i
need to build the site in asp? php? aspx? not too sure of the lingo. thank
you!

First off, Excel is not a database. So that is not an option. The data would
need to go into an actual database. This will typically be dependent on your
web hosting provider. They normally only provide you with access to a certain
type of database like mySQL, MS SQL, or Access just to name a few. Then the
type of page is also dependent on this. Your host should be able to give you
this information.

Once you have the information someone here should be able to help get your
going in the right direction.

ok. i'm hosting with go daddy and i know they allow some type of sql database. so what would the easiest way to get excel info into a dynamic page?

Export to CSV. Import to MySQL.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"King Evil" <webforumsuser (AT) macromedia (DOT) com> wrote

ok. i'm hosting with go daddy and i know they allow some type of sql
database. so what would the easiest way to get excel info into a dynamic
page?

Strictly speaking, Excel is a spreadsheet program; not a database program.
If you know how to create a MySql table, you could save your excel sheet as
a delimited csv file and then import that into your MySql table.
http://www.hotscripts.com/Detailed/69719.html


--Nancy O.
Alt-Web Design & Publishing
www.alt-web.com



"King Evil" <webforumsuser (AT) macromedia (DOT) com> wrote

ok. i'm hosting with go daddy and i know they allow some type of sql
database. so what would the easiest way to get excel info into a dynamic

page?

ok, thanks. i can do that.

quick change in scenario. let's say i would want to build a LOCAL web page. how would i do that?

FILE | New > Basic HTML

Save it in your local site.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"King Evil" <webforumsuser (AT) macromedia (DOT) com> wrote

ok, thanks. i can do that.

quick change in scenario. let's say i would want to build a LOCAL web
page. how would i do that?

Hello,

If your hosting on a Window's server that supports ASP and the database is
just going to provide data and not be written to, you could use Access as
well. It's fairly easy to set up in this case.
Using Access for a dynamic site that writes to the database can be
problematic if the site gets busy, but just displaying data won't be an
issue.
Just another alternative to the other excellent ones already posted..

Take care,
Tim


"Nancy O" <nancyoshea1 (AT) NOSPAMatt (DOT) net> wrote

Strictly speaking, Excel is a spreadsheet program; not a database program.
If you know how to create a MySql table, you could save your excel sheet
as
a delimited csv file and then import that into your MySql table.
http://www.hotscripts.com/Detailed/69719.html


--Nancy O.
Alt-Web Design & Publishing
www.alt-web.com



"King Evil" <webforumsuser (AT) macromedia (DOT) com> wrote in message
news:g91pk8$qon$1 (AT) forums (DOT) macromedia.com...
ok. i'm hosting with go daddy and i know they allow some type of sql
database. so what would the easiest way to get excel info into a dynamic
page?

"Murray *ACE*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote

Export to CSV. Import to MySQL.

another option would be to get Navicat and use its import features to just
import the Excel file.

Or PHPMyAdmin, yes.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Hunter Elliott" <nospam (AT) gatewaycity (DOT) com> wrote

"Murray *ACE*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote in message
news:g91rmr$aj$1 (AT) forums (DOT) macromedia.com...
Export to CSV. Import to MySQL.


another option would be to get Navicat and use its import features to just
import the Excel file.