[PHP] mod rewrite - DMXzone's PHP Pagination

2010-11-16 Thread Richard West
is like /?php echo $_row['alias']; ?.html Now that was simple to what I have ran into... DMXzone has a dreamweaver extension called PHP Pagination which creates very nice paging links. But it has a huge class and its function to print links is over my head. I'm new to the list and I know how

Re: [PHP] Pagination?

2010-06-09 Thread Sharl.Jimh.Tsin
yes,LIMIT for mysql is useful. Best regards, Sharl.Jimh.Tsin 2010/6/8 Ashley Sheridan a...@ashleysheridan.co.uk: On Tue, 2010-06-08 at 11:37 -0300, Paul Halliday wrote: I just spent the last 1/2 hour looking at many different solutions for this. Is there a universal favorite? Thanks.

[PHP] Pagination?

2010-06-08 Thread Paul Halliday
I just spent the last 1/2 hour looking at many different solutions for this. Is there a universal favorite? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Pagination?

2010-06-08 Thread Ashley Sheridan
On Tue, 2010-06-08 at 11:37 -0300, Paul Halliday wrote: I just spent the last 1/2 hour looking at many different solutions for this. Is there a universal favorite? Thanks. It depends what you mean by pagination, as there are two parts to it. There is the display of the pagination nav and

[PHP] pagination code not incrementing page numbers.

2006-10-23 Thread Mark
I am using the following code for pagination with php5 and mysql 4.1.x The pages advance by clicking on the Next or Last link However the url does not advance past this in the url field http://localhost/page.php?pagenum=2 Also the page count does not increase past --Page 1 of 50-- at the bottom

Re: [PHP] pagination code not incrementing page numbers.

2006-10-23 Thread Chris
Mark wrote: I am using the following code for pagination with php5 and mysql 4.1.x The pages advance by clicking on the Next or Last link However the url does not advance past this in the url field http://localhost/page.php?pagenum=2 Also the page count does not increase past --Page 1 of 50--

Re: [PHP] Pagination

2005-03-25 Thread Colin Ross
watch out for SQL injection attacks on that one though: what if the 'user' went to page.php?start=1;SELECT * from `mysql`; On Thu, 24 Mar 2005 22:55:01 +0100, pavel [EMAIL PROTECTED] wrote: I am wanting to paginate records from a MySQL Database. I want there to be 5 records on a page, on

Re: [PHP] Pagination

2005-03-24 Thread pavel
I am wanting to paginate records from a MySQL Database. I want there to be 5 records on a page, on multiple pages. example for selecting page of records from mysql table: $sql=sprintf( SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT %d, %d, $position*$records, $records );

[PHP] Pagination

2005-03-23 Thread Marquez Design
Hello all, I am wanting to paginate records from a MySQL Database. I want there to be 5 records on a page, on multiple pages. Can someone point me in the right direction or show me a way to do this? I can get five records on a page with a LIMIT statement, however, I can not get it to show the

Re: [PHP] Pagination

2005-03-23 Thread John Nichel
Marquez Design wrote: Hello all, I am wanting to paginate records from a MySQL Database. I want there to be 5 records on a page, on multiple pages. Can someone point me in the right direction or show me a way to do this? I can get five records on a page with a LIMIT statement, however, I can not

Re: [PHP] Pagination

2005-03-23 Thread John Nichel
Please send replies to the list. [EMAIL PROTECTED] wrote: I've been working on this same project for one of my pages, and it seems relatively straight forward if you are just using a full set of records to paginate, but if you are using a filtered set (or search results) then it becomes a bit

RE: [PHP] Pagination

2005-03-23 Thread Chris W. Parker
Marquez Design mailto:[EMAIL PROTECTED] on Wednesday, March 23, 2005 12:19 PM said: I am wanting to paginate records from a MySQL Database. I want there to be 5 records on a page, on multiple pages. Can someone point me in the right direction or show me a way to do this? I can get

[PHP] Pagination Optimization

2005-01-07 Thread Bruno B B Magalhães
Hi guys, currently I have a function in my framework´s mysql driver , that fetch paginated results... Here it´s: === /* * Fetch paginated results

[PHP] Pagination need help again

2004-11-13 Thread Scott McWhite
Sorry, Its me again.  I tried all the recommendations from my first responses and could not find the proper syntax on how to use it in my file.    My original email question,error, and my php code is listed below.  Thank you in advance for all your help, this is a great community.

Re: [PHP] Pagination need help1)

2004-11-04 Thread Sebastiano Cascione
Use 2 queries. 1) SELECT * FROM cars WHERE ... ORDER BY... ; 1) SELECT * FROM cars WHERE ... ORDER BY... LIMIT $record_x_page OFFSET $page; With the firsth query print pages numbers at the bottom of the html page. With the second one print the records list. Every time you click on the page

Re: [PHP] Pagination need help

2004-11-04 Thread Mike
on 11/3/04 11:22 PM, Scott McWhite at [EMAIL PROTECTED] wrote: Does anyone have sample code for using an HTML search form with pagination? Scott, I followed this tutorial and it helped me accomplish what you are trying to do. http://www.phpfreaks.com/tutorials/43/0.php Good luck.

[PHP] Pagination need help

2004-11-03 Thread Scott McWhite
Hi, I’m using an HTML search form that passes the “searchterm” to a php file. In my case the “searchterm” can have 1000s of records in my database, so I implemented a limit which displays 20 records per page. The pagination function works fine with one exception. Example of my problem:

Re: [PHP] Pagination need help

2004-11-03 Thread Jason Wong
On Thursday 04 November 2004 04:22, Scott McWhite wrote: function works fine with one exception. Example of my problem: searchterm typed in the html search form equals “ford”, in the database there are 2000 fords, the first page displays 20 fords and then the next page forgets that we are

[PHP] Pagination MSSQL

2004-03-09 Thread Alex Hogan
Hi All, I have searched for some references on pagination using mssql but have come up empty. I have looked at the tutorials on Zend and just about everywhere else but unfortunately they all use LIMIT in the sql statement and the closest thing to that in mssql is either TOP n, or SET

Re: [PHP] Pagination MSSQL

2004-03-09 Thread Richard Davey
Hello Alex, Tuesday, March 9, 2004, 3:11:54 PM, you wrote: AH I have searched for some references on pagination using mssql but have come AH up empty. AH I have looked at the tutorials on Zend and just about everywhere else but AH unfortunately they all use LIMIT in the sql statement and the

RE: [PHP] Pagination Part 2

2003-03-13 Thread Ford, Mike [LSS]
-Original Message- From: conbud [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 19:12 Hi, Ive been trying to get this to work but I keep getting this error Parse error: parse error, unexpected $ in /home/conbud/nrlug/test3.php on line 72 line 72 is just the ending php

[PHP] Pagination Part 2

2003-03-12 Thread conbud
Hi, Ive been trying to get this to work but I keep getting this error Parse error: parse error, unexpected $ in /home/conbud/nrlug/test3.php on line 72 line 72 is just the ending php bracket, heres what I got: ?php @mysql_connect(localhost, root, boing_boing) or die(ERROR--CAN'T CONNECT

Re: [PHP] Pagination Part 2

2003-03-12 Thread Jonathan Pitcher
You are mixing and matching your If statements. if () else AND if () { } else { } Be consistent. It looks like if you close the { tags your code should work ok.} Hope this helps, Jonathan Pitcher On Wednesday, March 12, 2003, at 01:11 PM, conbud wrote: Hi, Ive been trying to get this

[PHP] pagination help

2003-03-09 Thread Denis L. Menezes
Hello friends. My records on one page are bout 200. So I wish to paginate them and show only about 20 records per page with the page numbers at the bottom of the records table and also the previous and next links. I mean, something line Google's searcg results page numbering system. Can

Re: [PHP] pagination help

2003-03-09 Thread Kevin Waterson
This one time, at band camp, Denis L. Menezes [EMAIL PROTECTED] wrote: Hello friends. Can someone give me a link to some help files? http://www.phpbuilder.com/columns/rod20001214.php3 Kevin -- __ (_ \ _) )