New Pics in Category

[gti-the-sexy]

how could I list the "new added images" for all categories, not for one by one category

for example last 20 added images list for all "4images"

thanks to SLL and Christ

[SLL]

just remove if ($images_in_category) {
   echo "Found <b>$images_in_category</b> new images in category <b>$category_name</b>&nbsp;&nbsp;&nbsp;$category_link ...view category </a><br>";}

At the very end you could write something like echo "Total: $total_images_found found";

[ChrisTTian]

gti-the-sexy

glad that my pm was some help for you

christian

[gti-the-sexy]

ok then my last question

this code gives me last x images for x times
but I want it to give me last x images for 1 time

Code: [Select]


<?php 

define&#40;'ROOT_PATH', './'&#41;; 
include&#40;ROOT_PATH.'global.php'&#41;; 
require&#40;ROOT_PATH.'includes/sessions.php'&#41;; 
$user_access = get_permission&#40;&#41;; 
$cat_id_sql = get_auth_cat_sql&#40;"auth_viewcat", "NOTIN"&#41;; 
$number_of_news = 5; 

$sql = "SELECT i.image_name, i.image_id, i.image_date, c.cat_name, u.user_name 
        FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c, ".USERS_TABLE." u 
        WHERE i.image_active = 1 AND i.cat_id NOT IN &#40;$cat_id_sql&#41; AND i.cat_id = c.cat_id AND i.user_id = u.user_id $cat_match_sql 
        ORDER BY i.image_date DESC 
        LIMIT $number_of_news"; 
$result = $site_db->query&#40;$sql&#41;; 
$new_images_list = array&#40;&#41;; 
$i = 1; 
while &#40;$row = $site_db->fetch_array&#40;$result&#41;&#41; &#123; 
  $new_images_list[$i&#93; = $row; 
  $i++; 
&#125; 
$site_db->free_result&#40;&#41;; 


for &#40;$i = 1; $i <= $number_of_news; $i++&#41; &#123; 
  if &#40;isset&#40;$new_images_list[$i&#93;&#41;&#41; &#123; 

$result = $site_db->query&#40;$sql&#41;; 
 while &#40;$row = $site_db->fetch_array&#40;$result&#41;&#41; &#123;  
 $image_id = &#40;$row['image_id'&#93;&#41;;
 $image_name = &#40;$row['image_name'&#93;&#41;;
$image_link = &#40;"<a href=\"" . ROOT_PATH . "details.php?image_id=" . $image_id . "\">"&#41;;
$image_date = format_date&#40;$config['date_format'&#93;." ".$config['time_format'&#93;,$new_images_list[$i&#93;['image_date'&#93;&#41;; 
$news = &#40;"&#58;&#58; <b>" . $new_images_list[$i&#93;['image_name'&#93; . "</b> &#40; <b>" . $new_images_list[$i&#93;['cat_name'&#93; . " </b>&#41; <br>" &#41;; 


echo "<ul><b>$image_name</b> &nbsp;&nbsp;&nbsp;$image_link ...view image </a></ul>";

  &#125; 
&#125;
&#125; 
?>


this code gives me last 5 images for 5 times
I WANT TO LIST LAST 5 IMAGES FOR 1 TIME

please help me with this code , without any other codes

[SLL]

please help me with this code , without any other codes

you shouldn't remove sql query, do exactly, what I told you above

[gti-the-sexy]

of course I did, but it removes only "xxx found in xxx category" sentence and list the new X images for X categories

I dont want to list categories by categories

ONLY LIST LAST X IMAGES FOR ALL 4IMAGES

thanks for help

[Slammer]

hello,

i got the get_new_pics.php working, but now i want to 'load' it in my home.html. i did this through the following code:

<?php include("get_new_pics.php"); ?>

but when i load my page, it gives the following error:

Fatal error: Cannot redeclare addslashes_array() (previously declared in /blablabla/global.php:32) in /blablabla/global.php on line 32

can someone help me with this? when i load the get_new_pics.php from where it's at, it works, but it doesn't when i try loading it up through home.html...

grtz

[V@no]

if u want include it into template that way, then u can comment those lines:

Code: [Select]

define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();

[Slammer]

thnx for your reply V@no, but where should i insert this code? in the home.html?
because this code is already in my get_new_pics.php
http://mobile-snapshots.com/Gallery/get_new_pics.php

[V@no]

thnx for your reply V@no, but where should i insert this code? in the home.html?
because this code is already in my get_new_pics.php
http://mobile-snapshots.com/Gallery/get_new_pics.php

hum? insert? I didnt say insert, I said comment (delete, erase, destroy)

[Slammer]

it gives me another error after i commented (sorry, didn't know that it ment deleting ) the codes.
it now says:

Fatal error: Call to a member function on a non-object in /blablabla/get_new_pics.php on line 20

is there any other way to include this in a site?
thnx.

[Fugaziman]

I just noticed this post and couldn't help noticing it's very similar to a Mod post I made a little while ago.  :

http://www.4homepages.de/forum/viewtopic.php?t=5654

My mode does not do any extra Database Calls (slowing your page load time)

You can see it in action on my web page - Left side.
Just thought it may help.
I'll go now  

[Koosje]

How is it possible to have a listing without thumbnails extra besides the one with thumbnails? This as a short overview of all or searched pics.