Jump to content

randyinla

Members
  • Content Count

    59
  • Joined

  • Last visited

  • Days Won

    1

randyinla last won the day on October 7 2015

randyinla had the most liked content!

Community Reputation

1 Neutral

About randyinla

  • Rank
    novice
  • Birthday 10/03/1907

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, I have a field called 'mytournament1'. I also have a field called 'mytournament1played'. With a form, I create the variable $tournament to bring 'mytournament1' to my results page. $tournament = $_GET['tournament']; I'd like to force the results page to search for the field 'mytournament1played' for each record by using the variable $tournament and combining the word 'played' or the variable $played. $played = 'played'; $tournamentplayed = $tournament . $played; $tournamentplayed2 = $record->getField('$tournamentplayed'); (I want it to deliver) $record->getField('mytournament1played'); I know the 1st '$record->getField' line is wrong. Can I combine 2 variables that spell out a database field name (mytournament1played) that can be used to call up a field in a search? i.e. if ($tournamentplayed2!='1') { thanks in advance for your help!
  2. randyinla

    Changing $varCount & $row parameters in PHP

    Thanks Doughemi and Webko, I tried both techniques and did not get the results I'm looking for. I don't know if it's possible to do. I'm ranking tennis doubles players, here's a link. http://ssvtennis.com/include-sd-ssvcuprankings.php
  3. Hi, I'd like to creat a sorting order with a $varCount like: 1 1 2 2 3 3 and alternating row colors that will print: pink pink yellow yellow pink pink Here is the kind of coding I'm using that works fine for sequential numbering and odd/even row colors. I appreciate anyone who can help me change these parameters, as I have tried every combination I could think of. Thanks! <?php $row = 0; $varCount = 0; foreach($records as $record) { $varCount = $varCount + 1; if($row % 2 == 0) { echo '<tr class="alt_row_color">'; } else { '<tr>'; } ?>
  4. Hi Doughemi, I'd like to do a search where the the result doesn't equal something.  My coding is obviously wrong, but hope you get the idea.  All records where myField does not equal '1'

    Thanks

    $myFind->addFindCriterion('myField', '!=1');

    1. doughemi

      doughemi

      I prefer that you ask questions on the forum in the future. That way, others can benefit.

      See this thread.

      I can't tell if the link was included in the previous reply.  It is http://fmforums.com/topic/100786-constrain-find-possible/?do=findComment&comment=458882

       

  5. Hi, is there any reason my DB crashes web publishing engines? It is a simple database on an FMP12 server. clients generally toggle simple buttons on or off. Is there a function inside the DB itself that I have not turned on or off? Is it a sharing, permissions or admin thing? Is this a problem with other users? I'm new and you guys in this forum have really helped me a lot! Thanks in advance!
  6. randyinla

    Listing only goes to 500 records

    Thanks for all your help Webko!
  7. randyinla

    Listing only goes to 500 records

    I tried the pagination link of yours and It gave me errors, do you know if there's any bugs in it? Any other links on pagination? I'd love to see your module if you dug one up. Thanks!
  8. randyinla

    Listing only goes to 500 records

    I'd love to see your pagination version.
  9. randyinla

    Find Records within a Number Range

    thanks Webko, that's tight coding!
  10. randyinla

    Find Records within a Number Range

    thanks Webko, that's terrific. you're a champ! How would that work using variables? addFindCriterion('ssvm', '$Num1...$Num2');
  11. Hi, I'm trying to find records with a number field that are greater than or less than 2 numbers, i.e. if I'm looking for the records greater than 115 and less than 120. $myFind->addFindCriterion('ssvm', '>115'); $myFind->addFindCriterion('ssvm', '<120'); do I need $myFind->setLogicalOperator(FILEMAKER_FIND_AND); or am I way off base? Thanks for your advice!
  12. randyinla

    Sort Records By Null

    Thanks Doug and Webko, coding works great. Can you recommend a good PHP book or links on the web for filemaker and PHP?
  13. randyinla

    My Records are Deleting without Password

    Thanks Webko, how do I change which account I'm logged in under? I guess I need the 'guest' account which has only 'edit and create' privilieges. I don't want my clients deleting anything. I'm looking into the ShowOnWebFlag field for different reasons. I'm trying to find a way to send an email to myself when a client hits a submit button. Thanks!
  14. Hi, I'm doing a newFindAllCommand in a db with 5000 records. I get no results unless I set my $myFind->setRange(0,500); , which only returns the first 500. 500 seems to be a cut-off point for some reason, Is this a thing? Also, I want a varCount that doesn't refresh back to '1' when the next 500 records are displayed, i.e. the next record numbers should say 501, 502... Thanks again!
  15. randyinla

    Sort Records By Null

    Hi, I have several fields I'd like to sort that are empty, like Email. Here are 2 snippets of code that are not returning results: $RandyFind->addFindCriterion("Email", ''); or $RandyFind->addFindCriterion("Email", "=="); Any thoughts? Also, is there a way to force null into a field when editing? Thanks a Bunch!!
×

Important Information

By using this site, you agree to our Terms of Use.