Помогите пожалуйста с кодом

PHP:

1.    
2. $sql = "SELECT SUM(image_hits) AS sum
3.          FROM ".IMAGES_TABLE;
4.   $row = $site_db->query_firstrow($sql);
5.  
6.   $sum = (isset($row['sum'])) ? $row['sum'] : 0;
7.   $total_hits = "".$lang['total_hits']."<B> ".$row['sum']."</B>\n";
8.  
9.   $site_template->register_vars("total_hits", $total_hits);
10. unset($total_hits);

Данный код выводит сумму просмотров всех фотографий. Мне нужно вывести сумму просмотров фото, одного человека. Помогите пожалуйста. Я не очень силен в программировании. Спасибо!

 

5images_users:
user_id
user_level
user_name
user_t_images и т.д.

5images_images:
image_id
cat_id
user_id
image_name
image_description
image_hits и т.д.

Если правильно Вас понял

 

Ensiferum, Спасибо разобрался. А как сделать список пользователей, с сортировкой по количеству просмотров???

например LIMIT 10

 

PHP:

1. $sql = "SELECT u.user_name FROM 5images_users u
2.        LEFT JOIN 5images_images i ON (i.user_id = u.user_id)
3.        ORDER BY SUM(i.image_hits) DESC
4.        LIMIT 10";
5.   $row = $site_db->query_firstrow($sql);
6.  
7.   $sum = (isset($row['sum'])) ? $row['sum'] : 0;
8.   $total_hits = "".$lang['total_user_hits']."<B> ".$row['sum']."</B>\n";
9.  
10.   $site_template->register_vars("total_user_hits", $total_user_hits);
11. unset($total_user_hits);

Получилось так... Ошибка: Notice: Undefined index: sum in .../includes/page_header.php on line 858

 

А именно "sum" ? А куда его добавить?

 

У меня не выводится результат =(

 

Notice: Undefined index: sum in .../includes/page_header.php on line 858

 

Ой блин )))) там стока писанины выдает )) вкратце: ERROR: Could not load configuration settings
PLEASE MAKE SURE YOU INSTALL THE BOARD ! и еще очень много всего!

 

array(2) {
[0]=>
string(5) "Guest"
["user_name"]=>
string(5) "Guest"
}



array(805) {
["no_settings"]=>
string(45) "ERROR: Could not load configuration settings!"
["captcha"]=>
string(18) "Verification code:"
["captcha_desc"]=>
string(134) "Please enter the letters or digits that appear in the image. If you have problems identifying the image, click on it to get a new one."
["captcha_required"]=>
string(35) "Please enter the verification code."
["charset"]=>
string(10) "iso-8859-1"
["direction"]=>
string(3) "ltr"
["userlevel_admin"]=>
string(5) "Admin"
["userlevel_user"]=>
string(6) "Member"
["userlevel_guest"]=>
string(5) "Guest"
["no_categories"]=>
string(20) "No categories found."
["no_images"]=>
string(37) "There are no images in this category."
["select_category"]=>
string(15) "Select category"
["name_required"]=>
string(20) "Please enter a name."
["headline_required"]=>
string(24) "Please enter a headline."
["comment_required"]=>
string(21) "Please add a comment."
["spamming"]=>
string(64) "You cannot repost so soon, please try again after a short while."
["comments"]=>
string(9) "Comments:"
["no_comments"]=>
string(36) "There are no comments for this image"
["comments_deactivated"]=>
string(20) "Comment deactivated!"
["post_comment"]=>
string(12) "Post comment"
["comment_success"]=>
string(27) "Your comment has been saved"
["bbcode"]=>
string(6) "BBCode"
["tag_prompt"]=>
string(31) "Enter the text to be formatted:"
["link_text_prompt"]=>
string(54) "Enter the text to be displayed for the link (optional)"
["link_url_prompt"]=>
string(31) "Enter the full URL for the link"
["link_email_prompt"]=>
string(36) "Enter the email address for the link"
["list_type_prompt"]=>
string(143) "What type of list do you want? Enter '1' for a numbered list, enter 'a' for an alphabetical list, or leave blank for a list with bullet points."
["list_item_prompt"]=>
string(78) "Enter a list item. Leave the box empty or click 'Cancel' to complete the list."
["download_error"]=>
string(15) "Download error!"
["register_download"]=>
string(100) "Please register to download images.
» Register now"
["prev_image"]=>
string(15) "Previous image:"
["next_image"]=>
string(11) "Next image:"
["category"]=>
string(15) "Spotting Group:"
["description"]=>
string(11) "Description"
["keywords"]=>
string(9) "Keywords:"
["date"]=>
string(5) "Date:"
["hits"]=>
string(5) "Hits:"
["downloads"]=>
string(10) "Downloads:"
["rating"]=>
string(6) "Rating"
["votes"]=>
string(7) "Vote(s)"
["file_size"]=>
string(10) "File size:"
["author"]=>
string(7) "Author:"
["name"]=>
string(5) "Name:"
["headline"]=>
string(9) "Headline:"
["comment"]=>
string(8) "Comment:"
["added_by"]=>
string(9) "Added by:"
["allow_comments"]=>
string(15) "Allow comments:"
["iptc_caption"]=>
string(8) "Caption:"
["iptc_caption_writer"]=>
string(15) "Caption writer:"
["iptc_headline"]=>
string(9) "Headline:"
["iptc_special_instructions"]=>
string(21) "Special instructions:"
["iptc_byline"]=>
string(7) "Byline:"
["iptc_byline_title"]=>
string(13) "Byline title:"
["iptc_credit"]=>
string(7) "Credit:"
["iptc_source"]=>
string(7) "Source:"
["iptc_object_name"]=>
string(12) "Object name:"
["iptc_date_created"]=>
string(13) "Date created:"
["iptc_city"]=>
string(5) "City:"
["iptc_state"]=>
string(6) "State:"
["iptc_country"]=>
string(8) "Country:"
["iptc_original_transmission_reference"]=>
string(32) "Original transmission reference:"
["iptc_category"]=>
string(9) "Category:"
["iptc_supplemental_category"]=>
string(22) "Supplemental category:"
["iptc_keyword"]=>
string(9) "Keywords:"
["iptc_copyright_notice"]=>
string(17) "Copyright Notice:"
["exif_Make"]=>
string(11) "Hersteller:"
["exif_Model"]=>
string(7) "Modell:"
["exif_DateTimeOriginal"]=>
string(24) "Aufnahme,Datum und Zeit:"
["exif_ISOSpeedRatings"]=>
string(9) "ISO Wert:"
["exif_ExposureTime"]=>
string(16) "Belichtungszeit:"
["exif_FNumber"]=>
string(7) "Blende:"
["exif_FocalLength"]=>
string(22) "Brennweite (Objektiv):"
["exif_ExposureBiasValue"]=>
string(22) "Belichtungsabweichung:"
["exif_ApertureValue"]=>
string(20) "Blendenoffnungswert:"
["exif_MaxApertureValue"]=>
string(30) "Maximaler Blendenoffnungswert:"
["exif_MeteringMode"]=>
string(19) "Belichtungsmessung:"
["exif_Flash"]=>
string(6) "Blitz:"

 

PHP:

1.    echo "<pre>\n";
2.    $sql = "SELECT u.user_name FROM 5images_users u
3.          LEFT JOIN 5images_images i ON (i.user_id = u.user_id)
4.          ORDER BY SUM(i.image_hits) DESC
5.          LIMIT 10";
6. echo "+++row+++\n";
7. var_dump($row);
8. echo "+++row+++\n\n\n";
9. $row = $site_db->query_firstrow($sql);
10. echo "+++row+++\n";
11. var_dump($row);
12. echo "+++row+++\n\n\n";
13. $sum = (isset($row['sum'])) ? $row['sum'] : 0;
14. echo "+++lang+++\n";
15. var_dump($lang);
16. echo "+++lang+++\n\n\n";
17. $total_user_hits = "".$lang['total_user_hits']."<B> ".$row['sum']."</B>\n";
18.  
19. $site_template->register_vars("total_user_hits", $total_user_hits);
20. unset($total_user_hits);

Нет все равно много также писанины

 

в итоге писанины Notice: Undefined index: sum in /includes/page_header.php on line 865

Не помещается все =)