approve submission problem

[hyipcharts]

Hey again,On to problem #2. When a person joins my site they have to be approved by admin to be listed. In my admin area I have a waiting list and I click on approve or decline. However, when I click on approve or decline nothing happens. The page only refreshes. Is there another way to write this code?

<td valign=top width=33%>       <a href="?a=approve_listing&lid=';      echo $list['id'];      echo '&gid=';      echo $frm['gid'];      echo '&p=';      echo $frm['p'];      echo '&return=new_listings">[approve]</a><br>

Thanks in advance

[Mr_CHISOL]

Hi!What code do you have that handles the "call" (updates the db)?You need something that updates the info in the database using an UPDATE-statement.smething like this:

if (isset($_GET['a'])) {  if ($_GET['a'] == 'approve_listing') {	  $SQL = 'UPDATE table SET approved = 1 WHERE id='.$_GET['lid']:  } else if ($_GET['a'] == 'deny_listing') {	  $SQL = 'DELETE * FROM table WHERE id='.$_GET['lid']:  } else	  exit();  mysql_query( $SQL ) or die('Error: '.mysql_error() );}

Hope that helped.Good Luck and Don't Panic!

[hyipcharts]

Hi!What code do you have that handles the "call" (updates the db)?You need something that updates the info in the database using an UPDATE-statement.smething like this:

if (isset($_GET['a'])) {  if ($_GET['a'] == 'approve_listing') {	  $SQL = 'UPDATE table SET approved = 1 WHERE id='.$_GET['lid']:  } else if ($_GET['a'] == 'deny_listing') {	  $SQL = 'DELETE * FROM table WHERE id='.$_GET['lid']:  } else	  exit();  mysql_query( $SQL ) or die('Error: '.mysql_error() );}

Hope that helped.Good Luck and Don't Panic!

Thanks for that. It could be something I missed. I will recheck the code and see if it is calling the db. Thanks again.