Listing Rows?

[marcus]

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?

[Ninjakreborn]

[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]

[marcus]

but how can i make it so it only lists 12 pictures?

[Ninjakreborn]

[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]

[marcus]

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]

[Barand]

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