Crosselling use with Product Extra Fields

[inferno1121]

Hello,

I'm building a croselling box which shows up the Croselling product with similar title.

I'm currently thinking of using the product extra fields to input some keywords on it to grab out the crosell products.

Could anyone here can help to provide me the SQL statement of this? Since I'm quite new to SQL.

Or are there any good suggestion on other way to showing this crossselling box?

Thankyou.

regards,
inferno

[jpf]

Is there a reason why your not using the X-Sell - Cross Sell module?

X-Sell v2.5.2 for rc2a


Or you could look at (but have not experance with):

Fast Easy Cross-Sell
or
MATCHING PRODUCTS CROSS-SELL