mysql

HI

1. can anyone tell me whether asp is compatible with MySQL as a backend?

2. Further can anyone also help provide me user groups for MySQL???

3. Is PHP a better option than ASP?

thanks
Janet

ASP is a server side technology
MySQL is a database

What do you mean by compatible? They are two different things?

But if your question was:
"Can I INSERT, MODIFY, DELETE stuff in MySQL from whitin ASP"
Then the answer is yes

Like I said, ASP is NOT a language, its a SERVER SIDE technology developed by microsoft.

You can code using different language with ASP(don't remember the list...)

You can also create SQL queries.
SQL is a language, a language that talks to databases.

There are different flavors of SQL such as T-SQL for SQL Server
If you use standard SQL then you shouldn't have any problems INSERTing, MODIFying and DELETing records REGARDLESS of the database you use!

As for user groups for MySQL simply go to google.com and type:
"user groups for MySQL"
wait ... and look at the results!


Is PHP better then ASP?
Again, search google.com for that, trust me you'll find MANY articles debating that issue.
The bottom line is code with what your more comfortable cause what clients really care about is the end results and both will get you there!

Hope this helps!
Sincerely

Vlince

I've actually seen an installation instructions to use PHP and Perl inside asp, have i tried it? no, but that seemed like a violation of something so I decided to stray away....pluse when you do stuff like that it tends to break otherthings...

beware of mysql limitations. it's good you're looking at these before hand but if you're going to be needing subqueries, views, stored proceedures you might want to look at some other open source db's. I've seen ways to use stored proceedures and cursors etc in mysql but they seemed not very fun.... but if it's for your own personal use mysql is blazing fast and fantastic for maintanability and documentation.

thanks for a wonderful explaination.