selecting rows from table with conditions

knucklehead

Hello.
I made a table like this

CREATE TABLE `test` (
  `id` int(11) NOT NULL auto_increment,
  `image` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  PRIMARY KEY  (`avatar_head_id`)
)

and let's say that I inserted these values:

INSERT INTO `test` (`id`, `image`, `user`) VALUES
(1, 'test1.jpg', ''),
(2, 'test2.jpg', ''),
(3, 'test3.jpg', ''),
(4, 'image1.jpg', '5'),
(5, 'image2.jpg', '1');

Now, I would like to select all rows from table where user is nothing AND user is some variable i get from other side. For example:

SELECT * FROM test,users WHERE users.id = $sessionid AND test.id = users.id AND test.id = ''

(test.user corresponds to specific user.id)
I know that example above will not work so I wonder how to do this?
Thanks!

knucklehead

Ah, sorry, I have a typo in my sql query.. What I wanted to say is something like

"SELECT * FROM test,users WHERE users.id = '".$sessionid."' AND test.id = users.id AND test.id = ''"

but it doesn't work anyways! =) Please help! =)

Krik

This

"SELECT * FROM test,users WHERE users.id = '".$sessionid."' AND test.id = users.id AND test.id = ''";

and this

"SELECT * FROM test WHERE test.id = '".$sessionid."' AND test.id = ''";

Are the same I think.

In the first one you check to see if the "id" in the "users" table matches the "$sessionid" and then you check to see if the "id" in the "test" table matches the "id" in the "users" table. So I just cut out the "users" table and "id" and went straight to testing if the "id" in the "test" table matches the "$sessionid".

To return all records in the "test" table where the "id" matches "$sessionid" or are blank, use "OR" in place of "AND".

"SELECT * FROM test WHERE test.id = '".$sessionid."' OR test.id = ''";