MySQL search query failing

[budimir]

Guys,

 

Can someone explain me, why this query is failing:

$upit_prikaz = "SELECT * FROM katalog_pribora_item LEFT JOIN katalog_pribora_slike ON katalog_pribora_item.id = katalog_pribora_slike.id_item WHERE (grupa_artikla = '1HP' OR grupa_artikla = '1HU') AND novi_pribor = '1' AND prikaz_katalog = '1' ";
$query_prikaz = mysql_query($upit_prikaz) or die (mysql_error());

And this one is working fine:

$upit_prikaz = "SELECT * FROM katalog_pribora_item LEFT JOIN katalog_pribora_slike ON katalog_pribora_item.id = katalog_pribora_slike.id_item WHERE grupa_artikla = '1HP' AND novi_pribor = '1' AND prikaz_katalog = '1' ";
$query_prikaz = mysql_query($upit_prikaz) or die (mysql_error());

Difference is that lower one is not having one OR statment.

[mac_gyver]

define: this query is failing?

 

what result is it producing and what is wrong with that result?

[B_CooperA]

Have you tried to execute that query in PHPMyAdmin or similiar? Does it gives you a syntax error or just not working? What I would suggest is that you remove the parenthesis outside the OR statement.

[Barand]

with the parentheses you have

 

(A OR B) AND C AND D

 

without, you will effectively have

 

A OR (B AND C AND D)

[vinny42]

 

without, you will effectively have

 

There is no OR in the second query.  :-)

 

However, the first query will also grab records with grupa_artikla = '1HU', the second only '1HP', so my guess is there are no records that have '1HP' that meet the other requirements.

[Barand]

There is no OR in the second query.  :-)

 

 

I was referring to the first query and it was a caveat if following B_CooperA's suggestion

[vinny42]

 

I was referring to the first query and it was a caveat if following B_CooperA's suggestion

 

I clearly wasn't awake yet, sorry :-)

[budimir]

Guys,

 

I have managed to track my problem. Query is actually working as it was suposed to, but I messed up with id linking. That's why it couldn't return any data.

 

Got it all sorted out now.

 

Thank you for you're help. B_CooperA pushed me to a good track.