[Resolved] Links Script || Refresh Page Issue

[klik]

Hi,

I have an admin page which allows links to be activated or deleted.

$mode = $_GET['mode'];

//Begin execution

if ($mode == 'accept'){
	$link_id = $_GET['link_id'];
	$username = mysql_query("SELECT link_member FROM cms_links WHERE link_id = '$link_id'");
	$username = mysql_result($username, 0);

mysql_query("UPDATE cms_links SET link_activated ='1' WHERE link_id= '$link_id'") or die (mysql_error());
echo 'Link Successfully Activated!';
}



if ($mode == 'reject'){
	$link_id = $_GET['link_id'];
	$username = mysql_query("SELECT link_member FROM cms_links WHERE link_id = '$link_id'");
	$username = mysql_result($username, 0);


mysql_query("DELETE FROM cms_links WHERE link_id= '$link_id'");
mysql_query("UPDATE cms_users SET link_added ='0' WHERE username = '$username'") or die (mysql_error());
echo 'Link Successfully Deleted!';
}

Before this section of code, the page dsiplays a list of all unactivated links. When I choose to accept or reject a link, the function does work, but the page doesn't reload. The link i have just Activated/De-Activated should disappear from the page instantly.

Here is the main section of my activation page

$result =   mysql_query("SELECT * FROM cms_links WHERE link_activated = '0'");


echo ' <u><i>Links Awaiting Activation</i></u><br><br> ';
while ($row = mysql_fetch_assoc($result))
{
    echo
    'Link Name : ' . $row['link_name'] . '<br>' .
    'Link Address : ' . $row['link_url'] . '<br>' .
    'Link Description : ' . $row['link_description'] . '<br>' .
    'Number Of Visits : ' . $row['link_click_count'] . '<br>' .
    'Submitted : ' . $row['link_date_added'] . '<br>' .
    'Last Modified : ' . $row['link_last_modified'] . '<br>' .
    'Added By : ' . $row['link_member'] . '<br>' .
    '<a href = "http://localhost/Hip%20Hop%20Reaction/admin/links/link_activation.php?mode=accept&link_id=' . $row['link_id'] . '">Accept</a> || <a href = "http://localhost/Hip%20Hop%20Reaction/admin/links/link_activation.php?mode=reject&link_id=' . $row['link_id'] . '">Reject</a><br><br><br> 
    ';
}


$mode = $_GET['mode'];

//Begin execution

if ($mode == 'accept'){
	$link_id = $_GET['link_id'];
	$username = mysql_query("SELECT link_member FROM cms_links WHERE link_id = '$link_id'");
	$username = mysql_result($username, 0);

mysql_query("UPDATE cms_links SET link_activated ='1' WHERE link_id= '$link_id'") or die (mysql_error());
echo 'Link Successfully Activated!';
}



if ($mode == 'reject'){
	$link_id = $_GET['link_id'];
	$username = mysql_query("SELECT link_member FROM cms_links WHERE link_id = '$link_id'");
	$username = mysql_result($username, 0);


mysql_query("DELETE FROM cms_links WHERE link_id= '$link_id'");
mysql_query("UPDATE cms_users SET link_added ='0' WHERE username = '$username'") or die (mysql_error());
echo 'Link Successfully Deleted!';
}

[devinemke]

Originally posted by klik
When I choose to accept or reject a link, the function does work, but the page doesn't reload. The link i have just Activated/De-Activated should disappear from the page instantly.

why would expect that to happen? look at your script. you are doing the deletion/deactivation after you display the data.

[klik]

Yeh, true. Didn't think it out straight.

Is there a simple way to change the code to allow it to update as I need?

[devinemke]

Originally posted by klik
Is there a simple way to change the code to allow it to update as I need?

um...yes...reverse the order (do the delete first)

[klik]

Thanks again.

Excuse my weak knowledge of PHP.