check credits funktion og saet status viker ikke
Jeg har foelgende script:/** get url id **/
//$id = isset($_GET['id']) ? $_GET['id'] : '';
$result = mysql_query ("SELECT * FROM links LIMIT $num_displayed");
while ($row = mysql_fetch_array($result))
$id = $row["linkid"];
//get campain
//Get campain name
$result = mysql_query ("SELECT * FROM links Where linkid='$id'");
while ($row = mysql_fetch_array($result))
$campain = ($row["campain"]);
//Get awaible credits
$result = mysql_query ("SELECT * FROM campains Where campain='".$campain."'");
while ($row = mysql_fetch_array($result))
$credits = ($row["credits"]);
// check credits and set status
$limited = '4';
if ($credits > $limited){
mysql_query("UPDATE links SET status = '1' WHERE campain ='".$campain."'");
}
elseif ($credits < $limited){
mysql_query("UPDATE links SET status = '0' WHERE campain ='".$campain."'");
}
//list links
$result = mysql_query ("SELECT * FROM links WHERE status ='1' LIMIT $num_displayed");
while ($row = mysql_fetch_array($result))
echo '<center><font size="3">| <a href="java script:Popup(\'http://www.awc24h.com/test/newsys/Model/click.php?id='.$row["linkid"].'\')">Click me-'.$row["linkid"].'</a> |</font></center>';
mysql_close($con);
Den opdaterer ikke rigtigt hvis jeg bytter 1 og 0 rundt vil den gerne vise links der har mindre credits end $limited men vil ikke saette dem der har stoerre til status 1
Det er som om den kun tjekker det sidste link i databasen