PHP Links

[Anon]

I am very new to PHP and I need help understatnding certain things related to links.

I have a list of links on one webpage. I want them to be more organized, so I figured that it should search a database or something. You know how there are certain webpages that have links like:
http://domainname/index.php?id=idname

What kind of script is this and I would I go about it?

[Anon]

Yes,

You write a script that searches database with links.

your table could be something like

1. www.phpbuilder.com
2. www.google.com

etc...

so your url like this www.yourdomain.com/give_me_link.php?id=1 would tell your script to yank link in a table that has id of one. Such link is www.phpbuilder.com.

Your script is like this

$conn=mysql_connect($host, $user, $password);
$sql="select link from links where id=\"$id\"";
$result=mysql_query($sql, $conn);
$res=mysql_fetch_array($result);
mysql_free_result($result);
mysql_close($conn);

Then you just send a location header to the browser...

header("Location: http://$res[link]");

That's it.

Drawback is performance penalty, and unless you are running amazon.com it should be no problem.

Di