(newb)displaying limited, ordrd results

[Anon]

i need to make a script that will connect to a table and display all the items as images, with links to a more detailed page. however i need for only FOUR images per row, and THREE rows max. then, links below for "next previous" etc.

i know this is simple but im just trying to get my foot in the door. if someone could tell me what the script will consist of, or if you have time, post some generic code that would do it, it would be appreciated.

i know i have a lot of reading to do, im just in a big rush right now so i came here...

thanks!

[soulreaver]

The below script is used to extract info from a database and create links to documents

include('rail_connect.php');

for ($i=0;$i<=5😉
{
$o=$i*5;
$sql="SELECT id,date_format(posted,'%W %D %b %Y'),link_name from notices order by id desc limit $o,5";

$result=mysql_query($sql);
print"<tr>";
while (list ($id,$posted,$link_name) = mysql_fetch_row ($result))
{
print (" <td><a href=\"../railfiles/$link_name\">HERE</a></td>\n");
}
print"</tr>";
$i=$i+1;
}
If you change the HERE for an <img> tag and place the image name within the database, it would work.

This code is set to display 30 links so you will need to tinker with the for loop a little.

Hope this helps

Neil