Skip to main content
Inspiring
December 2, 2006
Answered

sql recordset syntax for IF THEN ELSE

  • December 2, 2006
  • 1 reply
  • 294 views
here's what i'm trying to do: i'm trying to display two different levels of content depending on whether a user pays or not. for example, if field xyz_paying = 'yes' then select *, else display only some of the fields, so i'm trying to use a mysql statement to create a SELECT filter. i've been trying to do this IF, THEN, ELSE, but i'm getting syntax error messages. could someone show me a simple example please. or suggest a good resource. thanks.
This topic has been closed for replies.
Correct answer hconnorjr
i can't seem to get the sql to do what i want, so i changed gears and i'm going to use a conditional region to display only when my paying field = = y. works fine.

i guess this is just as good as forcing the sql to do what you want. now i'm pulling all the data from the tables but displaying it only selectively.

1 reply

hconnorjrAuthorCorrect answer
Inspiring
December 2, 2006
i can't seem to get the sql to do what i want, so i changed gears and i'm going to use a conditional region to display only when my paying field = = y. works fine.

i guess this is just as good as forcing the sql to do what you want. now i'm pulling all the data from the tables but displaying it only selectively.