Adding to a database of html links

[master_debator]

Hey everyone. I've been racking my brain on how to do this, as I've got no idea. Recently I started something called the "truth train" on myspace as a way to network all of the political and conspiracy myspace pages that I can. I'm doing this to help network and connect all of the political people on myspace. After a few days of the conception of this, I realize that I need to make a way to automate this list. I want to make a form where people can input their friendID (which is a unique identifier of a persons myspace profile) and their myspace name. When they hit the submit button, I'd like for their data to be appended to a database of links, in this format:

<A href="http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile&friendID=XXX ">AAA
</A>

xxx would be the friendID that they entered in the form, and AAA would be there name.

Couple of questions
1) What kind of scripting language would I need to use?
2) What kind of database program should I use?
3) How the hell do I do this?

Thanks everyone.

I realize that this is a really big request.

 

[beaver6813]

Hey.

Well you could do that in most web languages really, you'd have to check but if the data from the form can be sent to an external site then you could do it quite simply in PHP for example and MySQL, i've just searched on google and it came up with this site:

http://www.php-mysql-tutorial.com/

If you have PHPMyAdmin on your web hosting then you can ignore the parts about creating a database and just use PHPMyAdmin to create it

 

[master_debator]

Hey.

Well you could do that in most web languages really, you'd have to check but if the data from the form can be sent to an external site then you could do it quite simply in PHP for example and MySQL, i've just searched on google and it came up with this site:

http://www.php-mysql-tutorial.com/

If you have PHPMyAdmin on your web hosting then you can ignore the parts about creating a database and just use PHPMyAdmin to create it

With the PHPMyAdmin, can this be used to automate the process, as I'm getting a lot of requests to put people on this list.

Thanks

 

[beaver6813]

PHPMyAdmin can let you administrate a database and you could insert users in manually but generally people prefer to write their own database scripts to automate the process

 

[Alex.]

I'd go for scripting it in PHP and MYSQL if I were you, php is pretty simple to learn, as is MYSQL.

I find that a good tutorial site for PHP and MYSQL is http://www.tizag.com, it also tells you how to avoid mysql injection (in your case, injection would be people putting scripts into the friendID field, to harm / corrupt your database).

Good luck

 

[tm]

tizag is great for beginners. Highly recommended you check it out.