WAP SITE TOPLIST HELP

[andre3]

i have a ranking toplist site and wapmasters/webmasters can go there and add there sites to the catalog.. and after they register there site, they will be given a referal link to put back on there wap or web site.. i want it to work like this.. each time a user click the referal link on on a particular site .instead they automatically get sent to the index.php main page, i want wen the user clicks the referal link an if the refering site is on the 3rd page thats where the user is to be redirected to.. oh an i store all data in a mysql database an each page consists on 5 site. any help? thanks in advance

 

[Fadion]

Give the referals you site's link with their id, like: www.yousite.com/index.php?referal=10. Then make a query with the referal id and show their page.

[Fadion]

Oh and if u cant think of showing the right page, just to give an idea:

 

<?php
$refID = mysql_real_escape_string($_GET['referal']);
$itemsPerPage = 10;
$pageToShow = ceil($refID/$itemsPerPage) * $itemsPerPage;
$resultsPage = mysql_query("SELECT * FROM table LIMIT $pageToShow, $itemsPerPage");
?>

 

Not tested but it should give the idea.

[andre3]

oh one thing i forgot to mention, i give them this link as the referal link with there id at the end: http://mydomain.com/in.php?sid=1    the in.php page updates the database with one hits! each time a new person clicks there referal link... and the index.php have a list of all the sites, so i was wondering is thats the page i must put the code u gave me on?

[Fadion]

U can use in.php?sid=xx as the referal page, update the views in database and send them to index.php?sid=xx. Or save the sid in a session before redirecting to index.php, its your choice.

[andre3]

ook mate i put the code on in.php but it still dont work :S :-\

[andre3]

any more help?? i cant seem to get that to work properly, thnks in advance  ???