// PHP code snippet. Copyright 2008 Chirag Shah.
// Code to create and execute a SQL query as well as reading the records.

<?php
	$query = "SELECT * FROM table_name"; // Formulate the query
	$results = mysql_query($query) or die(" ". mysql_error()); // Execute the query, get the results
	while ($line = mysql_fetch_array($results, MYSQL_ASSOC)) // Go record by record
	{
		// Do something
	}
?>