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
ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page
Parse Error
Hi Guys,
I have a function in my class which returns a string link variable. The problem is i
Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added
Checking if variable is 0 as opposed to NULL/Empty...
I'm trying to write some code that will retrieve a user's access level from my database and if it do
echo $rows help
Hi all,
Hopefully something simple that I don't know!
I have this:
Code: [Selec
Calculating n! using vector
#include
#include
#include
using
Help with captcha script needed
Hello,
I am working on a script where reCAPTCHA or a similar form of CAPTCHA will be used, f
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else
I can give them an F
How can I Compare two xml documents?
Hi all,
I am doing a POC for my project and I am using XE database 10g version.
Embed Video Problem
Hey, thanks for looking!
File to be embedded:
Code: <playlist version="1&q