Another Mysql Question

[airjunkie2000]

Im slowly working through this and I have another question. I am wondering about how to create paging? Like how display say 12 items on a page and then move to the next 12, ect...

 

I have this query set up to display to a limit of 400 so I imagine I will have to make the limit a variable?

 

Here's the query I have now...

 

$result = mysql_query("SELECT media_info.media_id, media_type, thumbnail, description, posted, views, media_info.name, file, path, count(comments) as no_of_comments FROM media_info LEFT JOIN comments ON comments.media_id = media_info.media_id GROUP BY media_info.media_id, media_type, thumbnail, description Order by media_id DESC LIMIT 0, 400;")

or die(mysql_error());

 

Can someone give me some tips on how to start and what is involved?

 

Thanks, any help is appreciated.

[btrfld]

Check out this article at SitePoint. It teaches the theory, and develops a PHP Class that does the job nicely. I've used it effectively several times.

 

Good luck.

[airjunkie2000]

Check out this article at SitePoint. It teaches the theory, and develops a PHP Class that does the job nicely. I've used it effectively several times.

 

Good luck.

 

 

Thanks Jim