Re: [mv] if-data with SQL?

[jojo@buchonline.net]

******    message to minivend-users from jojo@buchonline.net     ******

On 12 Feb, Jarno Niemela wrote:
> ******    message to minivend-users from Jarno Niemela <jargon@iki.fi>     ******
> 
> At 09:05 17.2.2000 +0100, you wrote:
>>******    message to minivend-users from jojo@buchonline.net     ******
>>
>>Hi list,
>>
>>i'm new in MySQL and i work with success. But i'm (desperatly?) seeking
>>for a little bit of SQL or MV codes like
>>
> 
> Hello jojo.
> 
> Do you need to use SQL commands, If I remember you can use any MYSQL table
> as normal arbitrary database table. Just like it would be in a file,
> instead of SQL.

Hi Jarno,

yes! You said it! I need to use SQL commands. But i have a special
problem and i don't know which SQL commands is possible. For example:

Normaly i use

[area href="scan/ml=3/st=sql/fi=products/sf=brand_code/se=[scratch brands]/sf=category_code/se=[scratch category]"]

I have some tables like products, category, brand, etc.. My shop build a
list like


(after the first klick onto the brandslink)
1. Adidas
2. Swatch
3. Nokia
etc.

(after the second klick onto the one brand for example Nokia)
Brand : Nokia
Category:
1. Swatch
2. Handy
3. Food
etc.

You see, Nokia don't sell any food. I want a code like

Brand   : Nokia
Categroy:

[loopcategory from database category]

[if-exist-category-brand (category="123" _AND_ brand="Nokia")
from products]

[area href="scan/ml=3/st=sql/fi=products/sf=brand_code/se=[scratch brands]/sf=category_code/se=[scratch category]"]
[/if]


[/loopcategory]

I need a solution for the above if-statement to get this

(after the second klick onto the one brand for example Nokia)
Brand : Nokia
Category:
1. Handy
etc.


Thanks!

Joachim

-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1971449
45886 Gelsenkirchen         FAX: 0209 1671449

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list