Current location: Hot Scripts Forums » Programming Languages » PHP » MySQL SELECT query result dividing


MySQL SELECT query result dividing

Reply
  #1 (permalink)  
Old 06-06-04, 02:47 PM
ICE Flame ICE Flame is offline
Newbie Coder
 
Join Date: Mar 2004
Location: Israel
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
MySQL SELECT query result dividing

Hello everybody,
I don't know how to divide the result of my SELECT query into pages.
For example - I have a table named "myTable". It includes 100 records. I want to create 10 pages, each one includes 10 records.
I think the query should look like that:
PHP Code:

mysql_query("SELECT * FROM myTable LIMIT 10"); 

But when I'm running the query, it shows me only 10 records.
What shall I do to divide my query into pages?
Thank you...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 06-06-04, 03:50 PM
NeverMind's Avatar
NeverMind NeverMind is offline
Community VIP
 
Join Date: Aug 2003
Location: K.S.A
Posts: 2,257
Thanks: 0
Thanked 2 Times in 1 Post
__________________
PHPSimplicity
We don't need a reason to help people - Zidane [FF9]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help query result mysql php paceno11 PHP 1 02-19-04 03:18 AM
PHP:search by MySQL query lowdog PHP 0 02-15-04 11:04 AM
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result ... hukka PHP 1 01-12-04 01:16 AM
Declared Functions skipper23 PHP 4 12-17-03 11:06 AM
index page not showing up skipper23 PHP 3 12-15-03 02:10 PM


All times are GMT -5. The time now is 07:38 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.