kylegetson 16 Junior Poster in Training

using php base64_encode and php base64_decode can help as well.

never run a query on data you unsure about.

also, its a good idea to restrict the permissions of the mysql user your scripts are using, so in case someone does get in, they can't create, alter or drop tables. require an additional login before allowing those type of queries.

backup early. backup often.

darkagn commented: Great suggestions +3
kylegetson 16 Junior Poster in Training

would it not make more sense to have all this data in 1 table? if your table names are literally differentiated by a number, just add a field to your table structure. So instead of having 62 tables, have 1 table with the following fields:
date, user, url, short_url, TableNumber

Then you can have 1 simple, quick query to get what you need.

kylegetson 16 Junior Poster in Training

its easiest if you have a site worth linking to. give them a reason to link. if your site doesn't offer anything that other people want, you'll be the only one linking to it.
start here: www.webmasterworld.com

canadafred commented: good solid advice +4
kylegetson 16 Junior Poster in Training

Hi,

I am trying to write a .htaccess script that can redirect any URL on my site (whether it exists or not, including sub-domains) to the index page of that site.

For example:
example.com/pages/page.htm ---> example.com
sub.example.com/page.htm ---> example.com
error.example.com/error ---> example.com

I've tried a few things with mod_rewrite but I can't seem to get existing urls, non-existing urls and sub domain urls to all direct to the index page.

Thanks,
Martin

try this:

RewriteEngine On
RewriteCond %{REQUEST_URI} !=/index.php
RewriteRule .* /index.php

try changing index.php to index.html, or whatever the index file is you want to see. i think that will work, though I havnt tested it.