Hi

I am new to PHP and practicing to manage data in database...
Im just want to know about this and hope someone could help me...
* is there stored in mysql as the same with ms sql?
* on php programming, which database back end should I used? why?
* what are the advantage or disadvantage if am I going to use ms sql in php and publish it into live?
* what features in mysql that are not with mssql?


thanks.....

No.
Things like MS-SQL's "@@IDENTITY" do not work in MySQL.
Though (iirc) it is not a completely different language, you will still have to do a little research on the functions.

MySQL.
IIRC, MySQL = Linux, MS-SQL = Microsoft.
MS != PHP
So MySQL is the way to go.

I have NO idea

They are both a databasing system, so I wouldnt imagine there would be too much difference other then coding and system compatibility (server).
I can honestly recommend MySQL, its used by phpBB, vBulletin, e107, SMF, and many more.

Its a great way to database everything, so I recommend it.


Your welcome

for PHP, i suggest you to use mySQL. it's simple and easy to understand. with mySQL, creating database, table, execute sql script more easy than MS-SQL. also, almost of CMS using mySQL for the database backend. so use MySQL.

__________________
reliable website development, Get Celebrities Wallpaper

I use MySQL.

Its been proven that queries to MSSQL results to dead lock during traffic. This simply shows how slow MSSQL handles processes.

Actually MS SQL is very quick with well designed queries and in many cases much quicker than MySQL on larger tables

__________________
And how can we win, when fools can be kings

I wouldn't say so.

We are using both. And we usually get deadlocks during our toxic seasons. Our MySQL seats down silently and calmly.

Right now, we are porting all the MSSQL dependent apps to MySQL.