SQL Replace function is similar to the find and replace operation in many text editors that you have used. Learn from this step by step tutorial on how to use the REPLACE function in SQL.
PHP, SQL, and MySQL
This topic will cover everything having to do with PHP, SQL, and MySQL, to help you in all of you web development quests. You’ll be able to find virtually anything you need and should come back often to see what we have added.
What is so special about the SQL dateadd function? For those of you who know how daunting it is to add up dates and time, this function would be a life saver for you. This tutorial explains how the sql dateadd function is used while providing examples for better understanding.
Joins in SQL are used to select data from multiple tables based on a specific relationship. There are 4 SQL join types: Inner, Left, Right and Full. In this tutorial I will explain all of them with simple examples.
In this tutorial, I will explain how you can create, retrieve and delete cookies using PHP. Cookies can be used to store user information like preferences and login information.
PHP includes a lot of built in math functions which you can use in your program. In this tutorial, I will list the most commonly used ones along with their syntax, examples, and descriptions.
Understanding how to extract the data you need from an SQL database can be hard at first. Read on to discover how to filter out unwanted rows from your results so that only the most relevant data remains.