Jump to content

Archived

This topic is now archived and is closed to further replies.

marcus

Listing Rows?

Recommended Posts

Ok, I want to list like 12 pictures grabbing them from my database.

So it will show like ids 1 - 12 on the first page and then the next page 13 - 24 and so forth...

How would I go about doing this?

Share this post


Link to post
Share on other sites
[code]<?php
$select = "SELECT * FROM pictures;";
$query = mysql_query($select);
while ($row = mysql_fetch_array($query)) {
echo "<img src=\"{$row[imagepath]}{$row[imagename]}\" alt=\"{$row[imagename]}\" />";
}
?>[/code]

Share this post


Link to post
Share on other sites
but how can i make it so it only lists 12 pictures?

Share this post


Link to post
Share on other sites
[code]<?php
$select = "SELECT * FROM pictures LIMIT 12;";
$query = mysql_query($select);
while ($row = mysql_fetch_array($query)) {
echo "<img src=\"{$row[imagepath]}{$row[imagename]}\" alt=\"{$row[imagename]}\" />";
}
?>[/code]

Share this post


Link to post
Share on other sites
i had to modify your code

i used

[code]
$select = "SELECT * FROM art LIMIT 12;";
$query = mysql_query($select);
while ($row = mysql_fetch_array($query)) {
$desc = $row[desc];
$cat = $row[cat];
$pic = $row[pic];
$id = $row[id];
echo "<a href=?page=view&id=$id><img src=art/$cat/$pic alt='$desc' width=80 height=100 border=0></a>";
}
[/code]

Share this post


Link to post
Share on other sites
The mysql LIMIT clause can take 2 arguments eg LIMIT 0, 12 where the first number is the record number to start at and the second is how many.

So your first page would want LIMIT 0, 12
Second would want LIMIT 12, 12
...
Pth page would want LIMIT (P-1) * 12 , 12

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.