My query is being run with no results.
Posted on
16th Feb 2014 07:03 pm by
admin
I have this.
Code: function DropUser($duser_id, $user_email, $user_username) {
Did you know?Explore Trending and Topic pages for more stories like this.
if(isset($_SESSION['admin_username']) && isset($_SESSION['admin_id']) && isset($_SESSION['admin_session_key'])) {
$this->duser_id = mysql_real_escape_string(trim(addslashes(strip_tags(is_numeric($duser_id)))));
$this->user_email = mysql_real_escape_string(trim(addslashes(strip_tags($user_email))));
$this->user_username = mysql_real_escape_string(trim(addslashes(strip_tags($user_username))));
if(!empty($this->duser_id) && !empty($this->user_email) && !empty($this->user_username)) {
$this->dropusersql = "DELETE FROM `members` WHERE `members`.`user_id` = '$this->duser_id' AND `members`.`username` = '$this->user_username' AND `members`.`emailaddress` = '$this->user_email' LIMIT 1";
$this->run_dropusersql = mysql_query($this->dropusersql) or trigger_error('Query failed: ' . mysql_error(), E_USER_ERROR);
$this->removecomplete = '<font color="green"> - The user you select was removed.</font>';
return($this->removecomplete);
} else {
$this->emptyfields = "<font color='red'> - You have left mandatory fields empty.</font>";
return($this->emptyfields);
}
} else {
header('Location: login.php');
}
}
(Part of a class). I get the print back (<font color="green"> - The user you select was removed.</font>) but the query isnt deleting the row.
Many thanks,
No comments posted yet
Your Answer:
Login to answer
140 
12 
Other forums
start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get
PHP Thumbnail Creation
Ok so i use this function to create thumbnails:
Code: [Select]function createthumb($name,$fil
question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.
I hav
Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba
GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.
I have a
How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't
IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying
Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t
Check something, wait, check again, do something!
Hi guys.
I wonder if someone can help me with this.
Basically, what I want to do is (
question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or
