[Ipuck]

Hello!!

I have tried to run a web query but when I tried to compare two fields it doesn't work.

I create a table with some especial values and I called it "vb_tbulletins" and I want to compare the values to the customer option fields that I have also created.
Fields5,6,7.

If I run the webquery just like the way is shown it works fine.

SELECT COMPNAME,BULDTE,MAKETXT,MODELTXT,YEARTXT,SUMMARY
FROM vb_tbulletins

If a tried to get the information from the users extra fields works OK.

SELECT COMPNAME,BULDTE,MAKETXT,MODELTXT,YEARTXT,SUMMARY,f ield5,fiel6,field7
FROM vb_tbulletins,vb_userfield

Now if a want to compare the fields, then I get nothing.

SELECT COMPNAME,BULDTE,MAKETXT,MODELTXT,YEARTXT,SUMMARY,f ield5,fiel6,field7
FROM vb_tbulletins,vb_userfield
WHERE MAKETXT=field5 AND MODELTXT=field6 AND YEARTXT=field7

Also how can I use the "fields" from the visitor user?

Thank you for help!!