Hi, I have a mysql/php database split into 27 tables, one for each letter and one for numbers (Numbers, A, B, C, etc.).
This makes me have to have all my links in this form:
<!-- m --><a class="postlink" href="http://www.mysite.com/page.php?Letter=I&Info=Incubus">http://www.mysite.com/page.php?Letter=I&Info=Incubus</a><!-- m -->
I would like to be able to make my links like this:
<!-- m --><a class="postlink" href="http://www.mysite.com/page.php?Info=Incubus">http://www.mysite.com/page.php?Info=Incubus</a><!-- m -->
I need to somehow use php to recognize the first letter of the query and then use it to select the table which it is in.
Also, for numbers, if php recognizes the first letter is 0-9, it would need to selct the table: Numbers.
Any help? It would be appreciated, thank you very much.
This makes me have to have all my links in this form:
<!-- m --><a class="postlink" href="http://www.mysite.com/page.php?Letter=I&Info=Incubus">http://www.mysite.com/page.php?Letter=I&Info=Incubus</a><!-- m -->
I would like to be able to make my links like this:
<!-- m --><a class="postlink" href="http://www.mysite.com/page.php?Info=Incubus">http://www.mysite.com/page.php?Info=Incubus</a><!-- m -->
I need to somehow use php to recognize the first letter of the query and then use it to select the table which it is in.
Also, for numbers, if php recognizes the first letter is 0-9, it would need to selct the table: Numbers.
Any help? It would be appreciated, thank you very much.