How do i exclude the current logged in user from a PHP\MySqlscript

Cant say what other thinks, but i personally find this very confusing and unclear.

Now i want to bring the same list back but do not include the books for user thats logged in.

At the moment it returns all the books including the user im logging at, could someone suggets away of not to include the current logged in user?

What exactly does this means.

Maybe he want to exclude the books which the user submitted?!

I think a better option could have been
1. user table userid , username
2.books table userid,bookname
3.available table userid,available date

Now to get all the book name which does not belong to a particular userid
use a query like

Select u.userid,u.username ,b.bookname from user
inner join books b on b.userid = u.userid
where u.userid <> 1

I am not sure what purpose available date is serving on your query.

An alternative could be ( based on your table structure - and my assumptions)
select u.userid,u.username,b.bookname from
user u where u.userid <> 1

Roads_Roads and Ray_Paseur, that sounds like just the job, one thing left then, my login function and the all books funtion are in 2 seperate files i.e. Login.php and Get_All_Book.php.

So if, in the login.php file i declare the $_SESSION and then pass the user id into the $_SESSION, can i then carry this over to the Get_All_Books.php file as $_SESSION [variable'']?

As an example:

//Login.php file

//Set up the variable in login.php file
$loggedinuser=addslashes($_POST['uid']);

//$loggedinuser will be the person who has logged into the app
$_SESSION['login_user']=$loggedinuser;



//Get_All_Books.php file

//Pull the varibale across from login.php
$user_check=$_SESSION['login_user'];

//Run query and exclude logged in user, query simplified for this example
$result = mysql_query("SELECT users.uid, users.name, users.book
FROM users
WHERE users.uid <>$user_check)") or die(mysql_error());

That's the whole point of a Session. Yes you can transfer the variable from your login page to the get all books page.