Hi Can someone please advise me on the following: We use FP2002. We are
using host Europe as our hosting company and they include support for MySQL
in the package. I want to create a database at the following URL:
http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select by
price etc and I am not sure how to do this. Is there a idiots guide anywhere
to show me the way, or can someone please advise the best way to implement
this. I can see how to create a dbase at Host Europe - it's actually how I
implement it on my website that is my problem!
TIA
John

This fully described in books/articles for writing web applications with
MySQL as the database. Probably best if you find a developer to do
this for you. Not difficult or hard, but does require developer expertise.

Hope this is useful to you. Let us know.

rms




John Morton wrote:
> Hi Can someone please advise me on the following: We use FP2002. We are
> using host Europe as our hosting company and they include support for MySQL
> in the package. I want to create a database at the following URL:
> http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select by
> price etc and I am not sure how to do this. Is there a idiots guide anywhere
> to show me the way, or can someone please advise the best way to implement
> this. I can see how to create a dbase at Host Europe - it's actually how I
> implement it on my website that is my problem!
> TIA
> John
>
>

Thanks Rob - but I rather wanted to do it myself! I've previously done all
the work so far on our website over the last 4 years and would be a neat
'new' addition, just being a bit lazy I suppose and hoping for a few
pointers - a bit of a fast track......
I do have several books - maybe time to read up hey?
Best
John




"Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
news:(E-Mail Removed)...
> This fully described in books/articles for writing web applications with
> MySQL as the database. Probably best if you find a developer to do
> this for you. Not difficult or hard, but does require developer
expertise.
>
> Hope this is useful to you. Let us know.
>
> rms
>
>
>
>
> John Morton wrote:
> > Hi Can someone please advise me on the following: We use FP2002. We are
> > using host Europe as our hosting company and they include support for
MySQL
> > in the package. I want to create a database at the following URL:
> > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select
by
> > price etc and I am not sure how to do this. Is there a idiots guide
anywhere
> > to show me the way, or can someone please advise the best way to
implement
> > this. I can see how to create a dbase at Host Europe - it's actually how
I
> > implement it on my website that is my problem!
> > TIA
> > John
> >
> >

John,

I'm trying to learn the same thing as well. Books are good and I sorta understand the process...except I'm having trouble getting off first base. My server has MySQL all I have to do is push a button online to install it...and then duh...?

Rob



"John Morton" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Thanks Rob - but I rather wanted to do it myself! I've previously done all
| the work so far on our website over the last 4 years and would be a neat
| 'new' addition, just being a bit lazy I suppose and hoping for a few
| pointers - a bit of a fast track......
| I do have several books - maybe time to read up hey?
| Best
| John
|
|
|
|
| "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
| news:(E-Mail Removed)...
| > This fully described in books/articles for writing web applications with
| > MySQL as the database. Probably best if you find a developer to do
| > this for you. Not difficult or hard, but does require developer
| expertise.
| >
| > Hope this is useful to you. Let us know.
| >
| > rms
| >
| >
| >
| >
| > John Morton wrote:
| > > Hi Can someone please advise me on the following: We use FP2002. We are
| > > using host Europe as our hosting company and they include support for
| MySQL
| > > in the package. I want to create a database at the following URL:
| > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to select
| by
| > > price etc and I am not sure how to do this. Is there a idiots guide
| anywhere
| > > to show me the way, or can someone please advise the best way to
| implement
| > > this. I can see how to create a dbase at Host Europe - it's actually how
| I
| > > implement it on my website that is my problem!
| > > TIA
| > > John
| > >
| > >
|
|

Rob, Maybe I'll post a question to Host Europe? Surely someone on this
webboard has had experience in setting something like this up? Actually my
requirements are quite simple I think. lets hope we see some advise
appearing from one of the FP experts :-)
John
---------------------------------------
"Crash Gordon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
John,

I'm trying to learn the same thing as well. Books are good and I sorta
understand the process...except I'm having trouble getting off first base.
My server has MySQL all I have to do is push a button online to install
it...and then duh...?

Rob



"John Morton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Thanks Rob - but I rather wanted to do it myself! I've previously done all
| the work so far on our website over the last 4 years and would be a neat
| 'new' addition, just being a bit lazy I suppose and hoping for a few
| pointers - a bit of a fast track......
| I do have several books - maybe time to read up hey?
| Best
| John
|
|
|
|
| "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
| news:(E-Mail Removed)...
| > This fully described in books/articles for writing web applications with
| > MySQL as the database. Probably best if you find a developer to do
| > this for you. Not difficult or hard, but does require developer
| expertise.
| >
| > Hope this is useful to you. Let us know.
| >
| > rms
| >
| >
| >
| >
| > John Morton wrote:
| > > Hi Can someone please advise me on the following: We use FP2002. We
are
| > > using host Europe as our hosting company and they include support for
| MySQL
| > > in the package. I want to create a database at the following URL:
| > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
select
| by
| > > price etc and I am not sure how to do this. Is there a idiots guide
| anywhere
| > > to show me the way, or can someone please advise the best way to
| implement
| > > this. I can see how to create a dbase at Host Europe - it's actually
how
| I
| > > implement it on my website that is my problem!
| > > TIA
| > > John
| > >
| > >
|
|

fastest and best learning for me in the past was to search for an app that
was already made and customize it.
HTH

--
The email address on this posting is a "black hole". I got tired of all the
spam.
Please feel free to contact me here:
http://nedp.net/contact/
--


"John Morton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks Rob - but I rather wanted to do it myself! I've previously done all
> the work so far on our website over the last 4 years and would be a neat
> 'new' addition, just being a bit lazy I suppose and hoping for a few
> pointers - a bit of a fast track......
> I do have several books - maybe time to read up hey?
> Best
> John
>
>
>
>
> "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
> news:(E-Mail Removed)...
> > This fully described in books/articles for writing web applications with
> > MySQL as the database. Probably best if you find a developer to do
> > this for you. Not difficult or hard, but does require developer
> expertise.
> >
> > Hope this is useful to you. Let us know.
> >
> > rms
> >
> >
> >
> >
> > John Morton wrote:
> > > Hi Can someone please advise me on the following: We use FP2002. We
are
> > > using host Europe as our hosting company and they include support for
> MySQL
> > > in the package. I want to create a database at the following URL:
> > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
select
> by
> > > price etc and I am not sure how to do this. Is there a idiots guide
> anywhere
> > > to show me the way, or can someone please advise the best way to
> implement
> > > this. I can see how to create a dbase at Host Europe - it's actually
how
> I
> > > implement it on my website that is my problem!
> > > TIA
> > > John
> > >
> > >
>
>

Well ... I can't say I know of any magic places you can go to on the
Internet to get the "fast-track" help you are seeking. It's a
"knowledge base" area that takes time, like all important things, to
learn and understand. By all means, take the plunge!

I don't have huge amount of experience with MySQL as a web application,
but if I wanted to get something going quickly, easily, and with
greatest help ... I'd be looking to using PHP as the programming
langauge (on the server) to interact with MySQL. Still develop the web
site with FP, but PHP would be the language interacting with the
database and sending HTML to client.

You don't mention if PHP available at your ISP (probably is). If not
check what server-side programming is available, e.g. Perl, etc.

MySQL is basically no different than any other database server of it's
type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
specific features, advantages, disadvantages, costs, etc. but for your
purposes they are basically the same. So the issue is not the db side,
but the programming language you use to access the db.

I would suggest you look for a book (or web sites) on PHP and MySQL. I
know there are a number of them available in the bookshops, e.g.
http://www.amazon.co.uk/exec/obidos/...900771-4293267

You can surely also easily find PHP programming resources on-line.


Hope this is useful to you. Let us know.

rms




John Morton wrote:
> Rob, Maybe I'll post a question to Host Europe? Surely someone on this
> webboard has had experience in setting something like this up? Actually my
> requirements are quite simple I think. lets hope we see some advise
> appearing from one of the FP experts :-)
> John
> ---------------------------------------
> "Crash Gordon" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> John,
>
> I'm trying to learn the same thing as well. Books are good and I sorta
> understand the process...except I'm having trouble getting off first base.
> My server has MySQL all I have to do is push a button online to install
> it...and then duh...?
>
> Rob
>
>
>
> "John Morton" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | Thanks Rob - but I rather wanted to do it myself! I've previously done all
> | the work so far on our website over the last 4 years and would be a neat
> | 'new' addition, just being a bit lazy I suppose and hoping for a few
> | pointers - a bit of a fast track......
> | I do have several books - maybe time to read up hey?
> | Best
> | John
> |
> |
> |
> |
> | "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
> | news:(E-Mail Removed)...
> | > This fully described in books/articles for writing web applications with
> | > MySQL as the database. Probably best if you find a developer to do
> | > this for you. Not difficult or hard, but does require developer
> | expertise.
> | >
> | > Hope this is useful to you. Let us know.
> | >
> | > rms
> | >
> | >
> | >
> | >
> | > John Morton wrote:
> | > > Hi Can someone please advise me on the following: We use FP2002. We
> are
> | > > using host Europe as our hosting company and they include support for
> | MySQL
> | > > in the package. I want to create a database at the following URL:
> | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
> select
> | by
> | > > price etc and I am not sure how to do this. Is there a idiots guide
> | anywhere
> | > > to show me the way, or can someone please advise the best way to
> | implement
> | > > this. I can see how to create a dbase at Host Europe - it's actually
> how
> | I
> | > > implement it on my website that is my problem!
> | > > TIA
> | > > John
> | > >
> | > >
> |
> |
>
>

Thanks Rob for your help - very useful indeed....

Yep - Host Europe do support PHP as the programming language, so think I had
better dive in and make a start. Actually I run MS SBS with SQL server 2000
installed but this is not supported by Host Europe - hence my initial
queries. I have now downloaded MySQL and installed locally, so I'll now
download the utility they suggest "phpMyAdmin" and have a go!!
Once again thanks
Best
John
------------------------------------------------
"Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
news:(E-Mail Removed)...
> Well ... I can't say I know of any magic places you can go to on the
> Internet to get the "fast-track" help you are seeking. It's a
> "knowledge base" area that takes time, like all important things, to
> learn and understand. By all means, take the plunge!
>
> I don't have huge amount of experience with MySQL as a web application,
> but if I wanted to get something going quickly, easily, and with
> greatest help ... I'd be looking to using PHP as the programming
> langauge (on the server) to interact with MySQL. Still develop the web
> site with FP, but PHP would be the language interacting with the
> database and sending HTML to client.
>
> You don't mention if PHP available at your ISP (probably is). If not
> check what server-side programming is available, e.g. Perl, etc.
>
> MySQL is basically no different than any other database server of it's
> type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
> specific features, advantages, disadvantages, costs, etc. but for your
> purposes they are basically the same. So the issue is not the db side,
> but the programming language you use to access the db.
>
> I would suggest you look for a book (or web sites) on PHP and MySQL. I
> know there are a number of them available in the bookshops, e.g.
> http://www.amazon.co.uk/exec/obidos/...900771-4293267
>
> You can surely also easily find PHP programming resources on-line.
>
>
> Hope this is useful to you. Let us know.
>
> rms
>
>
>
>
> John Morton wrote:
> > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
> > webboard has had experience in setting something like this up? Actually
my
> > requirements are quite simple I think. lets hope we see some advise
> > appearing from one of the FP experts :-)
> > John
> > ---------------------------------------
> > "Crash Gordon" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > John,
> >
> > I'm trying to learn the same thing as well. Books are good and I sorta
> > understand the process...except I'm having trouble getting off first
base.
> > My server has MySQL all I have to do is push a button online to install
> > it...and then duh...?
> >
> > Rob
> >
> >
> >
> > "John Morton" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > | Thanks Rob - but I rather wanted to do it myself! I've previously done
all
> > | the work so far on our website over the last 4 years and would be a
neat
> > | 'new' addition, just being a bit lazy I suppose and hoping for a few
> > | pointers - a bit of a fast track......
> > | I do have several books - maybe time to read up hey?
> > | Best
> > | John
> > |
> > |
> > |
> > |
> > | "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in
message
> > | news:(E-Mail Removed)...
> > | > This fully described in books/articles for writing web applications
with
> > | > MySQL as the database. Probably best if you find a developer to
do
> > | > this for you. Not difficult or hard, but does require developer
> > | expertise.
> > | >
> > | > Hope this is useful to you. Let us know.
> > | >
> > | > rms
> > | >
> > | >
> > | >
> > | >
> > | > John Morton wrote:
> > | > > Hi Can someone please advise me on the following: We use FP2002.
We
> > are
> > | > > using host Europe as our hosting company and they include support
for
> > | MySQL
> > | > > in the package. I want to create a database at the following URL:
> > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
> > select
> > | by
> > | > > price etc and I am not sure how to do this. Is there a idiots
guide
> > | anywhere
> > | > > to show me the way, or can someone please advise the best way to
> > | implement
> > | > > this. I can see how to create a dbase at Host Europe - it's
actually
> > how
> > | I
> > | > > implement it on my website that is my problem!
> > | > > TIA
> > | > > John
> > | > >
> > | > >
> > |
> > |
> >
> >

Those are my thoughts as well...FP, MySQL, PHP.

Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.


"Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message news:(E-Mail Removed)...
| Well ... I can't say I know of any magic places you can go to on the
| Internet to get the "fast-track" help you are seeking. It's a
| "knowledge base" area that takes time, like all important things, to
| learn and understand. By all means, take the plunge!
|
| I don't have huge amount of experience with MySQL as a web application,
| but if I wanted to get something going quickly, easily, and with
| greatest help ... I'd be looking to using PHP as the programming
| langauge (on the server) to interact with MySQL. Still develop the web
| site with FP, but PHP would be the language interacting with the
| database and sending HTML to client.
|
| You don't mention if PHP available at your ISP (probably is). If not
| check what server-side programming is available, e.g. Perl, etc.
|
| MySQL is basically no different than any other database server of it's
| type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
| specific features, advantages, disadvantages, costs, etc. but for your
| purposes they are basically the same. So the issue is not the db side,
| but the programming language you use to access the db.
|
| I would suggest you look for a book (or web sites) on PHP and MySQL. I
| know there are a number of them available in the bookshops, e.g.
| http://www.amazon.co.uk/exec/obidos/...900771-4293267
|
| You can surely also easily find PHP programming resources on-line.
|
|
| Hope this is useful to you. Let us know.
|
| rms
|
|
|
|
| John Morton wrote:
| > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
| > webboard has had experience in setting something like this up? Actually my
| > requirements are quite simple I think. lets hope we see some advise
| > appearing from one of the FP experts :-)
| > John
| > ---------------------------------------
| > "Crash Gordon" <(E-Mail Removed)> wrote in message
| > news:(E-Mail Removed)...
| > John,
| >
| > I'm trying to learn the same thing as well. Books are good and I sorta
| > understand the process...except I'm having trouble getting off first base.
| > My server has MySQL all I have to do is push a button online to install
| > it...and then duh...?
| >
| > Rob
| >
| >
| >
| > "John Morton" <(E-Mail Removed)> wrote in message
| > news:(E-Mail Removed)...
| > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
| > | the work so far on our website over the last 4 years and would be a neat
| > | 'new' addition, just being a bit lazy I suppose and hoping for a few
| > | pointers - a bit of a fast track......
| > | I do have several books - maybe time to read up hey?
| > | Best
| > | John
| > |
| > |
| > |
| > |
| > | "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
| > | news:(E-Mail Removed)...
| > | > This fully described in books/articles for writing web applications with
| > | > MySQL as the database. Probably best if you find a developer to do
| > | > this for you. Not difficult or hard, but does require developer
| > | expertise.
| > | >
| > | > Hope this is useful to you. Let us know.
| > | >
| > | > rms
| > | >
| > | >
| > | >
| > | >
| > | > John Morton wrote:
| > | > > Hi Can someone please advise me on the following: We use FP2002. We
| > are
| > | > > using host Europe as our hosting company and they include support for
| > | MySQL
| > | > > in the package. I want to create a database at the following URL:
| > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
| > select
| > | by
| > | > > price etc and I am not sure how to do this. Is there a idiots guide
| > | anywhere
| > | > > to show me the way, or can someone please advise the best way to
| > | implement
| > | > > this. I can see how to create a dbase at Host Europe - it's actually
| > how
| > | I
| > | > > implement it on my website that is my problem!
| > | > > TIA
| > | > > John
| > | > >
| > | > >
| > |
| > |
| >
| >

Put this PHP program into a file (call it phpinfo.php) on the server,
make it executable by owner and group (not all) and then load it in web
browser and see it it runs:

===========
<html>
<head>
<title>PHP Info</title>
(/head>
<body>
<?php
phpinfo();
?>
</body
</html>
============

*IF* they have PHP, and *IF* PHP files recognised by web server as a CGI
executable program, it should call the phpinfo() function and display
info about the setup of PHP they have on the server.

This sort of thing discussed in early pages of most books about PHP.

Hope this is useful to you. Let us know.

rms




Crash Gordon wrote:
> Those are my thoughts as well...FP, MySQL, PHP.
>
> Current problem is my ISP won't answer my question whether they support PHP or not, I know they support MySQL. I wonder if there is a way to test for PHP?? (newbie question here) - I'm tired of waiting for an answer from them.
>
>
> "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message news:(E-Mail Removed)...
> | Well ... I can't say I know of any magic places you can go to on the
> | Internet to get the "fast-track" help you are seeking. It's a
> | "knowledge base" area that takes time, like all important things, to
> | learn and understand. By all means, take the plunge!
> |
> | I don't have huge amount of experience with MySQL as a web application,
> | but if I wanted to get something going quickly, easily, and with
> | greatest help ... I'd be looking to using PHP as the programming
> | langauge (on the server) to interact with MySQL. Still develop the web
> | site with FP, but PHP would be the language interacting with the
> | database and sending HTML to client.
> |
> | You don't mention if PHP available at your ISP (probably is). If not
> | check what server-side programming is available, e.g. Perl, etc.
> |
> | MySQL is basically no different than any other database server of it's
> | type, e.g. Microsoft SQL, Oracle, PostgreSQL, etc. Each has different
> | specific features, advantages, disadvantages, costs, etc. but for your
> | purposes they are basically the same. So the issue is not the db side,
> | but the programming language you use to access the db.
> |
> | I would suggest you look for a book (or web sites) on PHP and MySQL. I
> | know there are a number of them available in the bookshops, e.g.
> | http://www.amazon.co.uk/exec/obidos/...900771-4293267
> |
> | You can surely also easily find PHP programming resources on-line.
> |
> |
> | Hope this is useful to you. Let us know.
> |
> | rms
> |
> |
> |
> |
> | John Morton wrote:
> | > Rob, Maybe I'll post a question to Host Europe? Surely someone on this
> | > webboard has had experience in setting something like this up? Actually my
> | > requirements are quite simple I think. lets hope we see some advise
> | > appearing from one of the FP experts :-)
> | > John
> | > ---------------------------------------
> | > "Crash Gordon" <(E-Mail Removed)> wrote in message
> | > news:(E-Mail Removed)...
> | > John,
> | >
> | > I'm trying to learn the same thing as well. Books are good and I sorta
> | > understand the process...except I'm having trouble getting off first base.
> | > My server has MySQL all I have to do is push a button online to install
> | > it...and then duh...?
> | >
> | > Rob
> | >
> | >
> | >
> | > "John Morton" <(E-Mail Removed)> wrote in message
> | > news:(E-Mail Removed)...
> | > | Thanks Rob - but I rather wanted to do it myself! I've previously done all
> | > | the work so far on our website over the last 4 years and would be a neat
> | > | 'new' addition, just being a bit lazy I suppose and hoping for a few
> | > | pointers - a bit of a fast track......
> | > | I do have several books - maybe time to read up hey?
> | > | Best
> | > | John
> | > |
> | > |
> | > |
> | > |
> | > | "Rob Schneider" <rmschne@removetheones_b1e1e1b.net.net> wrote in message
> | > | news:(E-Mail Removed)...
> | > | > This fully described in books/articles for writing web applications with
> | > | > MySQL as the database. Probably best if you find a developer to do
> | > | > this for you. Not difficult or hard, but does require developer
> | > | expertise.
> | > | >
> | > | > Hope this is useful to you. Let us know.
> | > | >
> | > | > rms
> | > | >
> | > | >
> | > | >
> | > | >
> | > | > John Morton wrote:
> | > | > > Hi Can someone please advise me on the following: We use FP2002. We
> | > are
> | > | > > using host Europe as our hosting company and they include support for
> | > | MySQL
> | > | > > in the package. I want to create a database at the following URL:
> | > | > > http://www.jcm-polo.com/ponies_for_sale.htm to enable visitors to
> | > select
> | > | by
> | > | > > price etc and I am not sure how to do this. Is there a idiots guide
> | > | anywhere
> | > | > > to show me the way, or can someone please advise the best way to
> | > | implement
> | > | > > this. I can see how to create a dbase at Host Europe - it's actually
> | > how
> | > | I
> | > | > > implement it on my website that is my problem!
> | > | > > TIA
> | > | > > John
> | > | > >
> | > | > >
> | > |
> | > |
> | >
> | >