Author Topic: Number of user photos in profile with link.  (Read 2861 times)

0 Members and 1 Guest are viewing this topic.

Offline milanNN

  • Newbie
  • *
  • Posts: 40
    • View Profile
    • http://www.planesphotos.net
Number of user photos in profile with link.
« on: February 17, 2012, 07:55:44 PM »
How can i show total number of user photos with the  link in profile?

Sorry i have already found
in member.php
$sql = "SELECT COUNT(image_id) AS totimg
         FROM ".IMAGES_TABLE."
         WHERE  user_id = $user_id";
    $result = $site_db->query($sql);
   $row = $site_db->fetch_array($result);
   $uploaded_images = $row['totimg'];
    $site_template->register_vars(array(
         "uploaded_imgs" => $uploaded_images,
in Member_profile.html past
<tr>
     <td class="row1"><b>{lang_user_photos}</b></td>
     <td class="row1"><A href="{url_show_user_images}">{uploaded_imgs}</a></td>
</tr>
« Last Edit: February 17, 2012, 08:37:35 PM by milanNN »

Rembrandt

  • Guest