Home > Archive > PHP SQL > November 2004 > What app for sales staff to read data from MySQL?
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 |
What app for sales staff to read data from MySQL?
|
|
| Gary Hasler 2004-11-01, 8:56 pm |
| I'm setting up a PHP script to generate real-time on-line quotes for log
home packages. I intend to set it up so the script also forwards a copy
of the quote via email to our sales staff, and also writes a record into
a MySQL database. What would be the easiest way for the sales staff to
be able to view this database? They would not need to write or delete
any records, just sort them by, say, how many people from Florida asked
for a certain plan during July. They currently have MS Excel and are
comfortable with it; would Excel work? I think MS Access could do it
but it seems like overkill; plus I think Microsoft has enough of our
money already. Are there other stand-alone programs to consider?
| |
| David Quinton 2004-11-02, 3:56 am |
| On Mon, 01 Nov 2004 20:48:48 GMT, Gary Hasler <garyhasler@telus.net>
wrote:
>I'm setting up a PHP script to generate real-time on-line quotes for log
>home packages. I intend to set it up so the script also forwards a copy
>of the quote via email to our sales staff, and also writes a record into
>a MySQL database. What would be the easiest way for the sales staff to
>be able to view this database?
Is the PC that has the database permanantly connected to the internet?
Does/can it run a webserver?
--
FREE phonecalls with other TalkTalk customers: <http://www.bizorg.co.uk/shopping/talktalk/>
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
| |
| Newsgroup Poster 2004-11-02, 3:56 pm |
| just install mysql-odbc win32 client and use excel / ms access to get =
the data / modify
"Gary Hasler" <garyhasler@telus.net> wrote in message =
news:4186A130.ACD57285@telus.net...
> I'm setting up a PHP script to generate real-time on-line quotes for =
log
> home packages. I intend to set it up so the script also forwards a =
copy
> of the quote via email to our sales staff, and also writes a record =
into
> a MySQL database. What would be the easiest way for the sales staff =
to
> be able to view this database? They would not need to write or delete
> any records, just sort them by, say, how many people from Florida =
asked
> for a certain plan during July. They currently have MS Excel and are
> comfortable with it; would Excel work? I think MS Access could do it
> but it seems like overkill; plus I think Microsoft has enough of our
> money already. Are there other stand-alone programs to consider?
>
| |
| Gary Hasler 2004-11-02, 3:56 pm |
| Yeah, sorry should have clarified--our web site and the SQL database are on a remote server
(sure.com). I know it's a Linux system running Apache, PHP, and MySQL. I'll ask them if
odbc is installed.
The Excel "help" file mentions accessing a few databases thru ODBC including (of course) MS
SQL Server, but from what you say it sounds like it can access MySQL too?.
------------
Newsgroup Poster wrote:
[color=darkred]
> just install mysql-odbc win32 client and use excel / ms access to get the data / modify
>
> "Gary Hasler" <garyhasler@telus.net> wrote in message news:4186A130.ACD57285@telus.net...
| |
| Hilarion 2004-11-02, 3:56 pm |
| > The Excel "help" file mentions accessing a few databases thru ODBC including (of course) MS
> SQL Server, but from what you say it sounds like it can access MySQL too?.
It can access ALL ODBC sources like almost all ODBC enabled apps.
Hilarion
| |
| marcus@myrealbox.com 2004-11-02, 8:55 pm |
|
On Mon, 01 Nov 2004 20:48:48 GMT, Gary Hasler <garyhasler@telus.net> wrote:
>I'm setting up a PHP script to generate real-time on-line quotes for log
>home packages. I intend to set it up so the script also forwards a copy
>of the quote via email to our sales staff, and also writes a record into
>a MySQL database. What would be the easiest way for the sales staff to
>be able to view this database?
Well, it sounds like you are creating the quote as a file. So, why not give the
file a unique name, use this filename when sending the quote to the client and
keep a copy on the server. Also, write the name of the file into the client
record.
Now, when a sales person comes along, they can presumably see the customer
information records and by clicking on a link will be able to see quot0001.txt,
quot0002.txt etc
regards
Marcus
| |
| Newsgroup Poster 2004-11-03, 8:55 am |
| No you install mysql-odbc win32 client on your sales staff pc's =
(http://www.gsp.com/support/virtual/mysql/odbc/)=20
"Gary Hasler" <garyhasler@telus.net> wrote in message =
news:4187C27B.685B08C1@telus.net...
> Yeah, sorry should have clarified--our web site and the SQL database =
are on a remote server
> (sure.com). I know it's a Linux system running Apache, PHP, and =
MySQL. I'll ask them if
> odbc is installed.
>=20
> The Excel "help" file mentions accessing a few databases thru ODBC =
including (of course) MS
> SQL Server, but from what you say it sounds like it can access MySQL =
too?.
> ------------
| |
| Gary Hasler 2004-11-03, 3:56 pm |
| Okay, I think I get it...Excel comes with an optional "add-in" called "ODBC Add-in", but it cautions that 3rd party
drivers may be necessary for Excel to access some DBs. So mysql-odbc would be the 3rd party driver.
-------------
Newsgroup Poster wrote:
[color=darkred]
> No you install mysql-odbc win32 client on your sales staff pc's (http://www.gsp.com/support/virtual/mysql/odbc/)
>
> "Gary Hasler" <garyhasler@telus.net> wrote in message news:4187C27B.685B08C1@telus.net...
| |
| Newsgroup Poster 2004-11-09, 8:55 am |
| Yep mysql-odbc is the 3rd party driver
"Gary Hasler" <garyhasler@telus.net> wrote in message =
news:418910D7.4A06967D@telus.net...
> Okay, I think I get it...Excel comes with an optional "add-in" called =
"ODBC Add-in", but it cautions that 3rd party
> drivers may be necessary for Excel to access some DBs. So mysql-odbc =
would be the 3rd party driver.
> -------------
>=20
> Newsgroup Poster wrote:
>=20
(http://www.gsp.com/support/virtual/mysql/odbc/)[color=darkred]
news:4187C27B.685B08C1@telus.net...[color=darkred]
database are on a remote server[color=darkred]
MySQL. I'll ask them if[color=darkred]
including (of course) MS[color=darkred]
MySQL too?.[color=darkred]
>
|
|
|
|
|