prefix . "adserve"; if($id > 0) { // update $query = "UPDATE $table_name SET title='".$_POST['title']."', url='".$_POST['url']."', src='".$_POST['src']."', user='".$_POST['user']."', email='".$_POST['email']."', keywords='".$_POST['keywords']."', credits=".$_POST['credits'].", active=".$_POST['active']." WHERE id=$id"; } else { // insert $query = "INSERT INTO " . $table_name . " (title, url, src, email, keywords, credits, active,impressions,user,clicks) " . "VALUES ('".$_POST['title']."', '".$_POST['url']."', '".$_POST['src']."', '".$_POST['email']."', '".$_POST['keywords']."', '".$_POST['credits']."', '".$_POST['active']."',0, '".$_POST['user']."',0 )"; } $wpdb->query($query); return get_settings('siteurl')."/wp-admin/edit.php?page=wp-adserve/ad.php"; } ?>