Using image tags on a custom page.

[Sun Zaza]

Oke, almost done.

The additional user field Hobby is now showing, but in my query I ask only for the hobby of the user_id = 2 (not for the first 20 users 'LIMIT 20";').

The results was 20 users with their hobbies.

I think we have to fix the query:

Code: [Select]

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_date, i.image_active, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".USERS_TABLE." u, ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        WHERE i.user_id = 2
        ORDER BY i.user_id DESC
        LIMIT 20";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);

[thunderstrike]

Change:

Code: [Select]

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_date, i.image_active, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".USERS_TABLE." u, ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        WHERE i.user_id = 2
        ORDER BY i.user_id DESC
        LIMIT 20";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);

for:

Code: [Select]

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_date, i.image_active, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN " . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = i.user_id)
        WHERE i.user_id = 2
        ORDER BY i.user_id DESC
        LIMIT 20";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);


[Sun Zaza]

Now I get the same user (+hobby) 20 times instead of 1 time!

[thunderstrike]

Please post full code in bbcode.

[Sun Zaza]

Code: [Select]

<?php
$main_template = 'special3';

define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$allowed_users_access_page = array(2); // Change for all user ID need.
if (function_exists('check_for_valid_user_access_page') && !check_for_valid_user_access_page($allowed_users_access_page) && $user_info['user_level'] < ADMIN) {
   redirect($url);
}
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');
include(ROOT_PATH.'includes/stats.php');

            $additional_sql = "";
if (!empty($additional_image_fields)) {
  foreach ($additional_image_fields as $key => $val) {
    $additional_sql .= ", i.".$key;
  }
}

if (isset($additional_user_fields) && is_array($additional_user_fields) && !empty($additional_user_fields)) {
   foreach ($additional_user_fields as $key => $val) {
      $additional_sql .= ", u.".$key;
   }
}

 //Hobby

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_date, i.image_active, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN " . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = i.user_id)
        WHERE i.user_id = 1
        ORDER BY i.user_id DESC
        LIMIT 20";
$result = $site_db->query($sql); 
$num_rows = $site_db->get_numrows($result); 

if (!$num_rows)  { 
   $hobby = $lang['no_images']; 
} 
else  {
   $hobby = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\"><tr><td>User Name</td><td></td><td>User hobby</td></tr>";
   

   while ($user_row = $site_db->fetch_array($result)){ 
   $hobby .= "<tr><td>".format_text(trim($user_row[$user_table_fields['user_name']]), 2)."</a></td><td>".$user_row['user_hobby']."</td</td></tr>";
} 
} 
  $hobby .= "</table>\n";
$site_template->register_vars("hobby", $hobby); 
unset($hobby);

//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator']."Special"."</span>";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "clickstream" => $clickstream,
  

));
$site_template->print_template($site_template->parse_template($main_template));

include(ROOT_PATH.'includes/page_footer.php');
?>

[thunderstrike]

Ok so if want for show user name and hobby only for upload user - is this:

Code: [Select]

$sql = "SELECT " . get_user_table_field("u.", "user_name") . $additional_sql . "
        FROM ".IMAGES_TABLE." i
        LEFT JOIN " . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = i.user_id)
        WHERE i.user_id = 1
        GROUP BY i.user_id
        ORDER BY i.user_id DESC
        LIMIT 20";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);


[Sun Zaza]

I get this error:

DB Error: Bad SQL Query: SELECT , u.user_name....
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' u.user_name, i.image..at line 1

[thunderstrike]

This is right - post edit.

[Sun Zaza]

The same error again!!

[thunderstrike]

Ok try now.

[Sun Zaza]

Perfect for upload users , but what about the normal users? (They did not upload anything)
Can I use the same query?

[thunderstrike]

I no get ... full detail ?

[Sun Zaza]

You said:

Ok so if want for show user name and hobby only for upload user - is this:

only for upload user, I understand that this query look ONLY for the users hoe upload images to the gallery. right?

[thunderstrike]

Yes ... this is right ... but no get new question ...

[Sun Zaza]

Oke, listen:

You are a user on my gallery and you have NEVER uploaded an image in this gallery. Clear?

If I use this query to look for the hobby of Thunderstrike. Do I get as results your name and your hobby?
Do not forget, you have NEVER NEVER uploaded an image into my gallery?