DATAASSIST extension help needed

Ask a Question related to Macromedia Exchange Dreamweaver Extensions, Design and Development.

  1. #1

    Default DATAASSIST extension help needed

    I am using the Data Assist extension and need some help.
    I am trying to do a search that looks at 2 columns.

    Can anyone tell me why this script returns all records?

    <?php
    $maxRows_WADAALFL = 20;
    $pageNum_WADAALFL = 0;
    if (isset($_GET['pageNum_WADAALFL'])) {
    $pageNum_WADAALFL = $_GET['pageNum_WADAALFL'];
    }
    $startRow_WADAALFL = $pageNum_WADAALFL * $maxRows_WADAALFL;

    $ParamvisitorTeam_WADAALFL = "-1";
    if (isset($_GET['S_homeTeam'])) {
    $ParamvisitorTeam_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_homeTeam']
    : addslashes($_GET['S_homeTeam']);
    }
    $ParamhomeTeam_WADAALFL = "-1";
    if (isset($_GET['S_homeTeam'])) {
    $ParamhomeTeam_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_homeTeam'] :
    addslashes($_GET['S_homeTeam']);
    }
    $Paramrainout_WADAALFL = "0";
    if (isset($_GET['S_rainout'])) {
    $Paramrainout_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_rainout'] :
    addslashes($_GET['S_rainout']);
    }
    mysql_select_db($database_schedule, $schedule);
    $query_WADAALFL = sprintf("SELECT * FROM ALFL WHERE (visitorTeam LIKE '%%%s%%'
    OR '-1' = '%s') OR (homeTeam LIKE '%%%s%%' OR '-1' = '%s') OR (rainout = %s OR
    '0' = '%s') ORDER BY ID ASC",
    $ParamvisitorTeam_WADAALFL,$ParamvisitorTeam_WADAA LFL,$ParamhomeTeam_WADAALFL,$P
    aramhomeTeam_WADAALFL,$Paramrainout_WADAALFL,$Para mrainout_WADAALFL);
    $query_limit_WADAALFL = sprintf("%s LIMIT %d, %d", $query_WADAALFL,
    $startRow_WADAALFL, $maxRows_WADAALFL);
    $WADAALFL = mysql_query($query_limit_WADAALFL, $schedule) or
    die(mysql_error());
    $row_WADAALFL = mysql_fetch_assoc($WADAALFL);

    if (isset($_GET['totalRows_WADAALFL'])) {
    $totalRows_WADAALFL = $_GET['totalRows_WADAALFL'];
    } else {
    $all_WADAALFL = mysql_query($query_WADAALFL);
    $totalRows_WADAALFL = mysql_num_rows($all_WADAALFL);
    }
    $totalPages_WADAALFL = ceil($totalRows_WADAALFL/$maxRows_WADAALFL)-1;
    ?>

    phpStumped Guest

  2. Similar Questions and Discussions

    1. Hi-Lite Data Extension Needed
      I am creating a web site that has a page which list an event, the person speaking at the event, the date of the event and a link to a PDF of the...
    2. What type o Extension is needed?
      Hi Everyone - was wondering if someone can point me in the right direction. I am a coder but am trying to make a 'easy front end' for designers and...
    3. dreamweaver mx to 8 extension help needed
      I recently went from dreamweaver mx to dreamweaver 8 and I'm having some trouble with an extension I use to use. The extension I'm talking about is...
    4. Drop Down Menu Extension Needed for DW8/Mac
      I am looking for an extension that does a nice job of a number of drop down menus for DW 8. Being originally a CyberStudio user (now GoLive), I...
    5. Extension Help needed
      Hey all, I am moving forward in my dreamweaver arsenal and attempting to build a E-Commerce site useing an extension. I am looking at 3 different...
  3. #2

    Default Re: DATAASSIST extension help needed

    This is a question for the WebAssist forum. Go here:
    [url]http://www.webassist.com:8119/[/url] and see if anyone else has had a similar
    question.
    If not, post your question there and you are very likely to get a helpful
    response.

    WebAssist Guest

  4. #3

    Default Re: DATAASSIST extension help needed

    haha




    "WebAssist" <webforumsuser@macromedia.com> wrote in message
    news:fpfal5$5d0$1@forums.macromedia.com...
    > This is a question for the WebAssist forum. Go here:
    > [url]http://www.webassist.com:8119/[/url] and see if anyone else has had a similar
    > question.
    > If not, post your question there and you are very likely to get a helpful
    > response.
    >

    twocans Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139