Redirection

[slimjim]

can anyone give me a headstart on redirection.
What I am trying to figure out how to do is this.
Using a mysql table
I want to make a script that where if I go to abc.com, i get forwarded to efg.com or a different url based on weight.
I want a random url based on whats in mysql table and weight so that higher the weight , more often the url will be shown for redirection.

[slimjim]

This is sorta where I am stuck. I am not sure what I am doing wrong.

<?php 

$mydabe = mysql_connect("localhost","user","password"); 
mysql_select_db("databasename",$mydabe); 

$sql = "SELECT * FROM sites WHERE id=$set ORDER BY RAND()"; 
$result = mysql_query($sql,$mydabe);  

$array = mysql_fetch_array($result);  



header("Location: " . $array["burl"]); 

?> 

[PHPdev]

So are you getting some kind of error, or are you just unsure how to handel the weghting issue?

PHPdev

[slimjim]

I havnt tested that code so far, but yes I am very unsure on how to handle the weighting issue

[PHPdev]

I was thining about what you are attempting to do, and there is one falw I came up with. The first random url, will always have a higher weight than all the other urls. Thus it would always be chosen for redirection.

Now a slight addition to your theory could be to select say 5 random urls and then chose the highest weighted from the random 5. The random more urls you chose the less random the redirection will be based on the weight, chose a good number for the total urls you have. You will proabaly have to experiment with this.

Obvioulsy what ever theory you go with, you will need to "UPDATE", the mysql table to increase the weight of the chosen URL.

That should give you a little to think about...

Let me know if there is anything else I can do..

PHPdev

[slimjim]

Good idea !! Makes more sence to me too. I will put together code and try and will post once i get it all figured out.