What is a default value mean when setting up a multiparameter search in dreamweaver?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Donny Green
    New Member
    • Jan 2011
    • 1

    #1

    What is a default value mean when setting up a multiparameter search in dreamweaver?

    Here is the code for the page:
    <?php require_once('C onnections/test.php'); ?>
    <?php
    $maxRows_Record set1 = 10;
    $pageNum_Record set1 = 0;
    if (isset($_GET['pageNum_Record set1'])) {
    $pageNum_Record set1 = $_GET['pageNum_Record set1'];
    }
    $startRow_Recor dset1 = $pageNum_Record set1 * $maxRows_Record set1;

    $varGender_Reco rdset1 = "m";
    if (isset(#formGen der#)) {
    $varGender_Reco rdset1 ) (get_magic_quot es_gpc()) ? #formGender# : addslashes(#for mGender#);
    }
    $varAge_Records et1 = "12";
    if (isset(#formAge #)) {
    $varAge_Records et1 ) (get_magic_quot es_gpc()) ? #formAge# : addslashes(#for mAge#);
    }
    $varZipCode_Rec ordset1 = "82001";
    if (isset(#formZip Code#)) {
    $varZipCode_Rec ordset1 ) (get_magic_quot es_gpc()) ? #formZipCode# : addslashes(#for mZipCode#);
    }
    mysql_select_db ($database_test , $test);
    $query_Recordse t1 = sprintf("SELECT table01.UserNam e, table01.Name, table01.Gender, table01.Age, table01.Height, table01.ZipCode , table01.Hunting , table01.Fishing FROM table01 WHERE Gender = "%s" AND Age = "%s" AND ZipCode = "%s" ORDER BY table01.Age", $varGender_Reco rdset1,$varAge_ Recordset1,$var ZipCode_Records et1);
    $query_limit_Re cordset1 = sprintf("%s LIMIT %d, %d", $query_Recordse t1, $startRow_Recor dset1, $maxRows_Record set1);
    $Recordset1 = mysql_query($qu ery_limit_Recor dset1, $test) or die(mysql_error ());
    $row_Recordset1 = mysql_fetch_ass oc($Recordset1) ;

    if (isset($_GET['totalRows_Reco rdset1'])) {
    $totalRows_Reco rdset1 = $_GET['totalRows_Reco rdset1'];
    } else {
    $all_Recordset1 = mysql_query($qu ery_Recordset1) ;
    $totalRows_Reco rdset1 = mysql_num_rows( $all_Recordset1 );
    }
    $totalPages_Rec ordset1 = ceil($totalRows _Recordset1/$maxRows_Record set1)-1;
    ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Untitl ed Document</title>
    </head>

    <body>
    <br />
    Here are your search results... <br />
    <br />
    <table border="1">
    <tr>
    <td>Name</td>
    <td>Email</td>
    <td>Gender</td>
    <td>Age</td>
    <td>MStatus</td>
    <td>Height</td>
    <td>ZipCode</td>
    <td>Hunting</td>
    <td>Fishing</td>
    </tr>
    <?php do { ?>
    <tr>
    <td><?php echo $row_Recordset1['Name']; ?></td>
    <td><?php echo $row_Recordset1['Email']; ?></td>
    <td><?php echo $row_Recordset1['Gender']; ?></td>
    <td><?php echo $row_Recordset1['Age']; ?></td>
    <td><?php echo $row_Recordset1['MStatus']; ?></td>
    <td><?php echo $row_Recordset1['Height']; ?></td>
    <td><?php echo $row_Recordset1['ZipCode']; ?></td>
    <td><?php echo $row_Recordset1['Hunting']; ?></td>
    <td><?php echo $row_Recordset1['Fishing']; ?></td>
    </tr>
    <?php } while ($row_Recordset 1 = mysql_fetch_ass oc($Recordset1) ); ?>
    </table>
    </body>
    </html>
    <?php
    mysql_free_resu lt($Recordset1) ;
    ?>
Working...