Loop text in WHERE mysql

mysql where loop

[twistedmind000]

Hi i want to know if i can loop this text with variable in mysql query behind WHERE: order_id!= '$o_id'. this $o_id gets picked out of the database if its an other country then asked for. (example if logged in admin country = USA the NLD will not be shown)

I only want to know how to loop the text thats all help me :)

[twistedmind000]

Another possibillity would be making a loop from a database with the same text an variable exmpl $filter
that filter would contain order_id!= '100' order_id!= '102' etc.

[zCat]

You can do something like:

WHERE order_id NOT IN (101,102,103)

if you have a few values you want to exclude.

[twistedmind000]

i think my first post wasnt that clear... becous i know how to do that but i want to read them from the database so its not static

[twistedmind000]

Anyone have any help on this?

[twistedmind000]

please?

[Twisted Mind]

I have the same problem :)

[zCat]

I'm still not exactly sure what you're after, but it sounds like you might need a subquery, e.g.

... WHERE order_id NOT IN (SELECT order_id FROM orders WHERE country='USA')

Although this will only work on MySQL 4.1 and later, IIRC.

[Twisted Mind]

hmm its not what im asking for but it might be working and it certain something that does exist :P ill try it out have mysql latest dont worry

[Twisted Mind]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE order_id NOT IN (SELECT order_id FROM mos_pshop_orders WHERE country='NLD'' at line 7
well i thought it should work but it says this what now? (changed some to variables)

[Twisted Mind]

forgot some things had 2ce where on start and forgot )
now it says: Unknown column 'country' in 'where clause'

[Twisted Mind]

did some things wrong myself now it works completely the oppisite it shows the ones it should not show but this will be an easy edit thanks dude u are the best

[Twisted Mind]

Works like a train forgot to say that