This tutorial will show you how to make a script to see who has seen your AOL Instant Messenger profile. You can see the final code at view.txt

The date and time functions of MySQL are very handy. Let me start this tutorial from a bad example. Assume that you have Timestamp column in the table, which is the most common date/time data storing format. There is one common problem when you print date/time field fetched from the table. You need to format it to a string before outputting so users will see something like 06 December 2002 instead of incovenient 20021206050131. The bad way is to use PHP to format the fetched date/time value. The much better solution is to use MySQL embedded data/time functions.

So what does a join do, anyway? In short, a join command unites some or all of the data from two or more tables into one comprehensive structure. If this capability was not available, then the administrator would be forced to create ever-expanding, all-encompassing tables that would result in the reduction of overall efficiency and speed of data access and manipulation, even eventually possibly causing the database structure to fail entirely. The joining capability allows the administrator to create small, compact relational tables that can greatly influence database performance. This is especially useful among larger organizations, given the fact that they have the opportunity to divide their database into several departmental sections, allowing each department to effectively manage their relevant data. The alternative to this would be to force one administrator to manage all departmental sections, something that probably does not bode well both in terms of overall organization and efficiency.

So you need to capture time spent for SQL queries ? That's not really simple but also it is not hard. Let's figure out what are the requirements we have ? We need to show overall time spent for executing PHP code and the time spent for executing SQL queries. Also it will be great if we show percents of overall time spent for MySQL only. We need to calculate overall time also ! So in your script you should capture end and start times just as we did it in the function code. Below is the typical script, that uses this method. It will not work until you set real database connection and real SQL queries for your particular task

First of all, this tutorial is based on MySQL, available at http://www.mysql.com/. It's free for Unix based systems, but Windows users can get the shareware copy. You are asked to pay if you use the windows version.Anyway, I am assuming it is already installed on your server (ask your host why the heck they don't got it on the server if it isn't installed... geez, its free

OK, so you know how to get your data out of a database and display it. But, it looks rather dull in a single column down the screen doesn't it? Today you will learn how to put that data into multiple columns. We will do this two different ways. The first we will display the data moving horizontally across the screen.

Simple PHP MySQL Tutorial with examples like creating a guestbook, contact form, uploading files to database, creating a simple Content Management System (CMS), etc.

The method of doing this is, in fact, very simple. When you display your data, just make each column heading clickable and have it pass the column name as a value. Then, when you make your query, use that value in the ORDER BY clause and display the data again. You will see in the script that I am about to present to you, that it is good practice to specify a default value for the ORDER BY in case nothing has been chosen yet. I also add some error checking to make sure that the value for the ORDER BY clause is an acceptable value and won't cause the query to fail. This is accomplished by placing all acceptable values in an array and checking the passed in value against that.

Got a MySQL database with content within it? Want to be able to search it? Read on...Pre-requisites: PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution. Numerous edits must take place upon this script before it is a usable solution.

Learn how to output any database table into the HTML page regardless of how many columns and rows the table contains. Consider MySQL database with a table in it.