Jump to content

munkitkat

Members
  • Content Count

    7
  • Joined

  • Last visited

  1. I have the CASPIO table that has the same structure as my old MySQL DB. I need to convert this mysql query into CASPIO REST api $mquery = "SELECT m.*, DATE_FORMAT(m.created, '%e %b %Y %h:%i %p') AS message_date, u.fname, u.lname FROM cashbackengine_messages m, cashbackengine_users u WHERE u.user_id='$userid' AND m.is_admin='0' AND m.user_id=u.user_id ORDER BY created DESC"; I'm not sure whether CASPIO REST api supports join. If yes, how? Can anybody help me? Thank you.
  2. I hope somebody has an idea for this. I'm stuck creating the report, step 3 below. 1) user Bob insert its color preferences on a search web form: Name color1 color2 color3 color4 Bob red blue yellow black 2) it is compared against a table I created with information from other users that also like colors Name color1 color2 color3 color4 John red white orange brown mary purple magenta green grey Elen white green red blue 3) I need to give Bob the
  3. I have exactly the same situation, suggestion are welcome! Thanks!
  4. This is fantastic and exactly what I needed. Is there a way to also add in an alert if the value>=0? (i.e. if the sum is less than 100%)? I want to ensure that those responding to the form enter exactly 100 percent in the fields specified.
  5. Thanks for sharing! I also have the same problem
×
×
  • Create New...