<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Stormation</title>
	<link>http://www.stormation.info</link>
	<description>Innovation through Creation - Flash &#124; PHP &#124; HTML &#124; XML &#124; CSS &#124; SQL - By Eliott Robson</description>
	<lastBuildDate>Wed, 28 Mar 2012 22:19:58 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
<xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />

	<item>
		<title>Error Reporting in MAMP</title>
		<description><![CDATA[Find your ‘MAMP’ directory in ‘Applications’ Find ‘conf’ and open it up.. Open up php4 or php5 (depending on your enabled version) Line 270 should be something like this: 270 error_reporting = E_ALL Line 277 will be: 277 display_errors = Off Change this to: 277 display_errors = On Restart servers Related posts:Welcome to MAMP


Related posts:<ol><li><a href='http://www.stormation.info/244/' rel='bookmark' title='Welcome to MAMP'>Welcome to MAMP</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/386/</link>
			</item>
	<item>
		<title>SQL – part 36</title>
		<description><![CDATA[Auto Increment Say we had this table: 1 2 3 4 5 6 CREATE TABLE People &#40; ID INT NOT NULL AUTO_INCREMENT, FirstName VARCHAR&#40;255&#41;, LastName VARCHAR&#40;255&#41; NOT NULL, PRIMARY KEY &#40;ID&#41; &#41; We no longer have to populate the ID field as it will automatically increment. Starting at 0 and working up, even deleted fields [...]


Related posts:<ol><li><a href='http://www.stormation.info/377/' rel='bookmark' title='SQL &#8211; part 29'>SQL &#8211; part 29</a></li>
<li><a href='http://www.stormation.info/381/' rel='bookmark' title='SQL &#8211; part 33'>SQL &#8211; part 33</a></li>
<li><a href='http://www.stormation.info/376/' rel='bookmark' title='SQL &#8211; part 28'>SQL &#8211; part 28</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/385/</link>
			</item>
	<item>
		<title>SQL – part 35</title>
		<description><![CDATA[I want to ALTER the world! So, say after we&#8217;ve created a databse we need to edit it slightly, we can use: Add column: 1 ALTER TABLE TABLE ADD COLUMN datatype Delete column: 1 ALTER TABLE TABLE DROP COLUMN COLUMN Change datatype of column: 1 ALTER TABLE TABLE ALTER COLUMN COLUMN datatype Related posts:SQL &#8211; [...]


Related posts:<ol><li><a href='http://www.stormation.info/349/' rel='bookmark' title='SQL &#8211; part 3'>SQL &#8211; part 3</a></li>
<li><a href='http://www.stormation.info/362/' rel='bookmark' title='SQL – part 16'>SQL – part 16</a></li>
<li><a href='http://www.stormation.info/381/' rel='bookmark' title='SQL &#8211; part 33'>SQL &#8211; part 33</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/384/</link>
			</item>
	<item>
		<title>PHP Converting Time Stamps</title>
		<description><![CDATA[YYYY-MM-DD HH:MM:SS ~ Unix Timestamp 1 2 3 4 5 6 7 8 9 10 function convert_datetime&#40;$stamp&#41;&#123; &#160; list&#40;$date, $time&#41; = explode&#40;' ', $stamp&#41;; list&#40;$year, $month, $day&#41; = explode&#40;'-', $date&#41;; list&#40;$hour, $minute, $second&#41; = explode&#40;':', $time&#41;; &#160; $timestamp = mktime&#40;$hour, $minute, $second, $month, $day, $year&#41;; &#160; return $timestamp; &#125; Just stick that in somewhere and [...]


Related posts:<ol><li><a href='http://www.stormation.info/217/' rel='bookmark' title='AS3 number of days in a month'>AS3 number of days in a month</a></li>
<li><a href='http://www.stormation.info/196/' rel='bookmark' title='Php Forum'>Php Forum</a></li>
<li><a href='http://www.stormation.info/37/' rel='bookmark' title='Time'>Time</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/383/</link>
			</item>
	<item>
		<title>SQL – part 34</title>
		<description><![CDATA[DROP THE INDEX 1 ALTER TABLE TABLE_NAME DROP INDEX index_name DROP THE DATABASE 1 DROP DATABASE database_name DROP THE TABLE 1 DROP TABLE TABLE_NAME DROP THE (DATA IN THE) TABLE 1 TRUNCATE TABLE TABLE_NAME Related posts:SQL &#8211; part 3 SQL &#8211; part 2 SQL – part 35


Related posts:<ol><li><a href='http://www.stormation.info/349/' rel='bookmark' title='SQL &#8211; part 3'>SQL &#8211; part 3</a></li>
<li><a href='http://www.stormation.info/348/' rel='bookmark' title='SQL &#8211; part 2'>SQL &#8211; part 2</a></li>
<li><a href='http://www.stormation.info/384/' rel='bookmark' title='SQL – part 35'>SQL – part 35</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/382/</link>
			</item>
	<item>
		<title>SQL &#8211; part 33</title>
		<description><![CDATA[The default values! Whenever we instert data we might need a NOT NULL field, but what if we could just fill it in with blanks or default values? The DEFAULT constraint is used to insert a default value into a column. The default value will be added to all new records, if no other value [...]


Related posts:<ol><li><a href='http://www.stormation.info/377/' rel='bookmark' title='SQL &#8211; part 29'>SQL &#8211; part 29</a></li>
<li><a href='http://www.stormation.info/376/' rel='bookmark' title='SQL &#8211; part 28'>SQL &#8211; part 28</a></li>
<li><a href='http://www.stormation.info/378/' rel='bookmark' title='SQL &#8211; part 30'>SQL &#8211; part 30</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/381/</link>
			</item>
	<item>
		<title>SQL &#8211; part 32</title>
		<description><![CDATA[Check That&#8217;s right, check. We can set limits on things now. Say we want ages bigger than 0 so that they cant fool the system by typing a negative value! 1 2 3 4 5 6 CREATE TABLE People &#40; ID INT NOT NULL, FirstName VARCHAR&#40;255&#41;, Age INT, CHECK &#40;Age&#62;0&#41; &#41; And as usual you [...]


Related posts:<ol><li><a href='http://www.stormation.info/377/' rel='bookmark' title='SQL &#8211; part 29'>SQL &#8211; part 29</a></li>
<li><a href='http://www.stormation.info/381/' rel='bookmark' title='SQL &#8211; part 33'>SQL &#8211; part 33</a></li>
<li><a href='http://www.stormation.info/376/' rel='bookmark' title='SQL &#8211; part 28'>SQL &#8211; part 28</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/380/</link>
			</item>
	<item>
		<title>SQL &#8211; part 31</title>
		<description><![CDATA[FOREIGN KEY A FOREIGN KEY in one table points to a PRIMARY KEY in another table. Lets have a look: People table: ID First Name Last Name Age Country 1 Simon Dangers 23 England 2 Simon Fridge 25 England 3 James Fridge 46 America Orders table: ID Number Person 1 01456 2 2 01457 2 [...]


Related posts:<ol><li><a href='http://www.stormation.info/378/' rel='bookmark' title='SQL &#8211; part 30'>SQL &#8211; part 30</a></li>
<li><a href='http://www.stormation.info/381/' rel='bookmark' title='SQL &#8211; part 33'>SQL &#8211; part 33</a></li>
<li><a href='http://www.stormation.info/377/' rel='bookmark' title='SQL &#8211; part 29'>SQL &#8211; part 29</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/379/</link>
			</item>
	<item>
		<title>SQL &#8211; part 30</title>
		<description><![CDATA[PRIMARY KEY The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain unique values. A primary key column cannot contain NULL values. Each table should have a primary key, and each table can have only ONE primary key. So&#8230; 1 2 3 4 5 6 CREATE TABLE People &#40; [...]


Related posts:<ol><li><a href='http://www.stormation.info/377/' rel='bookmark' title='SQL &#8211; part 29'>SQL &#8211; part 29</a></li>
<li><a href='http://www.stormation.info/352/' rel='bookmark' title='SQL &#8211; part 6'>SQL &#8211; part 6</a></li>
<li><a href='http://www.stormation.info/376/' rel='bookmark' title='SQL &#8211; part 28'>SQL &#8211; part 28</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/378/</link>
			</item>
	<item>
		<title>SQL &#8211; part 29</title>
		<description><![CDATA[UNIQUE The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns. A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it. Note that you can have many UNIQUE constraints per table, but only [...]


Related posts:<ol><li><a href='http://www.stormation.info/378/' rel='bookmark' title='SQL &#8211; part 30'>SQL &#8211; part 30</a></li>
<li><a href='http://www.stormation.info/352/' rel='bookmark' title='SQL &#8211; part 6'>SQL &#8211; part 6</a></li>
<li><a href='http://www.stormation.info/381/' rel='bookmark' title='SQL &#8211; part 33'>SQL &#8211; part 33</a></li>
</ol>]]></description>
		<link>http://www.stormation.info/377/</link>
			</item>
</channel>
</rss>

<!-- Dynamic Page Served (once) in 0.669 seconds -->

