mysql ?

[Terry A. Haimann]

I realize this has been probably covered. But I want to pull data from one
of several mysql tables, depending on what choice is made from a select
box. Is javascript a good choice?

I have poked around on the internet looking for answers as how to do this
and I have found the following connect statement:

database.connect("INFORMIX", "blue", "MANAGER", "invantory)

Unfortunatly, the documantation I have found indicates that MySQL isn't a
choice for database type(You've got to be kidding.) So, it now appears
that you must use a odbc driver to make the connection. This doesn't seem
like a good method for a common browser(w/o the correct odbc driver) to
look at my page.

I have also seen that some web designers have used php to pull the data
from mysql and then hand it off to javascript(I don't understand how this
works.) It seems probable though that inorder for my page to work using
this option, I would have to pull all of my tables before displaying the
web page.

I would like to see a frank discussion of the pros and cons of each
method, or a sugestion of a better method.


Thx in advance, Terry

 

[Janwillem Borleffs]

I realize this has been probably covered. But I want to pull data from one
of several mysql tables, depending on what choice is made from a select
box. Is javascript a good choice?

Since you probably want to apply it client-side, the answer is no.

Server-side, you could an ASP/ODBC solution or, better yet, a language like
PHP.

When you are formiliair with the JavaScript language syntax, PHP won't be
hard to learn and it is almost designed to be used with MySQL.

See http://www.php.net/ and http://www.php.net/mysql for more info.


JW

 

[Terry A. Haimann]

The problem I see with php is, I want to take the data from the select and
put it in a combobox(drop down box.) I don't think php can do that by
itself, so at best it is going to be a combination between javascript and
php. And as I mentioned earlier, I am not sure how you move data from php
to javascript.

Terry

 

[Jim Ley]

I realize this has been probably covered.

I would like to see a frank discussion of the pros and cons of each
method, or a sugestion of a better method.

I suggest you do at least a little of your own research, rather than
expecting others to do it for you. If ou think it's "probably been
covered" read google groups to see what that coverage entailed.

Jim.