Ever wanted to create an unlimited levels menu using PHP and MySQL in Dreamweaver? Things are easier than it sounds if you use the Creative DW Menu Pack developer extension – you just need a database and the extension will do the rest.

Many people tell me they aren’t very fond of scripts, because the install frightens them a bit. And it’s true: creating a database, importing tables, your site’s root path… if you don’t know what you’re doing, this looks pretty complicated.

Most web servers uses MySQL data base to store data for thier websites. Some website with high traffic makes very strong load of MySQL data base servers.

In this tutorial I will give you example configuration to setup cross-server replication in MySQL. The normal replication concept is pretty much explained in the term so I will not focus much on it.

In tis tutorial we will show you some very basic SQL queries for extracting the exact information that we need from our database.

We will continue from our previous tutorial for How to Import Excel XLS file into MySql database into the exact solution of the problem - Converting the file into CSV (Comma Separated Value) and next easily importing into MySql.

Quite often all of us have to get the data from some Excel table and to fill into MySql database. There is not implemented such standard converting features both on MS Excel and MySql server.

In this tutorial I will show you how to use Group By Function in MySql. Group by is very powerful function which can help you to get an result from MySql database in very specific view, format and order.

To be honest this won’t be a tutorial, but a list with useful MySQL commands common used to create, mange and maintain MySQL databases, as well as many PHP and Perl API functions you can use to interface with MySQL.

Recently I used to be in a group that had a task to migrate few servers without downtime, and by mistake made by one of our system administrators one of the servers went live with outdated database.

What is SQL injection? SQL injections are a way to modify your query to the database. MySQL, MSSQL or another is irrelevant.

In this tutorial I will demonstrate how you can quickly create a new MySQL database using the command line interface.

This tutorial will show you how to use MySQL querys to database in your PHP scripts. mysql_query(query, [link_identifier]) mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.

This tutorial will show you how to use MySQL querys to database in your PHP scripts. mysql_query(query, [link_identifier]) mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.

This tutorial will show you how to use MySQL querys to database in your PHP scripts. mysql_query(query, [link_identifier]) mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.

This tutorial will show you how to connect to MySQL database from PHP script. mysql_connect (host, username, password) Returns a MySQL link identifier on success, or FALSE on failure.

This tutorial will show you how to allow remote login to MySQL server for specific user. By default MSQL servers allow connections only from localhost.