Database websites?

"Brian S. Shickle" <bshickle.TakeThisOut@hvc.rr.com> wrote in message
news:vqbYa.104285$852.90811@twister.nyc.rr.com...
 > I know how to make a database in excel.
 > Can I put that database in a web site?
 > If not, what do I need to do that?
 > Also, what do I need from my host for that?

If it's in Excel it won't be a proper database. In some ways databases are
similar with tables, rows, columns etc.

Probably best with mySQL. Most unix-type hosts offer this, not sure about
the Windows ones.

Here's a good tutorial:

<a style='text-decoration: underline;' href="http://www.blazonry.com/scripting/linksdb/index.php" target="_blank">http://www.blazonry.com/scripting/linksdb/index.php</a>
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

Charles Sweeney wrote:

 > Here's a good tutorial:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://www.blazonry.com/scripting/linksdb/index.php</font" target="_blank">http://www.blazonry.com/scripting/linksdb/index.php</font</a>>

It'd be good if the example database was normalised.
The "category" field is a text field instead of there
being a separate table of categories to link to.

As it is I couldn't recommend as good a tutorial that
doesn't introduce the most important concepts of database
design.

IMHO.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Mary Pegg" <nospam.RemoveThis@widetrouser.freeserve.co.uk> wrote in message
news:w0cYa.6600$yl6.1126@newsfep4-winn.server.ntli.net...
 > Charles Sweeney wrote:
 >
  > > Here's a good tutorial:
  > >
<font color=green>  > > <a style='text-decoration: underline;' href="http://www.blazonry.com/scripting/linksdb/index.php</font" target="_blank">http://www.blazonry.com/scripting/linksdb/index.php</font</a>>
 >
 > It'd be good if the example database was normalised.
 > The "category" field is a text field instead of there
 > being a separate table of categories to link to.
 >
 > As it is I couldn't recommend as good a tutorial that
 > doesn't introduce the most important concepts of database
 > design.

Fuck sake Mary it's only a tutorial.

<aside to Iso>
Here's one here for you, it sounds just like you, and may have a pulse.
</aside to Iso>

As per the usual, YOUR recommendation appears to have been omitted on my
newsreader.
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Mary Pegg" <nospam RemoveThis @widetrouser.freeserve.co.uk> wrote in message
news:w0cYa.6600$yl6.1126@newsfep4-winn.server.ntli.net...
 > Charles Sweeney wrote:
 >
  > > Here's a good tutorial:
  > >
<font color=green>  > > <a style='text-decoration: underline;' href="http://www.blazonry.com/scripting/linksdb/index.php</font" target="_blank">http://www.blazonry.com/scripting/linksdb/index.php</font</a>>
 >
 > It'd be good if the example database was normalised.
 > The "category" field is a text field instead of there
 > being a separate table of categories to link to.
 >
 > As it is I couldn't recommend as good a tutorial that
 > doesn't introduce the most important concepts of database
 > design.

If you bothered to read further:

"However, using two tables would probably be the better way of creating this
application. The second table would store all of the category names
seperately with a unique key"

I would recommend that you learn to read.
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Brian S. Shickle" <bshickle RemoveThis @hvc.rr.com> wrote in message
news:vqbYa.104285$852.90811@twister.nyc.rr.com...
 > I know how to make a database in excel.
 > Can I put that database in a web site?
 > If not, what do I need to do that?
 > Also, what do I need from my host for that?
 >

Although I wouldn't suggest it, if you only need to read data and not write,
you can access an XLS file via ADO calls, just like an Access MDB.

Regards,
Brent<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

Brian S. Shickle wrote:
 > I know how to make a database in excel.

To expand on Charles' note: you probably mean (in db terms) you know how to
make a table in excel.

 > Can I put that database in a web site?

You can read excel files with asp and display the data on a web page - there
are many tutorials on the web. Come back if you have specific questions.

 > If not, what do I need to do that?

It's also been suggested (by Annafrancesca) you consider Access. I agree
this would be a much better choice (than excel) in most circumstances.
Further, if the data is to be read only, you can get a lot of mileage from
plain old text files (csv format is good - as exported from Excel)

 > Also, what do I need from my host for that?
 >

In general a dynamic page requires scripting support. The choice of
technology will be dependent on the constraints - or to turn it round: how
you achieve it depends on what is provided by your current host.

Sorry: need to know more.

--
William Tasso - <a style='text-decoration: underline;' href="http://WilliamTasso.com" target="_blank">http://WilliamTasso.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

Charles Sweeney wrote:

 > If you bothered to read further:
 >
 > "However, using two tables would probably be the better way of creating

There's no "probably" about it. The tutee is left with the impression
that doing things like this is okay.

 > this application. The second table would store all of the category names
 > seperately with a unique key"
 >
 > I would recommend that you learn to read.

Whatever.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Mary Pegg" <nospam DeleteThis @widetrouser.freeserve.co.uk> wrote in message
news:DMfYa.6776$yl6.4804@newsfep4-winn.server.ntli.net...

 > There's no "probably" about it. The tutee is left with the impression
 > that doing things like this is okay.

Why don't you write a tutorial then Mary?

You seem to know a lot about it, and you have yet to post a link to one that
you recommend.
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Charles Sweeney" <me.DeleteThis@charlessweeney.com> wrote in message
news:bgriul$rehc7$1@ID-162618.news.uni-berlin.de...
 > "Mary Pegg" <nospam.DeleteThis@widetrouser.freeserve.co.uk> wrote in message
 > news:w0cYa.6600$yl6.1126@newsfep4-winn.server.ntli.net...
  > > Charles Sweeney wrote:
  > >
   > > > Here's a good tutorial:
   > > >
<font color=brown>   > > > <a style='text-decoration: underline;' href="http://www.blazonry.com/scripting/linksdb/index.php</font" target="_blank">http://www.blazonry.com/scripting/linksdb/index.php</font</a>>
  > >
  > > It'd be good if the example database was normalised.
  > > The "category" field is a text field instead of there
  > > being a separate table of categories to link to.
  > >
  > > As it is I couldn't recommend as good a tutorial that
  > > doesn't introduce the most important concepts of database
  > > design.
 >
 > Fuck sake Mary it's only a tutorial.

Double (what Charles said to Mary!
Perhaps she did not read the tutorial proper?
It does in fact acknowledge the points Mary raises and offers a brief
outline of the preferred way to do things but as it further explains, 'It is
a tutorial for beginners' and the author wants to keep it simple.
There are a lot of tutorials out there, possibly some better BUT the one you
pointed to has the advantage of addressing a MySql DB in terms of an Excell
spreadsheet - which is where the OP was comming from

Good recommend Charles!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Bill Logan" <blogan.DeleteThis@clear.net.nz> wrote in message
news:3f316454$1@clear.net.nz...

 > Good recommend Charles!

Thank you Bill.

When I started using PHP and mySQL I used this tutorial and found it to be
very good.
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Mary Pegg" <nospam RemoveThis @widetrouser.freeserve.co.uk> wrote in message
news:DMfYa.6776$yl6.4804@newsfep4-winn.server.ntli.net...
 > Charles Sweeney wrote:
 >
  > > If you bothered to read further:
  > >
  > > "However, using two tables would probably be the better way of creating
 >
 > There's no "probably" about it. The tutee is left with the impression
/\/\/\/\/\/\/\
 > that doing things like this is okay.
 >
In your opinion perhaps?

BTW - English grammar tutorials are at <a style='text-decoration: underline;' href="http://www.englishgrammar101.com/" target="_blank">http://www.englishgrammar101.com/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

On Wed, 6 Aug 2003 23:22:18 +0100, "William Tasso"
<ngx DeleteThis @tbdata.com> wrote:

 >It's also been suggested (by Annafrancesca) you consider Access. I agree
 >this would be a much better choice (than excel) in most circumstances.
 >Further, if the data is to be read only, you can get a lot of mileage from
 >plain old text files (csv format is good - as exported from Excel)

If one register HTML-Kit one get access to Table Designer Pro
<a style='text-decoration: underline;' href="http://www.chami.com/html-kit/pro/tables/" target="_blank">http://www.chami.com/html-kit/pro/tables/</a> which makes it easy to
convert Excel-files to tables.

--
regards
Vidar Grønvold<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites? 

"Brian S. Shickle" <bshickle.RemoveThis@hvc.rr.com> wrote in message news:<vqbYa.104285$852.90811@twister.nyc.rr.com>...
 > I know how to make a database in excel.
 > Can I put that database in a web site?
 > If not, what do I need to do that?
 > Also, what do I need from my host for that?
 >
 > Thanks,
 >
 > Brian
 > IceIsHot.com
 > Web Hosting Comparison

Hi Brian,

I know you got tons of replies, so what I'm going to type may have
already been addressed... but here ya go.

Excel does spreadsheets, not databases. If you want to do a proper
database, on Windows use MS SQL, MSDE, or MS Access (For low volume
sites only). If you use something like Cold Fusion, you can pull from
an Excel Spreadsheet, but I'm not sure if ASP does this. If you use
Linux however, you'll need to learn MySQL or Postgre. I'd suggest
MySQL since it has a great MyODBC program that allows you to connect
from MS Access on a PC. You can then populate your MySQL database
from your Excel spreadsheet. Let me know if you need more info on
this... it's a piece of cake to do.

Hope this helps...

Keegan.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database websites?