MySQLi Login User with Session Variable Problem

You haven't added a Repeat Region around the information you want listed, so it's only displaying the first record. Select the bit you want to repeat, i.e.:

<p><?php echo($Recordset1->getColumnVal("site_id")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_name")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_apn")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_addr")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_super")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_superphone")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_superemail")); ?></p>

then in Server Behaviors, click the plus sign then WebAssist > MySQLi > MySQLi Repeat Region. Select Recordset1 from the dropdown list and click All records. This will then add the repeat region around the info above like this:

<?php
$wa_startindex = 0;
while(!$Recordset1->atEnd()) {
$wa_startindex = $Recordset1->Index;
?>

<p><?php echo($Recordset1->getColumnVal("site_name")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_apn")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_addr")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_super")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_superphone")); ?></p>
<p><?php echo($Recordset1->getColumnVal("site_superemail")); ?></p>

<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>

It should also automatically change the number at the end of the first line of your Recordset from 1 to 0:

$Recordset1 = new WA_MySQLi_RS("Recordset1",$connForms,0);