error

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/iouguyc1/public_html/tarbaby/page.php on line 23

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 24
Offset (Number of rows in a page): 3

---- 1. basic next/prev ---------------------------------------------

RESULTS

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 43

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 45



prev | next
Showing 1 - 3 out of 0

---- 2. Page Numbers ---------------------------------------------

RESULTS

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 77

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 79



prev | | next
Showing 1 - 3 out of 0

---- 3. Select Field (Drop Down) ---------------------------------------------

RESULTS

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 111

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/iouguyc1/public_html/tarbaby/page.php on line 113



prev
next

Showing 1 - 3 out of 0

There might be something missing.

Can you show that section of your code?

nice...script it's working properly

but,my query contain values...how do i get that values on the next page...

@patelv98: Thanks! You can get the values to the next page by using cookie or session. Or you can also use the GET variables but you need to have the GET parameter on the first page.

Example you will be displaying all posts submitted by a certain user and you can specify how many posts displayed per page.

like:
index.php?username=john&numposts=15

numposts - serves as your offset (number of rows per page)

The pagination displays the pages and when you proceed to the next page the URL will look like this
index.php?username=john&numposts=15&page=2

I have error ,this messges:
Notice: Undefined index: page in C:\xampp\htdocs\my-pagination\example.php on line 40
Notice: Undefined index: id_user in C:\xampp\htdocs\my-pagination\example.php on line 47
Notice: Undefined index: user_name in C:\xampp\htdocs\my-pagination\example.php on line 47
=>
Notice: Undefined index: id_user in C:\xampp\htdocs\my-pagination\example.php on line 47
etc

@leonardus : It seems you don't have these fields in your table. The example script uses only 1 table with 2 fields which (id_user[int], user_name[varchar]). You must also insert some records to fully test the script. Hope this helps.

need line 267. $pages='';