Help with storing links

[flinginarrows]

I have a site with multiple links that are exactly the same (sorta). Currently I am adding the links to every page, which is getting to be a waste of time. For example:

http://flinginarrows.com/3dshoots/BrowseShoots/listlocalshoots.php?state=al

The only part changing on this link is the state="whatever state".

I created a table that has the link description, the URL and the state.

If the link is universal, such as the one above, I use "all" as the state so every states page will list it.

How do I attach the state at the end of the URL or am I even on the correct path?

Oh yeah and if a link is actually:
mailto:[e-mail]?subject=Alabama
should this be static per each page or in a seperate table or can I also populate the same table with a mailto link?

[ScubaKing22]

I'm not 100% clear on what you're asking, but it sounds like you want to create a link with the "state=whatever" part dynamically created. The following code should work if I understand you correctly:

$result = mysql_query("SELECT*FROM insert_table_here ORDER BY name_of_state_field ASC");
while($row = mysql_fetch_array($result))
{
  echo "<a href=\"http://www.flinginarrows.com/3dshoots/BrowseShoots/listlocalshoots.php?state=".$row['name_of_state_field']."\">".$row['name_of_state_field']."</a>";
}

When it came to al, as in your example, it would produce a link like the following:al

Hope this helps 😉

[flinginarrows]

Actuall, for example, the links I have stored for Alabama are as follows:

A HREF="mailto:[e-mail]?subject=Alabama"

<A HREF="http://www.dcnr.state.al.us/agfd/cwd.html">Stay up to date on Chronic Wasting Disease</A>

<A HREF="http://www.dcnr.state.al.us/agfd/2002-2003_regbook.doc">Regulations</A>

<A HREF="http://www.dcnr.state.al.us/agfd/wma.html">Public hunting areas</A>

....

<A HREF="http://flinginarrows.com/ArcheryShops/BrowseShops/listlocalshops.php?state=al">Local Archery Shops</A>

<A HREF="http://flinginarrows.com/3dshoots/BrowseShoots/listlocalshoots.php?state=al">Local 3D Shoots</A>

As you can see the links are in different formats. What I want is when I click on Alabama the above links are listed in the correct format.

Should I store them in different tables perhaps?

The ones that are just links are easy enough. I can just print all the links that have "al" attached to them. The problem is I want every state to list the other links, but only with the state part different.