Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Martin Scotta
On Thu, Jul 16, 2009 at 12:01 PM, Miller, Terion < tmil...@springfi.gannett.com> wrote: > > One question I still have...I had help with this script of course and I'm > confused with the %s what does it do? > > On 7/16/09 9:53 AM, "Martin Scotta" wrote: > > > On Thu, Jul 16, 2009 at 11:01 AM, Andr

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Miller, Terion
One question I still have...I had help with this script of course and I'm confused with the %s what does it do? On 7/16/09 9:53 AM, "Martin Scotta" wrote: On Thu, Jul 16, 2009 at 11:01 AM, Andrew Ballard wrote: On Thu, Jul 16, 2009 at 9:33 AM, Miller, Terion wrote: > > Here is what finally w

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Martin Scotta
On Thu, Jul 16, 2009 at 11:01 AM, Andrew Ballard wrote: > On Thu, Jul 16, 2009 at 9:33 AM, Miller, > Terion wrote: > > > > Here is what finally worked: > > > > = isset($_GET['letter']) ? $_GET['letter'] : "A"; > //alphabetical pagination links >

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Andrew Ballard
On Thu, Jul 16, 2009 at 9:33 AM, Miller, Terion wrote: > > Here is what finally worked: > >     isset($_GET['letter']) ? $_GET['letter'] : "A";                               >                          //alphabetical pagination links                       >                                  echo '

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Miller, Terion
Here is what finally worked: '; foreach(range('A','Z') as $c){ ($letter == $c) ? printf('%s ',$c)

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Miller, Terion
--snip How do I write the for each loop in here: //alphabetical pagination links if (!isset($_GET['letter'])) {$letter = "A";} else {$letter = $_GET['letter'];}

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Martin Scotta
SET @letter := 'B'; SELECT name FROM table WHERE SUBSTRING(name, 1) == @letter; SELECT name FROM table WHERE name like concat(@letter, '%'); I don't know a faster way to do it On Wed, Jul 15, 2009 at 12:57 PM, Ashley Sheridan wrote: > On Wednesday 15 July 2009 16:46:53 Andrew Ballard wrote: >> On

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Ashley Sheridan
On Wednesday 15 July 2009 16:46:53 Andrew Ballard wrote: > On Wed, Jul 15, 2009 at 11:30 AM, Ashley > > Sheridan wrote: > > On Wednesday 15 July 2009 16:21:22 tedd wrote: > >> At 12:38 PM -0700 7/14/09, Miller, Terion wrote: > >> >I am trying to make a page that displays a-z like a b c d e etc as >

Re: [PHP] Alphabetical pagination

2009-07-15 Thread tedd
At 8:29 AM -0700 7/15/09, Miller, Terion wrote: Hi all thanks for all the suggestions, I really had no idea this was going to be so difficult.. I think you are making it more difficult than it has to be. Please review what I said and try it out. Cheers, tedd -- --- http://sperling.c

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Andrew Ballard
On Wed, Jul 15, 2009 at 11:30 AM, Ashley Sheridan wrote: > On Wednesday 15 July 2009 16:21:22 tedd wrote: >> At 12:38 PM -0700 7/14/09, Miller, Terion wrote: >> >I am trying to make a page that displays a-z like a b c d e etc as links >> >then when you click open one it reloads itself and shows onl

Re: [PHP] Alphabetical pagination

2009-07-15 Thread tedd
At 4:30 PM +0100 7/15/09, Ashley Sheridan wrote: On Wednesday 15 July 2009 16:21:22 tedd wrote: At 12:38 PM -0700 7/14/09, Miller, Terion wrote: >I am trying to make a page that displays a-z like a b c d e etc as links >then when you click open one it reloads itself and shows only the query

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Miller, Terion
On 7/15/09 10:30 AM, "Ashley Sheridan" wrote: On Wednesday 15 July 2009 16:21:22 tedd wrote: > At 12:38 PM -0700 7/14/09, Miller, Terion wrote: > >I am trying to make a page that displays a-z like a b c d e etc as links > >then when you click open one it reloads itself and shows only the query

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Ashley Sheridan
On Wednesday 15 July 2009 16:21:22 tedd wrote: > At 12:38 PM -0700 7/14/09, Miller, Terion wrote: > >I am trying to make a page that displays a-z like a b c d e etc as links > >then when you click open one it reloads itself and shows only the query > >results that go with that letter...i'm not gett

Re: [PHP] Alphabetical pagination

2009-07-15 Thread tedd
At 12:38 PM -0700 7/14/09, Miller, Terion wrote: I am trying to make a page that displays a-z like a b c d e etc as links then when you click open one it reloads itself and shows only the query results that go with that letter...i'm not getting itI get a page that says ARRAY over and over...

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Andrew Ballard
On Wed, Jul 15, 2009 at 3:28 AM, Ashley Sheridan wrote: > On Wednesday 15 July 2009 06:35:04 Jim Lucas wrote: >> Andrew Ballard wrote: >> > On Tue, Jul 14, 2009 at 3:38 PM, Miller, >> > >> > Terion wrote: >> >> I am trying to make a page that displays a-z like a b c d e etc as links >> >> then when

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Ashley Sheridan
On Wednesday 15 July 2009 06:35:04 Jim Lucas wrote: > Andrew Ballard wrote: > > On Tue, Jul 14, 2009 at 3:38 PM, Miller, > > > > Terion wrote: > >> I am trying to make a page that displays a-z like a b c d e etc as links > >> then when you click open one it reloads itself and shows only the query >

Re: [PHP] Alphabetical pagination

2009-07-14 Thread Jim Lucas
Andrew Ballard wrote: On Tue, Jul 14, 2009 at 3:38 PM, Miller, Terion wrote: I am trying to make a page that displays a-z like a b c d e etc as links then when you click open one it reloads itself and shows only the query results that go with that letter...i'm not getting itI get a page that

Re: [PHP] Alphabetical pagination

2009-07-14 Thread Andrew Ballard
On Tue, Jul 14, 2009 at 3:38 PM, Miller, Terion wrote: > I am trying to make a page that displays a-z like a b c d e etc as links > then when you click open one it reloads itself and shows only the query > results that go with that letter...i'm not getting itI get a page that > says ARRAY over

Re: [PHP] Alphabetical pagination

2009-07-14 Thread Dan Shirah
> > I am trying to make a page that displays a-z like a b c d e etc as links > then when you click open one it reloads itself and shows only the query > results that go with that letter...i'm not getting itI get a page that > says ARRAY over and over... > > What I have so far: >

[PHP] Alphabetical pagination

2009-07-14 Thread Miller, Terion
I am trying to make a page that displays a-z like a b c d e etc as links then when you click open one it reloads itself and shows only the query results that go with that letter...i'm not getting itI get a page that says ARRAY over and over... What I have so far: