Hello Bretticus,
Yes, the nightmare still haunts me!
Now the browser keeps timing out and Apache isn't writing to the error or transfer logs for this virtualhost, so I don't know how to check what URL it's trying to direct to. Is it held in an environment variable that I could access somehow? I know the rewrites are doing something, because when I change them and restart Apache I get different browser errors (like illegal path and cannot locate host errors).
I tried hard-coding the url by just inserting the userid directly into the search pattern (see below), and it still doesn't work. The browser times out.
This is what I have at the end of my config file now:
NameVirtualHost *
<VirtualHost *>
ServerAdmin admin@mysite.com
DocumentRoot "C:\apache\www"
ServerName www.mysite.com
ServerAlias mysite.com
<Directory "C:\apache\www">
AllowOverride None
Order allow,deny
Allow from all
</Directory>
</VirtualHost>
<VirtualHost *>
ServerAdmin admin@mysite.com
DocumentRoot "C:\apache\www\users"
ServerName users.mysite.com
ErrorLog "C:\apache\www\users\errors.log"
TransferLog "C:\apache\www\users\transfers.log"
<Directory "C:\apache\www\users">
RewriteEngine on
#RewriteBase /
#RewriteRule /[0-9]+ /showuser.php?userid=$1 [R]
#RewriteRule $/34 /showuser.php?userid=34 [R]
RewriteRule /34 /showuser.php?userid=34 [R]
</Directory>
</VirtualHost>