SQL quary?

[Proximity]

I need a quary to check my database to see if the name exitst or not

 

[Adil]

We need more info...

 

[Proximity]

check the user table to check if name exists

 

[Adil]

What is the name of the user table?
What is the name of the column?

SELECT * FROM users WHERE users.username = 'Adil';

 

[Proximity]

users
and name

 

[RastaLulz]

You'd execute something along the lines of the following query:

SELECT `id` FROM `user_table` WHERE `username` = '<username>' LIMIT 1

Then you'd check the number of rows it returns, and if returns one or more, then the username exists.

 

[Proximity]

function check_availability(){  

//get the username  

var username = $('#rUsername').val();  

//use ajax to run the check  

$.post("./users/php/site/user/check", { username: username },  

function(result){  

if(result == 1){  

$('#username_availability_result').html('<span style="color:green">Username: <b>' + username + '</b> is available!</span>');  

}

else

{  

$('#username_availability_result').html('<span style="color:red">Username: <b>' + username + '</b> is taken!</span>');  

}  

});  

}

that is my script It check /users/php/site/user/check/index.php and runs to see if its available.

 

[Hindi]

function check_availability(){

//get the username

var username = $('#rUsername').val();

//use ajax to run the check

$.post("./users/php/site/user/check", { username: username },

function(result){

if(result == 1){

$('#username_availability_result').html('<span style="color:green">Username: <b>' + username + '</b> is available!</span>');

}

else

{

$('#username_availability_result').html('<span style="color:red">Username: <b>' + username + '</b> is taken!</span>');

}

});

}

that is my script It check /users/php/site/user/check/index.php and runs to see if its available.

From what its seen, Looks like a Habbo staff page where it checks if the staff member is online or not, If yes the status bar goes green and if not, turns red.

Nevertheless, I am assuming you are wanting to check if the user is online via DB Query right?
If that's the case use this query

SELECT users.username FROM users where users.online = 1;

 

[Proximity]

This is for a custom login page for my mc server site. And next time read

$('#username_availability_result').html('<span style="color:green">Username: <b>' + username + '</b> is available!</span>');