velosipedist

--- Source: http://solaimurugan.blogspot.ru/2010/10/list-out-all-forien-key-constraints.html

SELECT 
  tc.constraint_name,
  tc.constraint_type,
  tc.table_name,
  kcu.column_name,
  tc.is_deferrable,
  tc.initially_deferred,
  rc.match_option AS match_type,

velosipedist

# for example, we are in /www/htdocs/myproject
# but webroot situated in /www/htdocs/myproject/public_html
# let's create /www/htdocs/myproject/.htaccess

RewriteEngine on
RewriteCond %{REQUEST_URI} !public_html/
RewriteRule (.*) public_html/$1 [L]

velosipedist

<?php
// fetch fresh published posts 
$imgPosts = get_posts(array(
	'posts_per_page'  => 10, // max count
	'orderby'         => 'post_modified',
	'order'           => 'DESC',
	'post_type'       => 'post',
	'post_status'     => 'publish' 
));