Pagination Goes Blank After Adding PREP STMT

Hi,

This non-prep stmt pagination works fine:

[code]
<?php
//Required PHP Files.
include ‘header_account.php’; //Required on all webpages of the Account.
?>

<?php
if (!$conn)
{
$error = mysqli_connect_error();
$errno = mysqli_connect_errno();
print “$errno: $errorn”;
exit();
}

//Grab Username of who’s Browsing History needs to be searched.

if (isset($_GET[‘followee_username’]) && !empty($_GET[‘followee_username’]))
{
$followee_username = $_GET[‘followee_username’];

if($followee_username != “followee_all” OR “Followee_All”)
{
//$query = “SELECT * FROM browsing_histories WHERE username = “$followee_username””;
$query_type = “followee_username”;
$followed_word = “$followee_username”;

echo “$followee_username”;
}
else
{
$query = “SELECT * FROM browsing_histories”;
$query_type = “followee_all”;
$followed_word = “followee_all”;
$follower_username = “$user”;
echo “all”;
}
}

if (isset($_GET[‘followee_id’]) && !empty($_GET[‘followee_id’]))
{
$followee_id = $_GET[‘followee_id’];
//$query = “SELECT * FROM browsing_histories WHERE id = “$followee_id””;
$query_type = “followee_id”;
$followed_word = “$followee_id”;
echo “$followee_id”;
}

if (isset($_GET[‘followee_date_and_time’]) && !empty($_GET[‘followee_date_and_time’]))
{
$followee_date_and_time = $_GET[‘followee_date_and_time’];
$query = “SELECT * FROM browsing_histories WHERE date_and_time = “$followee_date_and_time””;
$query_type = “followee_date_and_time”;
$followed_word = “$followee_date_and_time”;
}

if (isset($_GET[‘followee_browsed_page_converted’]) && !empty($_GET[‘followee_browsed_page_converted’]))
{
$followee_browsed_page_converted = $_GET[‘followee_browsed_page_converted’];
$query = “SELECT * FROM browsing_histories WHERE browsed_page_converted = “$followee_browsed_page_converted””;
$query_type = “followee_browsed_page_converted”;
$followed_word = “$followee_browsed_page_converted”;
}

if (isset($_GET[‘followee_referral_page_converted’]) && !empty($_GET[‘followee_referral_page_converted’]))
{
$followee_referral_page_converted = $_GET[‘followee_referral_page_converted’];
$query = “SELECT * FROM browsing_histories WHERE referral_page_converted = “$followee_referral_page_converted””;
$query_type = “followee_referral_page_converted”;
$followed_word = “$followee_referral_page_converted”;

if (isset($_GET[‘followee_gender’]) && !empty($_GET[‘followee_gender’]))
{
$followee_gender = $_GET[‘followee_gender’];
$query = “SELECT * FROM browsing_histories WHERE gender = “$followee_gender””;
$query_type = “followee_gender”;
$followed_word = “$followee_gender”;
}

if (isset($_GET[‘followee_age_range’]) && !empty($_GET[‘followee_age_range’]))
{
$followee_age_range = $_GET[‘followee_age_range’];
$query = “SELECT * FROM browsing_histories WHERE age_range = “$followee_age_range””;
$query_type = “followee_age_range”;
$followed_word = “$followee_age_range”;
}

if (isset($_GET[‘followee_date_of_birth’]) && !empty($_GET[‘followee_date_of_birth’]))
{
$followee_date_of_birth = $_GET[‘followee_date_of_birth’];
$query = “SELECT * FROM browsing_histories WHERE date_of_birth = “$followee_date_of_birth””;
$query_type = “followee_date_of_birth”;
$followed_word = “$followee_date_of_birth”;
}

if (isset($_GET[‘followee_skin_complexion’]) && !empty($_GET[‘followee_skin_complexion’]))
{
$followee_skin_complexion = $_GET[‘followee_skin_complexion’];
$query = “SELECT * FROM browsing_histories WHERE skin_complexion = “$followee_skin_complexion””;
$query_type = “followee_skin_complexion”;
$followed_word = “$followee_skin_complexion”;
}

if (isset($_GET[‘followee_height’]) && !empty($_GET[‘followee_height’]))
{
$followee_height = $_GET[‘followee_height’];
$query = “SELECT * FROM browsing_histories WHERE height = “$followee_height””;
$query_type = “followee_height”;
$followed_word = “$followee_height”;
}

if (isset($_GET[‘followee_weight’]) && !empty($_GET[‘followee_weight’]))
{
$followee_weight = $_GET[‘followee_weight’];
$query = “SELECT * FROM browsing_histories WHERE weight = “$followee_weight””;
$query_type = “followee_weight”;
$followed_word = “$followee_weight”;
}

if (isset($_GET[‘followee_sexual_orientation’]) && !empty($_GET[‘followee_sexual_orientation’]))
{
$followee_sexual_orientation = $_GET[‘followee_sexual_orientation’];
$query = “SELECT * FROM browsing_histories WHERE sexual_orientation = “$followee_sexual_orientation””;
$query_type = “followee_sexual_orientation”;
$followed_word = “$followee_sexual_orientation”;
}

if (isset($_GET[‘followee_religion’]) && !empty($_GET[‘followee_religion’]))
{
$followee_religion = $_GET[‘followee_religion’];
$query = “SELECT * FROM browsing_histories WHERE religion = “$followee_religion””;
$query_type = “followee_religion”;
$followed_word = “$followee_religion”;
}

if (isset($_GET[‘followee_education’]) && !empty($_GET[‘followee_education’]))
{
$followee_education = $_GET[‘followee_education’];
$query = “SELECT * FROM browsing_histories WHERE education = “$followee_education””;
$query_type = “followee_education”;
$followed_word = “$followee_education”;
}

if (isset($_GET[‘followee_profession’]) && !empty($_GET[‘followee_profession’]))
{
$followee_profession = $_GET[‘followee_profession’];
$query = “SELECT * FROM browsing_histories WHERE profession = “$followee_profession””;
$query_type = “followee_profession”;
$followed_word = “$followee_profession”;
}

if (isset($_GET[‘followee_marital_status’]) && !empty($_GET[‘followee_marital_status’]))
{
$followee_marital_status = $_GET[‘followee_marital_status’];
$query = “SELECT * FROM browsing_histories WHERE marital_status = “$followee_marital_status””;
$query_type = “followee_marital_status”;
$followed_word = “$followee_marital_status”;
}

if (isset($_GET[‘followee_working_status’]) && !empty($_GET[‘followee_working_status’]))
{
$followee_working_status = $_GET[‘followee_working_status’];
$query = “SELECT * FROM browsing_histories WHERE working_status = “$followee_working_status””;
$query_type = “followee_working_status”;
$followed_word = “$followee_working_status”;
}

if (isset($_GET[‘followee_country_of_birth’]) && !empty($_GET[‘followee_country_of_birth’]))
{
$followee_country_of_birth = $_GET[‘followee_country_of_birth’];
$query = “SELECT * FROM browsing_histories WHERE country_of_birth = “$followee_country_of_birth””;
$query_type = “followee_country_of_birth”;
$followed_word = “$followee_country_of_birth”;
}

if (isset($_GET[‘followee_home_town’]) && !empty($_GET[‘followee_home_town’]))
{
$followee_home_town = $_GET[‘followee_home_town’];
$query = “SELECT * FROM browsing_histories WHERE home_town = “$followee_home_town””;
$query_type = “followee_home_town”;
$followed_word = “$followee_home_town”;
}

if (isset($_GET[‘followee_home_neighbourhood’]) && !empty($_GET[‘followee_home_neighbourhood’]))
{
$followee_home_neighbourhood = $_GET[‘followee_home_neighbourhood’];
$query = “SELECT * FROM browsing_histories WHERE home_neighbourhood = “$followee_home_neighbourhood””;
$query_type = “followee_home_neighbourhood”;
$followed_word = “$followee_home_neighbourhood”;
}

if (isset($_GET[‘followee_home_borough’]) && !empty($_GET[‘followee_home_borough’]))
{
$followee_home_borough = $_GET[‘followee_home_borough’];
$query = “SELECT * FROM browsing_histories WHERE home_borough = “$followee_home_borough””;
$query_type = “followee_home_borough”;
$followed_word = “$followee_home_borough”;
}

if (isset($_GET[‘followee_home_city’]) && !empty($_GET[‘followee_home_city’]))
{
$followee_home_city = $_GET[‘followee_home_city’];
$query = “SELECT * FROM browsing_histories WHERE home_city = “$followee_home_city””;
$query_type = “followee_home_city”;
$followed_word = “$followee_home_city”;
}

if (isset($_GET[‘followee_home_county’]) && !empty($_GET[‘followee_home_county’]))
{
$followee_home_county = $_GET[‘followee_home_county’];
$query = “SELECT * FROM browsing_histories WHERE home_county = “$followee_home_county””;
$query_type = “followee_home_county”;
$followed_word = “$followee_home_county”;
}

if (isset($_GET[‘followee_home_district’]) && !empty($_GET[‘followee_home_district’]))
{
$followee_home_district = $_GET[‘followee_home_district’];
$query = “SELECT * FROM browsing_histories WHERE home_district = “$followee_home_district””;
$query_type = “followee_home_district”;
$followed_word = “$followee_home_district”;
}

if (isset($_GET[‘followee_home_region’]) && !empty($_GET[‘followee_home_region’]))
{
$followee_home_region = $_GET[‘followee_home_region’];
$query = “SELECT * FROM browsing_histories WHERE home_region = “$followee_home_region””;
$query_type = “followee_home_region”;
$followed_word = “$followee_home_region”;
}

if (isset($_GET[‘followee_home_state’]) && !empty($_GET[‘followee_home_state’]))
{
$followee_home_state = $_GET[‘followee_home_state’];
$query = “SELECT * FROM browsing_histories WHERE home_state = “$followee_home_state””;
$query_type = “followee_home_state”;
$followed_word = “$followee_home_state”;
}

if (isset($_GET[‘followee_home_country’]) && !empty($_GET[‘followee_home_country’]))
{
$followee_home_country = $_GET[‘followee_home_country’];
$query = “SELECT * FROM browsing_histories WHERE home_country = “$followee_home_country””;
$query_type = “followee_home_country”;
$followed_word = “$followee_home_country”;
}

$referral_page_http = $_SERVER[‘HTTP_REFERRER’];
$referral_page = “$referral_page_http”;
$referral_page_original = “$referral_page”;

$query_string = $_SERVER[‘QUERY_STRING’];

$current_page_http = $_SERVER[‘PHP_SELF’];
$current_page = “$current_page_http”;

$followed_page_original = “$current_page”;

$visiting_pages_count = “1”;
if($visiting_pages_count == “”)
{
$visiting_pages_count = “1”;
}
else
{
$visiting_pages_count++;
}

if($visiting_pages_count == “1”)
{
$current_page_converted = “$settings_user_first_quick_link.$current_page”;
$referral_page_converted = “$settings_user_first_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “2”)
{
$current_page_converted = “$settings_admin_second_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_second_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “3”)
{
$current_page_converted = “$settings_user_third_quick_link.$current_page”;
$referral_page_converted = “$settings_user_third_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “4”)
{
$current_page_converted = “$settings_admin_fourth_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_fourth_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “5”)
{
$current_page_converted = “$settings_user_fifth_quick_link.$current_page”;
$referral_page_converted = “$settings_user_fifth_quick_link.$referral_page”;
}
if($visiting_pages_count == “6”)
{
$current_page_converted = “$settings_admin_first_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_first_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “7”)
{
$current_page_converted = “$settings_user_second_quick_link.$current_page”;
$referral_page_converted = “$settings_user_second_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “8”)
{
$current_page_converted = “$settings_admin_third_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_third_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “9”)
{
$current_page_converted = “$settings_user_fourth_quick_link.$current_page”;
$referral_page_converted = “$settings_user_fourth_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “10”)
{
$current_page_converted = “$settings_admin_fifth_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_fifth_quick_link.$referral_page”;
}
else
{
$visiting_pages_count = “1”;
$current_page_converted = “$settings_user_first_quick_link.$current_page”;
$referral_page_converted = “$settings_user_first_quick_link.$referral_page”;
}

$followed_page_converted = “$current_page_converted”;

$follower_username = $user;
$follower_browser = $_SERVER[‘HTTP_USER_AGENT’];

//Insert the User’s Click Logs into Mysql Database using Php’s Sql Injection Prevention Method “Prepared Statements”.
$stmt = mysqli_prepare($conn,”INSERT INTO following_histories(query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)”);
mysqli_stmt_bind_param($stmt,’ssssssssssiisssssssssssssssssss’,$query_type,$followed_word,$query_string,$followed_page_original,$followed_page_converted,$referral_page_original,$referral_page_converted,$followee_username,$follower_username,$gender,$age_range,$date_of_birth,$skin_complexion,$height,$weight,$sexual_orientation,$religion,$education,$profession,$marital_status,$working_status,$home_town,$home_neighbourhood,$home_borough,$home_council,$home_city,$home_county,$home_district,$home_region,$home_state,$home_country);
mysqli_stmt_execute($stmt);

//Check if User’s Click Logs have been successfully submitted or not.
if (!$stmt)
{
echo “Sorry! Our system is currently experiencing a problem logging your following! We will continuously try logging your clicks!”;
exit();
}
else
{
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
}

$query_type_label = str_replace(“_”,” “,”$query_type”); //Removing underscores so they don’t show-up on the html.
$query_type_label = ucwords(“$query_type_label”); //Upper Casing the first characters.
?>

<!DOCTYPE html>
<html>
<head>
<meta content=”text/html; charset=ISO-8859-1″ http-equiv=” content-type”>
<title><?php echo “Browsing History in $server_time Time.”;?></title>
<meta name=”viewport” content=”width=device-width, initial-scale=1″>
</head>
<body>
<br>
<p align=”center”><span style=”font-weight:bold;”><?php echo “Search Result for:<br> $query_type_label = “${$query_type}””; ?></span></p>
<br>
<br>
<?php
$result = mysqli_query($conn,$query);
$rows_num = mysqli_num_rows($result);

//Total Number of Pages records are spread-over.
$page_count = 100;
$page_size = ceil($rows_num / $page_count);
//Get the Page Number. Default is 1 (First Page).
$page_number = $_GET[“page_number”];
if ($page_number == “”) $page_number = 1;
$offset = ($page_number -1) * $page_size;

$query .= ” limit {$offset},{$page_size}”;
$result = mysqli_query($conn,$query);
?>
<table width=”1500″ border=”0″ cellpadding=”5″ cellspacing=”2″ bgcolor=”#666666″>
<?php
if($rows_num)
{
printf(“<b> %d Result Found …</b>n”,$rows_num); ?><br>
<br>
<tr name=”headings”>
<td bgcolor=”#FFFFFF” name=”column-heading_submission-number”>Submission Number</td>
<td bgcolor=”#FFFFFF” name=”column-heading_logging-server-date-and-time”>Date & Time in <?php echo “$server_time”;?></td>
<td bgcolor=”#FFFFFF” name=”column-heading_browsed-page-converted”>Browsed Page Converted (Visit Page) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_browsed-page-converted”>Browsed Page Converted (Check Stats) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_referral-page-converted”>Referral Page Converted (Visit Page) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_referral-page-converted”>Referral Page Converted (Check Stats) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_username”>Username (Visit Page)</td>
<td bgcolor=”#FFFFFF” name=”column-heading_username”>Username (Check Stats)</td>
<td bgcolor=”#FFFFFF” name=”column-heading_gender”>Gender</td>
<td bgcolor=”#FFFFFF” name=”column-heading_age-range”>Age Range</td>
<td bgcolor=”#FFFFFF” name=”column-heading_date-of-birth”>Date Of Birth</td>
<td bgcolor=”#FFFFFF” name=”column-heading_skin-complexion”>Skin Complexion</td>
<td bgcolor=”#FFFFFF” name=”column-heading_height”>Height</td>
<td bgcolor=”#FFFFFF” name=”column-heading_weight”>Weight</td>
<td bgcolor=”#FFFFFF” name=”column-heading_sexual-orientation”>Sexual Orientation</td>
<td bgcolor=”#FFFFFF” name=”column-heading_religion”>Religion</td>
<td bgcolor=”#FFFFFF” name=”column-heading_education”>Education</td>
<td bgcolor=”#FFFFFF” name=”column-heading_profession”>Profession</td>
<td bgcolor=”#FFFFFF” name=”column-heading_marital-status”>Marital Status</td>
<td bgcolor=”#FFFFFF” name=”column-heading_working-status”>Working Status</td>
<td bgcolor=”#FFFFFF” name=”column-heading_country-of-birth”>Country Of Birth</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-town”>Home Town</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-neighbourhood”>Home Neighbourhood</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-borough”>Home Borough</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-city”>Home City</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-county”>Home County</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-district”>Home District</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-region”>Home Region</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-state”>Home State</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-country”>Home Country</td>
</tr>
<?php while($row = mysqli_fetch_array($result))
{
?>
<tr name=”user-details”>
<td bgcolor=”#FFFFFF” name=”submission-number”><a href=”browsing_histories_v1.php?followee_id=<?php echo $row[‘id’]; ?>&page_number=1″><?php echo $row[‘id’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”logging-server-date-&-time”><a href=”browsing_histories_v1.php?followee_date_and_time=<?php echo $row[‘date_and_time’]; ?>&page_number=1″><?php echo $row[‘date_and_time’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”browsed-page-converted_visit-page”><a href=”<?php echo $row[‘browsed_page_converted’]; ?>&page_number=1″><?php echo $row[‘browsed_page_converted’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”browsed-page-converted_stats-page”><a href=”browsing_histories_v1.php?followee_browsed_page_converted=<?php echo $row[‘browsed_page_converted’]; ?>&page_number=1″><?php echo $row[‘browsed_page_converted’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”referral-page-converted_visit-page”><a href=”<?php echo $row[‘referral_page_converted’]; ?>&page_number=1″><?php echo $row[‘referral_page_converted’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”referral-page-converted_stats-page”><a href=”browsing_histories_v1.php?followee_referral_page_converted=<?php echo $row[‘referral_page_converted’]; ?>&page_number=1″><?php echo $row[‘referral_page_converted’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profile-page_visit-page”><a href=”profile.php?followee_username=<?php echo $row[‘username’]; ?>&page_number=1″><?php echo $row[‘username’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profile-page_stats-page”><a href=”browsing_histories_v1.php?followee_username=<?php echo $row[‘username’]; ?>&page_number=1″><?php echo $row[‘username’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”gender”><a href=”browsing_histories_v1.php?followee_gender=<?php echo $row[‘gender’]; ?>&page_number=1″><?php echo $row[‘gender’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”age-range”><a href=”browsing_histories_v1.php?followee_age_range=<?php echo $row[‘age_range’]; ?>&page_number=1″><?php echo $row[‘age_range’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”date-of-birth”><a href=”browsing_histories_v1.php?followee_date_of_birth=<?php echo $row[‘date_of_birth’]; ?>&page_number=1″><?php echo $row[‘date_of_birth’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”skin-complexion”><a href=”browsing_histories_v1.php?followee_skin_complexion=<?php echo $row[‘skin_complexion’]; ?>&page_number=1″><?php echo $row[‘skin_complexion’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”height”><a href=”browsing_histories_v1.php?followee_height=<?php echo $row[‘height’]; ?>&page_number=1″><?php echo $row[‘height’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”weight”><a href=”browsing_histories_v1.php?followee_height=<?php echo $row[‘weight’]; ?>&page_number=1″><?php echo $row[‘weight’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”sexual-orientation”><a href=”browsing_histories_v1.php?followee_sexual_orientation=<?php echo $row[‘sexual_orientation’]; ?>&page_number=1″><?php echo $row[‘sexual_orientation’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”religion”><a href=”browsing_histories_v1.php?followee_religion=<?php echo $row[‘religion’]; ?>&page_number=1″><?php echo $row[‘religion’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”education”><a href=”browsing_histories_v1.php?followee_education=<?php echo $row[‘education’]; ?>&page_number=1″><?php echo $row[‘education’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profession”><a href=”browsing_histories_v1.php?followee_profession=<?php echo $row[‘profession’]; ?>&page_number=1″><?php echo $row[‘profession’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”marital-status”><a href=”browsing_histories_v1.php?followee_marital_status=<?php echo $row[‘marital_status’]; ?>&page_number=1″><?php echo $row[‘marital_status’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”working-status”><a href=”browsing_histories_v1.php?followee_working_status=<?php echo $row[‘working_status’]; ?>&page_number=1″><?php echo $row[‘working_status’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”country-of-birth”><a href=”browsing_histories_v1.php?followee_country_of_birth=<?php echo $row[‘country_of_birth’]; ?>&page_number=1″><?php echo $row[‘country_of_birth’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-town”><a href=”browsing_histories_v1.php?followee_home_town=<?php echo $row[‘home_town’]; ?>&page_number=1″><?php echo $row[‘home_town’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-neighbourhood”><a href=”browsing_histories_v1.php?followee_home_neighbourhood=<?php echo $row[‘home_neighbourhood’]; ?>&page_number=1″><?php echo $row[‘home_neighbourhood’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-borough”><a href=”browsing_histories_v1.php?followee_home_borough=<?php echo $row[‘home_borough’]; ?>&page_number=1″><?php echo $row[‘home_borough’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-city”><a href=”browsing_histories_v1.php?followee_home_city=<?php echo $row[‘home_city’]; ?>&page_number=1″><?php echo $row[‘home_city’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-county”><a href=”browsing_histories_v1.php?followee_home_county=<?php echo $row[‘home_county’]; ?>&page_number=1″><?php echo $row[‘home_county’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-district”><a href=”browsing_histories_v1.php?followee_home_district=<?php echo $row[‘home_district’]; ?>&page_number=1″><?php echo $row[‘home_district’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-region”><a href=”browsing_histories_v1.php?followee_home_region=<?php echo $row[‘home_region’]; ?>&page_number=1″><?php echo $row[‘home_region’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-state”><a href=”browsing_histories_v1.php?followee_home_state=<?php echo $row[‘home_state’]; ?>&page_number=1″><?php echo $row[‘home_state’]; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-country”><a href=”browsing_histories_v1.php?followee_home_country=<?php echo $row[‘home_country’]; ?>&page_number=1″><?php echo $row[‘home_country’]; ?></a></td>
</tr>
<?php
}
?>
<tr name=”pagination”>
<td colspan=”30″ bgcolor=”#FFFFFF”> Result Pages:
<?php
if($rows_num <= $page_size)
{
echo “Page 1”;
}
else
{
for($i=1;$i<=$page_count;$i++)
echo “<a href=”{$_SERVER[‘PHP_SELF’]}?$query_type=${$query_type}&page_number={$i}”>{$i}</a> “;
}
?>
</td>
</tr>
<?php
}
else
{
?>
<tr>
<td bgcolor=”#FFFFFF”>No record found! Try another time.</td>
</tr>
<?php
}
?>
</table>
<br>
<br>
<p align=”center”><span style=”font-weight:bold;”><?php echo “Search Result for:<br> $query_type_label = “${$query_type}””; ?></span></p>
<br>
<br>
<br>
</body>
</html>

<?php
include ‘footer_account.php’; //Required on all webpages of the Account.
?>
[/code]

But, when I added PREP STMT, the page goes blank and pulls no data from mysql db.
Why is that ? My attempt:

[code]
<?php
//Required PHP Files.
include ‘header_account.php’; //Required on all webpages of the Account.
?>

<?php
if (!$conn)
{
$error = mysqli_connect_error();
$errno = mysqli_connect_errno();
print “$errno: $errorn”;
exit();
}

//Grab Username of who’s Browsing History needs to be searched.

if (isset($_GET[‘followee_username’]) && !empty($_GET[‘followee_username’]))
{
$followee_username = $_GET[‘followee_username’];

if($followee_username != ‘followee_all’ OR $followee_username != ‘Followee_All’)
{
//$query_for_followee_browsing_histories= “SELECT * FROM browsing_histories WHERE username = “$followee_username””;
$followee_query_type = “followee_username”;
$followee_followed_word = “$followee_username”;

$query = “SELECT id,date_and_time,query_type,followed_word,query_string,browsed_page_original,browsed_page_converted,referral_page_original,referral_page_converted,username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,country_of_birth,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country FROM browsing_histories WHERE username = ?”;
$stmt = mysqli_prepare($conn,$query);
mysqli_stmt_bind_param($stmt,’s’,$followee_username);
mysqli_stmt_execute($stmt);
//Check if User’s details was successfully extracted or not from ‘details_contact_home’ tbl.
if (!$stmt)
{
echo “ERROR 3: Sorry! Our system is currently experiencing a problem logging you in!”;
exit();
}
else
{
$result = mysqli_stmt_bind_result($stmt,$followee_browsing_history_submission_id,$followee_browsing_history_submission_date_and_time,$followee_query_type,$followee_followed_word,$followee_query_string,$followee_browsed_page_original,$followee_browsed_page_converted,$followee_referral_page_original,$followee_referral_page_converted,$followee_username,$followee_gender,$followee_age_range,$followee_date_of_birth,$followee_skin_complexion,$followee_height,$followee_weight,$followee_sexual_orientation,$followee_religion,$followee_education,$followee_profession,$followee_marital_status,$followee_working_status,$followee_country_of_birth,$followee_home_town,$followee_home_neighbourhood,$followee_home_borough,$followee_home_council,$followee_home_city,$followee_home_county,$followee_home_district,$followee_home_region,$followee_home_state,$followee_home_country);
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
}
}
elseif($followee_username == ‘followee_all’ OR $followee_username == ‘Followee_All’)
{
$query= “SELECT * FROM browsing_histories”;
$followee_query_type = “followee_all”;
$followee_followed_word = “followee_all”;
echo “all”;
echo “all search”;
}
}

if (isset($_GET[‘followee_id’]) && !empty($_GET[‘followee_id’]))
{
$followee_id = $_GET[‘followee_id’];
//$query_for_followee_browsing_histories= “SELECT * FROM browsing_histories WHERE id = “$followee_id””;
$followee_query_type = “followee_id”;
$followee_followed_word = “$followee_id”;
echo “$followee_id”;
}

if (isset($_GET[‘followee_date_and_time’]) && !empty($_GET[‘followee_date_and_time’]))
{
$followee_date_and_time = $_GET[‘followee_date_and_time’];
$query= “SELECT * FROM browsing_histories WHERE date_and_time = “$followee_date_and_time””;
$followee_query_type = “followee_date_and_time”;
$followee_followed_word = “$followee_date_and_time”;
}

if (isset($_GET[‘followee_browsed_page_converted’]) && !empty($_GET[‘followee_browsed_page_converted’]))
{
$followee_browsed_page_converted = $_GET[‘followee_browsed_page_converted’];
$query= “SELECT * FROM browsing_histories WHERE browsed_page_converted = “$followee_browsed_page_converted””;
$followee_query_type = “followee_browsed_page_converted”;
$followee_followed_word = “$followee_browsed_page_converted”;
}

if (isset($_GET[‘followee_referral_page_converted’]) && !empty($_GET[‘followee_referral_page_converted’]))
{
$followee_referral_page_converted = $_GET[‘followee_referral_page_converted’];
$query= “SELECT * FROM browsing_histories WHERE referral_page_converted = “$followee_referral_page_converted””;
$followee_query_type = “followee_referral_page_converted”;
$followee_followed_word = “$followee_referral_page_converted”;

if (isset($_GET[‘followee_gender’]) && !empty($_GET[‘followee_gender’]))
{
$followee_gender = $_GET[‘followee_gender’];
$query= “SELECT * FROM browsing_histories WHERE gender = “$followee_gender””;
$followee_query_type = “followee_gender”;
$followee_followed_word = “$followee_gender”;
}

if (isset($_GET[‘followee_age_range’]) && !empty($_GET[‘followee_age_range’]))
{
$followee_age_range = $_GET[‘followee_age_range’];
$query= “SELECT * FROM browsing_histories WHERE age_range = “$followee_age_range””;
$followee_query_type = “followee_age_range”;
$followee_followed_word = “$followee_age_range”;
}

if (isset($_GET[‘followee_date_of_birth’]) && !empty($_GET[‘followee_date_of_birth’]))
{
$followee_date_of_birth = $_GET[‘followee_date_of_birth’];
$query= “SELECT * FROM browsing_histories WHERE date_of_birth = “$followee_date_of_birth””;
$followee_query_type = “followee_date_of_birth”;
$followee_followed_word = “$followee_date_of_birth”;
}

if (isset($_GET[‘followee_skin_complexion’]) && !empty($_GET[‘followee_skin_complexion’]))
{
$followee_skin_complexion = $_GET[‘followee_skin_complexion’];
$query= “SELECT * FROM browsing_histories WHERE skin_complexion = “$followee_skin_complexion””;
$followee_query_type = “followee_skin_complexion”;
$followee_followed_word = “$followee_skin_complexion”;
}

if (isset($_GET[‘followee_height’]) && !empty($_GET[‘followee_height’]))
{
$followee_height = $_GET[‘followee_height’];
$query= “SELECT * FROM browsing_histories WHERE height = “$followee_height””;
$followee_query_type = “followee_height”;
$followee_followed_word = “$followee_height”;
}

if (isset($_GET[‘followee_weight’]) && !empty($_GET[‘followee_weight’]))
{
$followee_weight = $_GET[‘followee_weight’];
$query= “SELECT * FROM browsing_histories WHERE weight = “$followee_weight””;
$followee_query_type = “followee_weight”;
$followee_followed_word = “$followee_weight”;
}

if (isset($_GET[‘followee_sexual_orientation’]) && !empty($_GET[‘followee_sexual_orientation’]))
{
$followee_sexual_orientation = $_GET[‘followee_sexual_orientation’];
$query= “SELECT * FROM browsing_histories WHERE sexual_orientation = “$followee_sexual_orientation””;
$followee_query_type = “followee_sexual_orientation”;
$followee_followed_word = “$followee_sexual_orientation”;
}

if (isset($_GET[‘followee_religion’]) && !empty($_GET[‘followee_religion’]))
{
$followee_religion = $_GET[‘followee_religion’];
$query= “SELECT * FROM browsing_histories WHERE religion = “$followee_religion””;
$followee_query_type = “followee_religion”;
$followee_followed_word = “$followee_religion”;
}

if (isset($_GET[‘followee_education’]) && !empty($_GET[‘followee_education’]))
{
$followee_education = $_GET[‘followee_education’];
$query= “SELECT * FROM browsing_histories WHERE education = “$followee_education””;
$followee_query_type = “followee_education”;
$followee_followed_word = “$followee_education”;
}

if (isset($_GET[‘followee_profession’]) && !empty($_GET[‘followee_profession’]))
{
$followee_profession = $_GET[‘followee_profession’];
$query= “SELECT * FROM browsing_histories WHERE profession = “$followee_profession””;
$followee_query_type = “followee_profession”;
$followee_followed_word = “$followee_profession”;
}

if (isset($_GET[‘followee_marital_status’]) && !empty($_GET[‘followee_marital_status’]))
{
$followee_marital_status = $_GET[‘followee_marital_status’];
$query= “SELECT * FROM browsing_histories WHERE marital_status = “$followee_marital_status””;
$followee_query_type = “followee_marital_status”;
$followee_followed_word = “$followee_marital_status”;
}

if (isset($_GET[‘followee_working_status’]) && !empty($_GET[‘followee_working_status’]))
{
$followee_working_status = $_GET[‘followee_working_status’];
$query= “SELECT * FROM browsing_histories WHERE working_status = “$followee_working_status””;
$followee_query_type = “followee_working_status”;
$followee_followed_word = “$followee_working_status”;
}

if (isset($_GET[‘followee_country_of_birth’]) && !empty($_GET[‘followee_country_of_birth’]))
{
$followee_country_of_birth = $_GET[‘followee_country_of_birth’];
$query= “SELECT * FROM browsing_histories WHERE country_of_birth = “$followee_country_of_birth””;
$followee_query_type = “followee_country_of_birth”;
$followee_followed_word = “$followee_country_of_birth”;
}

if (isset($_GET[‘followee_home_town’]) && !empty($_GET[‘followee_home_town’]))
{
$followee_home_town = $_GET[‘followee_home_town’];
$query= “SELECT * FROM browsing_histories WHERE home_town = “$followee_home_town””;
$followee_query_type = “followee_home_town”;
$followee_followed_word = “$followee_home_town”;
}

if (isset($_GET[‘followee_home_neighbourhood’]) && !empty($_GET[‘followee_home_neighbourhood’]))
{
$followee_home_neighbourhood = $_GET[‘followee_home_neighbourhood’];
$query= “SELECT * FROM browsing_histories WHERE home_neighbourhood = “$followee_home_neighbourhood””;
$followee_query_type = “followee_home_neighbourhood”;
$followee_followed_word = “$followee_home_neighbourhood”;
}

if (isset($_GET[‘followee_home_borough’]) && !empty($_GET[‘followee_home_borough’]))
{
$followee_home_borough = $_GET[‘followee_home_borough’];
$query= “SELECT * FROM browsing_histories WHERE home_borough = “$followee_home_borough””;
$followee_query_type = “followee_home_borough”;
$followee_followed_word = “$followee_home_borough”;
}

if (isset($_GET[‘followee_home_city’]) && !empty($_GET[‘followee_home_city’]))
{
$followee_home_city = $_GET[‘followee_home_city’];
$query= “SELECT * FROM browsing_histories WHERE home_city = “$followee_home_city””;
$followee_query_type = “followee_home_city”;
$followee_followed_word = “$followee_home_city”;
}

if (isset($_GET[‘followee_home_county’]) && !empty($_GET[‘followee_home_county’]))
{
$followee_home_county = $_GET[‘followee_home_county’];
$query= “SELECT * FROM browsing_histories WHERE home_county = “$followee_home_county””;
$followee_query_type = “followee_home_county”;
$followee_followed_word = “$followee_home_county”;
}

if (isset($_GET[‘followee_home_district’]) && !empty($_GET[‘followee_home_district’]))
{
$followee_home_district = $_GET[‘followee_home_district’];
$query= “SELECT * FROM browsing_histories WHERE home_district = “$followee_home_district””;
$followee_query_type = “followee_home_district”;
$followee_followed_word = “$followee_home_district”;
}

if (isset($_GET[‘followee_home_region’]) && !empty($_GET[‘followee_home_region’]))
{
$followee_home_region = $_GET[‘followee_home_region’];
$query= “SELECT * FROM browsing_histories WHERE home_region = “$followee_home_region””;
$followee_query_type = “followee_home_region”;
$followee_followed_word = “$followee_home_region”;
}

if (isset($_GET[‘followee_home_state’]) && !empty($_GET[‘followee_home_state’]))
{
$followee_home_state = $_GET[‘followee_home_state’];
$query= “SELECT * FROM browsing_histories WHERE home_state = “$followee_home_state””;
$followee_query_type = “followee_home_state”;
$followee_followed_word = “$followee_home_state”;
}

if (isset($_GET[‘followee_home_country’]) && !empty($_GET[‘followee_home_country’]))
{
$followee_home_country = $_GET[‘followee_home_country’];
$query= “SELECT * FROM browsing_histories WHERE home_country = “$followee_home_country””;
$followee_query_type = “followee_home_country”;
$followee_followed_word = “$followee_home_country”;
}

$referral_page_http = $_SERVER[‘HTTP_REFERRER’];
$referral_page = “$referral_page_http”;
$referral_page_original = “$referral_page”;

$query_string = $_SERVER[‘QUERY_STRING’];

$current_page_http = $_SERVER[‘PHP_SELF’];
$current_page = “$current_page_http”;

$followed_page_original = “$current_page”;

$visiting_pages_count = “1”;
if($visiting_pages_count == “”)
{
$visiting_pages_count = “1”;
}
else
{
$visiting_pages_count++;
}

if($visiting_pages_count == “1”)
{
$current_page_converted = “$settings_user_first_quick_link.$current_page”;
$referral_page_converted = “$settings_user_first_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “2”)
{
$current_page_converted = “$settings_admin_second_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_second_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “3”)
{
$current_page_converted = “$settings_user_third_quick_link.$current_page”;
$referral_page_converted = “$settings_user_third_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “4”)
{
$current_page_converted = “$settings_admin_fourth_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_fourth_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “5”)
{
$current_page_converted = “$settings_user_fifth_quick_link.$current_page”;
$referral_page_converted = “$settings_user_fifth_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “6”)
{
$current_page_converted = “$settings_admin_first_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_first_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “7”)
{
$current_page_converted = “$settings_user_second_quick_link.$current_page”;
$referral_page_converted = “$settings_user_second_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “8”)
{
$current_page_converted = “$settings_admin_third_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_third_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “9”)
{
$current_page_converted = “$settings_user_fourth_quick_link.$current_page”;
$referral_page_converted = “$settings_user_fourth_quick_link.$referral_page”;
}
elseif($visiting_pages_count == “10”)
{
$current_page_converted = “$settings_admin_fifth_quick_link.$current_page”;
$referral_page_converted = “$settings_admin_fifth_quick_link.$referral_page”;
}
/*elseif($visiting_pages_count = “1”)
{
$current_page_converted = “$settings_user_first_quick_link.$current_page”;
$referral_page_converted = “$settings_user_first_quick_link.$referral_page”;
}
*/
else
{
$visiting_pages_count = “1”;
$current_page_converted = “$settings_user_first_quick_link.$current_page”;
$referral_page_converted = “$settings_user_first_quick_link.$referral_page”;
}

$followed_page_converted = “$current_page_converted”;

$follower_username = $user;
$follower_browser = $_SERVER[‘HTTP_USER_AGENT’];

//Insert the User’s Click Logs into Mysql Database using Php’s Sql Injection Prevention Method “Prepared Statements”.
$stmt = mysqli_prepare($conn,”INSERT INTO following_histories(query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,country_of_birth,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)”);
mysqli_stmt_bind_param($stmt,’ssssssssssiissssssssssssssssssss’,$followee_query_type,$followee_followed_word,$followee_query_string,$followee_browsed_page_original,$followee_browsed_page_converted,$followee_referral_page_original,$followee_referral_page_converted,$followee_username,$username,$gender,$age_range,$date_of_birth,$skin_complexion,$height,$weight,$sexual_orientation,$religion,$education,$profession,$marital_status,$working_status,$country_of_birth,$home_town,$home_neighbourhood,$home_borough,$home_council,$home_city,$home_county,$home_district,$home_region,$home_state,$home_country); mysqli_stmt_bind_param($stmt,’ssssssssssiissssssssssssssssssss’,$followee_query_type,$followee_followed_word,$followee_query_string,$followee_browsed_page_original,$followee_browsed_page_converted,$followee_referral_page_original,$followee_referral_page_converted,$followee_username,$follower_username,$follower_gender,$follower_age_range,$follower_date_of_birth,$follower_skin_complexion,$follower_height,$follower_weight,$follower_sexual_orientation,$follower_religion,$follower_education,$follower_profession,$follower_marital_status,$follower_working_status,$follower_country_of_birth,$follower_home_town,$follower_home_neighbourhood,$follower_home_borough,$follower_home_council,$follower_home_city,$follower_home_county,$follower_home_district,$follower_home_region,$follower_home_state,$follower_home_country);
mysqli_stmt_execute($stmt);

//Check if User’s Click Logs have been successfully submitted or not.
if (!$stmt)
{
echo “Sorry! Our system is currently experiencing a problem logging your following! We will continuously try logging your clicks!”;
exit();
}
else
{
mysqli_stmt_fetch($stmt);
//mysqli_stmt_close($stmt);
}

$followee_query_type_label = str_replace(“_”,” “,”$followee_query_type”); //Removing underscores so they don’t show-up on the html.
$followee_query_type_label = ucwords(“$followee_query_type_label”); //Upper Casing the first characters.
?>

<!DOCTYPE html>
<html>
<head>
<meta content=”text/html; charset=ISO-8859-1″ http-equiv=” content-type”>
<title><?php echo “Browsing History in $server_time Time.”;?></title>
<meta name=”viewport” content=”width=device-width, initial-scale=1″>
</head>
<body>
<br>
<p align=”center”><span style=”font-weight:bold;”><?php echo “Search Result for:<br> $followee_query_type_label = “${$followee_query_type}””; ?></span></p>
<br>
<br>
<?php
$result = mysqli_query($conn,$query);
$rows_num = mysqli_num_rows($result);

//Total Number of Pages records are spread-over.
$page_count = 100;
$page_size = ceil($rows_num / $page_count);
//Get the Page Number. Default is 1 (First Page).
$page_number = $_GET[“page_number”];
if ($page_number == “”) $page_number = 1;
$offset = ($page_number -1) * $page_size;

$query.= ” limit {$offset},{$page_size}”;
$result = mysqli_query($conn,$query);
?>
<table width=”1500″ border=”0″ cellpadding=”5″ cellspacing=”2″ bgcolor=”#666666″>
<?php
if(!$result)
{
?>
<tr>
<td bgcolor=”#FFFFFF”>No record found! Try another time.</td>
</tr>
<?php
}
else
{
printf(“<b> %d Result Found …</b>n”,$rows_num); ?><br>
<br>
<tr name=”headings”>
<td bgcolor=”#FFFFFF” name=”column-heading_submission-number”>Submission Number</td>
<td bgcolor=”#FFFFFF” name=”column-heading_logging-server-date-and-time”>Date & Time in <?php echo “$server_time”;?></td>
<td bgcolor=”#FFFFFF” name=”column-heading_browsed-page-converted”>Browsed Page Converted (Visit Page) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_browsed-page-converted”>Browsed Page Converted (Check Stats) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_referral-page-converted”>Referral Page Converted (Visit Page) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_referral-page-converted”>Referral Page Converted (Check Stats) </td>
<td bgcolor=”#FFFFFF” name=”column-heading_username”>Followee Username (Visit Page)</td>
<td bgcolor=”#FFFFFF” name=”column-heading_username”>Followee Username (Check Stats)</td>
<td bgcolor=”#FFFFFF” name=”column-heading_gender”>Followee Gender</td>
<td bgcolor=”#FFFFFF” name=”column-heading_age-range”>Followee Age Range</td>
<td bgcolor=”#FFFFFF” name=”column-heading_date-of-birth”>Followee Date Of Birth</td>
<td bgcolor=”#FFFFFF” name=”column-heading_skin-complexion”>Followee Skin Complexion</td>
<td bgcolor=”#FFFFFF” name=”column-heading_height”>Followee Height</td>
<td bgcolor=”#FFFFFF” name=”column-heading_weight”>Followee Weight</td>
<td bgcolor=”#FFFFFF” name=”column-heading_sexual-orientation”>Followee Sexual Orientation</td>
<td bgcolor=”#FFFFFF” name=”column-heading_religion”>Followee Religion</td>
<td bgcolor=”#FFFFFF” name=”column-heading_education”>Followee Education</td>
<td bgcolor=”#FFFFFF” name=”column-heading_profession”>Followee Profession</td>
<td bgcolor=”#FFFFFF” name=”column-heading_marital-status”>Followee Marital Status</td>
<td bgcolor=”#FFFFFF” name=”column-heading_working-status”>Followee Working Status</td>
<td bgcolor=”#FFFFFF” name=”column-heading_country-of-birth”>Followee Country Of Birth</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-town”>Followee Home Town</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-neighbourhood”>Followee Home Neighbourhood</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-borough”>Followee Home Borough</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-city”>Followee Home City</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-county”>Followee Home County</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-district”>Followee Home District</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-region”>Followee Home Region</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-state”>Followee Home State</td>
<td bgcolor=”#FFFFFF” name=”column-heading_home-country”>Followee Home Country</td>
</tr>
<?php //while($row = mysqli_fetch_array($result))
//while(mysqli_stmt_fetch($result)) //Should this be $result” or “stmt” ?
while(mysqli_stmt_fetch($stmt))
{
?>
<tr name=”user-details”>
<td bgcolor=”#FFFFFF” name=”submission-number”><a href=”browsing_histories_v1.php?followee_id=<?php echo “$followee_browsing_history_submission_id”; ?>&page_number=1″><?php echo “$followee_browsing_history_submission_id”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”logging-server-date-&-time”><a href=”browsing_histories_v1.php?followee_date_and_time=<?php echo “$followee_browsing_history_submission_date_and_time”; ?>&page_number=1″><?php echo “$followee_browsing_history_submission_date_and_time”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”browsed-page-converted_visit-page”><a href=”<?php echo “followee_browser.php?followee_username=$followee_username&followee_browsed_page_converted=$followee_browsed_page_converted”; ?>”><?php echo “$followee_browsed_page_converted”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”browsed-page-converted_stats-page”><a href=”browsing_histories_v1.php?followee_browsed_page_converted=<?php echo “$followee_browsed_page_converted”; ?>&page_number=1″><?php echo “$followee_browsed_page_converted”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”referral-page-converted_visit-page”><a href=”<?php echo “followee_browser.php?followee_username=$followee_username&followee_referral_page_converted=$followee_referral_page_converted”; ?>”><?php echo “$followee_referral_page_converted”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”referral-page-converted_stats-page”><a href=”browsing_histories_v1.php?followee_referral_page_converted=<?php echo “$followee_referral_page_converted”; ?>&page_number=1″><?php echo “$followee_referral_page_converted”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profile-page_visit-page”><a href=”profile.php?followee_username=<?php echo “$followee_username”; ?>”><?php echo “$followee_username”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profile-page_stats-page”><a href=”browsing_histories_v1.php?followee_username=<?php echo “$followee_username”; ?>&page_number=1″><?php echo “$followee_username”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”gender”><a href=”browsing_histories_v1.php?followee_gender=<?php echo “$followee_gender”; ?>&page_number=1″><?php echo “$followee_gender”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”age-range”><a href=”browsing_histories_v1.php?followee_age_range=<?php echo “$followee_age_range”; ?>&page_number=1″><?php echo “$followee_age_range”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”date-of-birth”><a href=”browsing_histories_v1.php?followee_date_of_birth=<?php echo “$followee_date_of_birth”; ?>&page_number=1″><?php echo “$followee_date_of_birth”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”skin-complexion”><a href=”browsing_histories_v1.php?followee_skin_complexion=<?php echo “$followee_skin_complexion”; ?>&page_number=1″><?php echo “$followee_skin_complexion”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”height”><a href=”browsing_histories_v1.php?followee_height=<?php echo “$followee_height”; ?>&page_number=1″><?php echo “$followee_height”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”weight”><a href=”browsing_histories_v1.php?followee_height=<?php echo “$followee_weight”; ?>&page_number=1″><?php echo “$followee_weight”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”sexual-orientation”><a href=”browsing_histories_v1.php?followee_sexual_orientation=<?php echo “$followee_sexual_orientation”; ?>&page_number=1″><?php echo “$followee_sexual_orientation”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”religion”><a href=”browsing_histories_v1.php?followee_religion=<?php echo “$followee_religion”; ?>&page_number=1″><?php echo “$followee_religion”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”education”><a href=”browsing_histories_v1.php?followee_education=<?php echo “$followee_education”; ?>&page_number=1″><?php echo “$followee_education”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”profession”><a href=”browsing_histories_v1.php?followee_profession=<?php echo “$followee_profession”; ?>&page_number=1″><?php echo “$followee_profession”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”marital-status”><a href=”browsing_histories_v1.php?followee_marital_status=<?php echo “$followee_marital_status”; ?>&page_number=1″><?php echo “$followee_marital_status”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”working-status”><a href=”browsing_histories_v1.php?followee_working_status=<?php echo “$followee_working_status”; ?>&page_number=1″><?php echo “$followee_working_status”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”country-of-birth”><a href=”browsing_histories_v1.php?followee_country_of_birth=<?php echo “$followee_country_of_birth”; ?>&page_number=1″><?php echo “$followee_country_of_birth”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-town”><a href=”browsing_histories_v1.php?followee_home_town=<?php echo “$followee_home_town”; ?>&page_number=1″><?php echo “$followee_home_town”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-neighbourhood”><a href=”browsing_histories_v1.php?followee_home_neighbourhood=<?php echo “$followee_home_neighbourhood”; ?>&page_number=1″><?php echo “$followee_home_neighbourhood”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-borough”><a href=”browsing_histories_v1.php?followee_home_borough=<?php echo “$followee_home_borough”; ?>&page_number=1″><?php echo “$followee_home_borough”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-city”><a href=”browsing_histories_v1.php?followee_home_city=<?php echo “$followee_home_city”; ?>&page_number=1″><?php echo “$followee_home_city”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-county”><a href=”browsing_histories_v1.php?followee_home_county=<?php echo “$followee_home_county”; ?>&page_number=1″><?php echo “$followee_home_county”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-district”><a href=”browsing_histories_v1.php?followee_home_district=<?php echo “$followee_home_district”; ?>&page_number=1″><?php echo “$home_district”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-region”><a href=”browsing_histories_v1.php?followee_home_region=<?php echo “$followee_home_region”; ?>&page_number=1″><?php echo “$followee_home_region”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-state”><a href=”browsing_histories_v1.php?followee_home_state=<?php echo “$followee_home_state”; ?>&page_number=1″><?php echo “$followee_home_state”; ?></a></td>
<td bgcolor=”#FFFFFF” name=”home-country”><a href=”browsing_histories_v1.php?followee_home_country=<?php echo “$followee_home_country”; ?>&page_number=1″><?php echo “$followee_home_country”; ?></a></td>
</tr>
<?php
}
?>
<tr name=”pagination”>
<td colspan=”30″ bgcolor=”#FFFFFF”> Result Pages:
<?php
if($rows_num <= $page_size)
{
echo “Page 1”;
}
else
{
for($i=1;$i<=$page_count;$i++)
echo “<a href=”{$_SERVER[‘PHP_SELF’]}?$followee_query_type=${$followee_query_type}&page_number={$i}”>{$i}</a> “;
}
?>
</td>
</tr>
<?php
} }
?>
</table>
<br>
<br>
<br>
<br>
<br>
</body>
</html>

<?php
include ‘footer_account.php’; //Required on all webpages of the Account.
?>
[/code]

Can someone be kind enough to show me how to code this to fix it ?

Also in #PHP _↴