hi all, first of all, thank you! this is a very nice script..
I am no coder, i basically do a little bit of php, i try
hehe
My question is, how to display the results correctly? Let me tell you the situation:
I have a table named "screenshots" with names/date of files in it and i want to "echo" the names of the files correctly. I know my english is terrible, im sorry.
heres what ive tried:
<?php
include('config.php');
$db = mysql_connect($dbserver, $dbuser, $dbpass);
mysql_select_db($dbname,$db);
$sql = "SELECT id,big,thumb,postdate, DATE_FORMAT(postdate, '%d/%m/%Y @ %T ') AS pdate FROM screenshots ORDER BY id DESC";
$query = mysql_query($sql,$db);
$total_results = mysql_num_rows($query);
$limit = "12"; //limit of archived results per page.
$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
{
$page = "1"; //default page if none is selected
}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
$query = "SELECT id,big,thumb,postdate, DATE_FORMAT(postdate, '%d/%m/%Y @ %T ') AS pdate FROM screenshots ORDER BY id DESC LIMIT $offset, $limit";
$result = mysql_query($query);
//This is the start of the normal results...
$screen_id = mysql_result($result,$row,"id");
$screen_b = mysql_result($result,$row,"big");
$screen_t = mysql_result($result,$row,"thumb");
$screen_date = mysql_result($result,$row,"pdate");
while ($row = mysql_fetch_array($result))
{
echo "$screen_t"; // display your results as you see fit here.
}
mysql_close();
***CUT***
i simply want to display the 12 latest images and so on for the other pages, i only need to print the filenames correctly, can someone help me out
thanks alot for your time
fred
The only reason I'm asking is because inscissor was over at my house the other day and we were talking about how he just set up something like this on a php site he was working on ... so it reminded me. 
Offline 
, How do i create a nice 3x4 table to display the images ? please..
Unsolved 
