SQL is a separate language, specifically the language to manipulate information stored in a relational database. You can use a PHP library like PEAR DB, PDO, or ADOdb to abstract out a good amount of SQL coding you'd otherwise have to do with other hooks, but you should still understand some basic SQL (and the syntax associated with the specific database management system
) in order to perform queries that can't be covered by your typical create, retrieve, update and delete operations. Also, some clarifications on previous points raised in the thread. Transact is an SQL syntax specific to Microsoft's SQL Server. A number of commercial and a few open source DB's offer a procedural extension to their SQL implementations. However, you'll first want to tell us out what you're using. Also, it sounds like you're going to build an application over an existing schema (the layout of data and its relations). You'll want to figure out exactly how that schema looks (or at least the part relevant to your task) before moving forward. That said, if you want to develop quickly with the shallowest learning, follow Pangloss' suggestion and use Visual Web Developer. For one, you won't have worry too much about injection. You shouldn't have to anyway, and you definitely don't need to read a couple of articles to get the idea that you should escape any strings derived from user input before doing any mutating operations.