[RESOLVED] desc limit

[pneudralics]

DESC LIMIT 0,8

I'm trying to have 2 rows of four pictures show that's evenly spaced. Can someone explain to me what the zero does? I can't seem to do something like

4444
4444

I just keep getting
444
44444

[Houdini]

Tells the MySQL to start from the beginning and get 8 records. If it had been DESC 10, 8 then start at record 10 and get the next 8.

[Blulagoon]

How are you outputting the images. You can use Modulo which would give you this output:

Pic1 Pic2 Pic3 Pic4
Pic5 Pic6 Pic7 Pic8

Blu

[pneudralics]

Blulagoon wrote:

How are you outputting the images. You can use Modulo which would give you this output:

Pic1 Pic2 Pic3 Pic4
Pic5 Pic6 Pic7 Pic8

Blu

Yes that's how I want it. What's Modulo I can't find it on php.net.

[Houdini]

The modulo is represented by % so for 4 it would be %4

[pneudralics]

Houdini wrote:

The modulo is represented by % so for 4 it would be %4

This is what I did:

DESC LIMIT 0,%8

and I got a blank?

[Houdini]

You wouldn't use the modulo in a query but when you are outputting the data using PHP.

$count=1;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   if($count%2){
    //echo "Here's a row";
    echo "<tr><td>{$row['first']}</td>"; 
    echo "<td>{$row['last']}</td>";  

    echo "<td>{$row['phone']}</td></tr>";
    $count++;
    }
	else{
	    //echo "Here's a highlighted row";
	 	echo "<tr bgcolor=lightgrey><td>{$row['first']}</td>"; 
    	echo "<td>{$row['last']}</td>";  

    	echo "<td>{$row['phone']}</td></tr>";
		$count++; 
	} 
 } 
echo "</table>";

[pneudralics]

Thanks