PHP and SQL

[BrianArena]

Is it possible to use php to display records from an SQL (not MySQL) database hosted on a separate server? I don't need how-to details at this point, just whether or not it is possible. Thanks

[Newsgroup_User]

"BrianArena" <webforumsuser@macromedia.com> wrote in message
news:fk6s99$88$1@forums.macromedia.com...
> Is it possible to use php to display records from an SQL (not MySQL)
> database hosted on a separate server? I don't need how-to details at this
> point, just whether or not it is possible. Thanks

You mean Microsoft SQL Server? Yes that is possible

[BrianArena]

So is there a difference between Microsoft SQL and (non-Microsoft) SQL. The boss didn't mention "Microsoft" SQL, just SQL.

[Newsgroup_User]

BrianArena wrote:
> So is there a difference between Microsoft SQL and (non-Microsoft) SQL. The boss didn't mention "Microsoft" SQL, just SQL.

Microsoft SQL Server is just one of many database systems that use SQL
(Structured Query Language), the standard language for communication
with a relational database. SQL is a common standard used by MySQL,
PostgreSQL, Access, Oracle, Microsoft SQL Server, and many other
database systems.

Unfortunately, although SQL is a standard, each database system uses its
own dialect. The basic commands are the same, but the finer details
differ according to the database system.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

Joris van Lier wrote:
> You mean Microsoft SQL Server? Yes that is possible

As Joris says, it's possible. PHP supports all major database systems.

However, the code automatically generated by Dreamweaver server
behaviors supports PHP only in combination with MySQL. To support any
other database, you need to hand-code everything.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/