Personal Profiles on ThePoeticLink.com"; print "

To Write to me, simply send mail to: "; print "Webmaster@ThePoeticLink.com "; print "I will do all I can to help you if you are having a problem with your profile.

"; print "

Click Here "; print "to add your Own Personal Profile Information to The Poetic Link now!
"; print "Click Here "; print "for instructions on adding your Picture to the internet if you do NOT already know how!


"; include "return_tag.html"; if (!isset($colby)) {$colby = 'u_profile_date';} if (!isset($sortby)) {$sortby = 'desc';} $old1 = ""; $old2 = ""; $sort1 = "$colby" . "-" . "$sortby"; $sort2 = $old1; $sort3 = $old2; if ($sort2 == "") $mastersort = "$sort1"; else if ($sort3 == "") $mastersort = "$sort1," . "-" . "$sort2"; else $mastersort = "$sort1," . "-" . "$sort2," . "-" . "$sort3"; $tmastersort = str_replace( "-", " ", $mastersort); $result = mysqli_query($con,"SELECT * FROM users where (u_profile <> '' or u_url <> '' or u_picture <> '' or u_song_url <> '' or u_song_title <> '') order by $tmastersort "); $totitems = mysqli_num_rows($result); if (!isset($limit)) $limit = 0; else $mastersort = $limitsort; $tmastersort = str_replace( "-", " ", $mastersort); $result = mysqli_query($con,"SELECT * FROM users where (u_profile <> '' or u_url <> '' or u_picture <> '' or u_song_url <> '' or u_song_title <> '') order by $tmastersort limit $limit, $maxdisplaylimit"); if ($row = mysqli_fetch_array($result)) { show_ranges($limit, $maxdisplaylimit, $totitems, $mastersort, "User Profiles", "view_profiles.php3", ""); print "

Click Any of these Sort Options to Re-Sort the Profile List below any way you choose.
"; print ""; print ""; do { $profile = $row["u_profile"]; $url = $row["u_url"]; $picture = $row["u_picture"]; $song = $row["u_song_url"]; $s_title = $row["u_song_title"]; $profile_date = $row["u_profile_date"]; $has_profile = "no"; $has_url = "no"; $has_picture = "no"; $has_song_url = "no"; $has_song_title = "no"; if ($profile <> "") $has_profile = "yes"; if ($url <> "") $has_url = "yes"; if ($picture <> "") $has_picture = "yes"; if ($song <> "") $has_song_url = "yes"; if ($s_title <> "") $has_song_title = "yes"; print ""; } while($row = mysqli_fetch_array($result)); print ""; print "
"; $tmp = "view_profiles.php3?colby=u_fullname&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_fullname&sortby=desc&old1=$sort1&old2=$sort2"; print "Poet Name Asc
Poet Name Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_profile_date&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_profile_date&sortby=desc&old1=$sort1&old2=$sort2"; print "Updated Asc
Uddated Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_profile&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_profile&sortby=desc&old1=$sort1&old2=$sort2"; print "Profiles Asc
Profiles Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_url&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_url&sortby=desc&old1=$sort1&old2=$sort2"; print "WebPage Asc
WebPage Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_picture&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_picture&sortby=desc&old1=$sort1&old2=$sort2"; print "Picture Asc
Picture Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_song_url&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_song_url&sortby=desc&old1=$sort1&old2=$sort2"; print "Song URL Asc
Song URL Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_song_title&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_song_title&sortby=desc&old1=$sort1&old2=$sort2"; print "Song Title Asc
Song Title Desc"; print "
"; $fullname = $row["u_fullname"]; $poet_id = $row["u_id"]; print "$fullname"; print ""; print $profile_date; print ""; print $has_profile; print ""; print $has_url; print ""; print $has_picture; print ""; print $has_song_url; print ""; print $has_song_title; print "
"; $tmp = "view_profiles.php3?colby=u_fullname&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_fullname&sortby=desc&old1=$sort1&old2=$sort2"; print "Poet Name Asc
Poet Name Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_profile_date&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_profile_date&sortby=desc&old1=$sort1&old2=$sort2"; print "Updated Asc
Uddated Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_profile&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_profile&sortby=desc&old1=$sort1&old2=$sort2"; print "Profiles Asc
Profiles Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_url&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_url&sortby=desc&old1=$sort1&old2=$sort2"; print "WebPage Asc
WebPage Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_picture&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_picture&sortby=desc&old1=$sort1&old2=$sort2"; print "Picture Asc
Picture Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_song_url&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_song_url&sortby=desc&old1=$sort1&old2=$sort2"; print "Song URL Asc
Song URL Desc"; print "
"; $tmp = "view_profiles.php3?colby=u_song_title&sortby=asc&old1=$sort1&old2=$sort2"; $tmp2 = "view_profiles.php3?colby=u_song_title&sortby=desc&old1=$sort1&old2=$sort2"; print "Song Title Asc
Song Title Desc"; print "
"; print "Click Any of these Sort Options to Re-Sort the Profile List above any way you choose.

"; show_ranges($limit, $maxdisplaylimit, $totitems, $mastersort, "User Profiles", "view_profiles.php3", ""); print "

Click Here "; print "to add your Own Personal Profile Information to The Poetic Link now!
"; print "Click Here "; print "for instructions on adding your Picture to the internet if you do NOT already know how!


"; include "return_tag.html"; } else { print "Sorry, no User Profiles were found!"; include "return_tag.html"; } ?>