Pretty confused at this time, as i feel i understand a little about vhosts it has confused me for no finish of your time and that i thought i'll seek help after such a long time :p

I switch off 1 vhost and phpmyadmin works in your area, turn this vhost back on, phpmyadmin eventually ends up only at that web page with my 404 for that site. the vhost under consideration:

<VirtualHost 127.0.0.1>
DocumentRoot /var/www/mayfieldafc/docroot
ServerName mayfieldafc.com
ServerAlias mayfieldafc.local
#CustomLog logs/mayfieldafc-transfer.log combined
#ErrorLog logs/mayfieldafc-error.log

php_value include_path "/usr/share/php:/var/www/mayfieldafc"
php_value error_reporting 2047
php_flag magic_quotes_gpc off
php_flag short_open_tag off

DirectoryIndex index.php index.html

<Directory /var/www/mayfieldafc/docroot>
    Options None
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>

RewriteEngine on
#RewriteLogLevel 9
#RewriteLog /var/log/mod_rewrite.log

# Dispatcher wiring
RewriteCond %{REQUEST_URI} !dispatch\.php$
RewriteCond /var/www/mayfieldafc/docroot%{REQUEST_FILENAME} !-f
RewriteRule ^(/.*)$ /dispatch.php?url=$1 [L,QSA]

</VirtualHost>

<VirtualHost 127.0.0.1>
DocumentRoot /var/www/mayfieldafc/docroot
ServerName assets.mayfieldafc.com
ServerAlias assets-mayfieldafc.local
#CustomLog logs/mayfieldafc-transfer.log combined
#ErrorLog logs/mayfieldafc-error.log

DirectoryIndex index.php index.html

<Directory /var/www/mayfieldafc/docroot>
    Options None
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>
</VirtualHost>

If anybody knows anything about vhosts and phpmyadmin i'd adore you forever :D

Using NameVirtualHost to host multiple sites on a single Ip mandates that you access the VirtualHost at its title and never its Ip. Hence, if phpmyadmin is located on assets-mayfieldafc.local, you must can get on at assets-mayfieldafc.local/phpmyadmin. It really works at localhost when just one virtualhost is set up as there are just one place to choose the localhost IP. Configure more virtualhosts on a single IP, and you will have to access them by ServerName/ServerAlias.