MySQL Forums :: PHP :: Problem with SQL query :( * SOLVED :)


Advanced Search

Problem with SQL query :( * SOLVED :)
Posted by: Sebastian Maur ()
Date: January 18, 2014 08:40AM

Hello, i hope someone can tell me what I'm doing wrong, I learned all by myself trough trying and testing, so please if I could do something better then tell me!


I am trying to Programm a filter, but I stuck with my logic

If I do it without brackets, it gives wrong Results, if I do it with brackets it gives no Results back :S

I made, some pictures of the problem, on the last picture is the Statement with and without brackets..

http://www.file-upload.net/download-8527621/problem.zip.html

edit ( text version ) :

I've a table:


marketplace_properties_used

id | id_marketplace | id_marketplace_properties_label | id_marketplace_properties | value
1 | 10 | 3 | 0 |
2 | 10 | 6 | 35 |
4 | 10 | 10 | 22 |
5 | 10 | 9 | 0 |
6 | 11 | 3 | 0 |
7 | 11 | 6 | 5 |
8 | 11 | 7 | 7 |
9 | 11 | 7 | 10 |
10 | 11 | 10 | 21 |
11 | 12 | 3 | 0 | verschenke xD
12 | 12 | 6 | 5 |
13 | 12 | 7 | 8 |
14 | 12 | 7 | 9 |
15 | 12 | 10 | 21 |
16 | 13 | 3 | 0 | verschenke haha
17 | 13 | 6 | 35 |
18 | 13 | 7 | 7 |
19 | 13 | 7 | 8 |
20 | 13 | 10 | 20 |


so, when I do the first statement:

SELECT `id_marketplace` FROM `marketplace_properties_used` WHERE (`id_marketplace_properties_label` = 7 AND `id_marketplace_properties` = 7 )

Result ( like it should be ) :

11, 13

now I want to add another filter for more properties ( I tried like this but not working ) :


SELECT `id_marketplace` FROM `marketplace_properties_used` WHERE (`id_marketplace_properties_label` = 6 AND `id_marketplace_properties` = 5 ) OR
(`id_marketplace_properties_label` = 6 AND `id_marketplace_properties` = 35 ) AND
(`id_marketplace_properties_label` = 7 AND `id_marketplace_properties` = 7 )

but it's result is 11,12 instead of 11, 13

then I tought maybe the brackets:

SELECT `id_marketplace` FROM `marketplace_properties_used` WHERE ((`id_marketplace_properties_label` = 6 AND `id_marketplace_properties` = 5 ) OR
(`id_marketplace_properties_label` = 6 AND `id_marketplace_properties` = 35 )) AND
(`id_marketplace_properties_label` = 7 AND `id_marketplace_properties` = 7 )

but this is an empty result..
it should be 11, 13 again

I dont know what to do anymore :S



I hope someone can help me here !



Edited 2 time(s). Last edit at 01/23/2014 04:30PM by Sebastian Maur.

Options: ReplyQuote


Subject Written By Posted
Problem with SQL query :( * SOLVED :) Sebastian Maur 01/18/2014 08:40AM
Re: Problem with SQL query :( Peter Brawley 01/18/2014 10:39PM
Re: Problem with SQL query :( Sebastian Maur 01/19/2014 03:48AM
Re: Problem with SQL query :( Peter Brawley 01/19/2014 12:30PM
Re: Problem with SQL query :( Peter Brawley 01/19/2014 12:41PM
Re: Problem with SQL query :( Sebastian Maur 01/20/2014 09:35AM
Re: Problem with SQL query :( Rick James 01/20/2014 03:24PM
Re: Problem with SQL query :( Sebastian Maur 01/21/2014 03:40PM
Re: Problem with SQL query :( Rick James 01/21/2014 06:22PM
Re: Problem with SQL query :( Sebastian Maur 01/22/2014 09:48AM
Re: Problem with SQL query :( Rick James 01/22/2014 04:19PM
Re: Problem with SQL query :( Sebastian Maur 01/22/2014 11:25PM
Re: Problem with SQL query :( Rick James 01/23/2014 12:15AM
Re: Problem with SQL query :( Sebastian Maur 01/23/2014 01:18AM
Re: Problem with SQL query :( Rick James 01/23/2014 10:23AM
Re: Problem with SQL query :( Sebastian Maur 01/23/2014 04:30PM
Re: Problem with SQL query :( Rick James 01/19/2014 12:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.