[SOLVED] Program not working...

[Vivid Lust]

Hey, i built an affiliate program that is explained below and it just doesnt work!!

 

This is what happens:

 

There is an Iframe on a site that link to ....

a file that caculated a random number that links to a page using the get function (the intention of this is to have a random affiliate)

Then the file it is taken to displays the image that is found in the database.

 

The problem is that the random bit doesnt work and only displays 1

 

Here are my codes:

 

<IFRAME SRC="http://imgsurf.wsnw.net/random.php" width="350" height="100" marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling="no"></IFRAME>

<?php
$rand = rand(1,2);
header('Location:http://imgsurf.wsnw.net/banner.php?id='.$rand.'');
?>

<?php
#connect to MySQL
$conn = @mysql_connect( "----", "----", "-----" )
or die( "Could not connect" );
#select the specified database
$rs = @mysql_select_db( "votick_banner", $conn )
or die( "Could not select database" );


$query = mysql_query( "SELECT id, image, url FROM banner WHERE id = '{$_GET['id']}'" )
or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo( "<br>" );
echo( "<img src=" );
echo $row['image'];
echo( ">" );
echo $row['url'];
?>

Add the html your self...

 

Any help would be apreciated greatly.

And thanks in advanced.

[Vivid Lust]

I think it seems that the page with the html on remembers what the random number was.

Any ideas on how it forgets this on refresh?

or am i completeley wrong? lol

[darkfreaks]

<?php

$min= "1";
$max="2";

$rand= range($min,$max);

shuffle ($rand);

return $rand;


header('Location:http://imgsurf.wsnw.net/banner.php?id='.urlencode($rand).'');

?>

[papaface]

Remove the @'s

[Vivid Lust]

Thanks its working now.

 

With the codes above how could i run a mysql cuery when the hyperlink is clicked?

 

This is so that i can add the amount of hits to the database

 

Thanks.

[darkfreaks]

look into javascript or meta refresh XD