You have to do:
foreach ($test as $group) {
if (strtolower ($group) != $sort) {
$lgroup = strtolower ($group);
echo "<a href=\"patterns.php?sort={$lgroup}\">{$group}</a><br />";
} else {
echo "{$group}<BR><BR>";
... query db and show results ...
echo "<BR>";
}
}
----- Original Message -----
From: "Aaron Wolski" <aaronjw@martekbiz.com>
To: <php-db@lists.php.net>
Sent: Wednesday, July 30, 2003 6:19 PM
Subject: RE: alphabetical sorting... limiting and paginating onnext
set of letter group
> Sorry all but getting kinda desparate here :(
>
> Trying a few different things and still nothing seems to work.
>
> Does anyone have a kick in the right direction that I could explore
> here?
>
> Sorry for the repost.
>
> Thanks
>
> Aaron
>
> -----Original Message-----
> From: Aaron Wolski [mailto:aaronjw@martekbiz.com]
> Sent: July 30, 2003 9:47 AM
> To: 'ramil@astra.ph'; 'php-db@lists.php.net'
> Subject: RE: alphabetical sorting... limiting and paginating
> onnext set of letter group
>
> Alrighty..
>
> Working with your code and some others I've come up with this:
>
> <?php
> if ($sort) {
>
> $list = explode("-", $sort);
>
> }
>
> $test = Array('A-D', 'D-G', 'G-J', 'J-M', 'M-P', 'P-S', 'S-V', 'V-Y',
> 'Y-Z');
>
> foreach ($test as $group) {
> if (strtolower ($group) != $sort) {
> $lgroup = strtolower ($group);
> echo "<a
> href=\"patterns.php?sort={$lgroup}\">{$group}</a><br />";
> }
> }
>
>
> $designerQuery = db_query("SELECT designer FROM kcs_patterns WHERE
> designer BETWEEN '".$list[0]."' and '".$list[1]."' GROUP BY designer
> ORDER BY designer");
> while ($designerResult = db_fetch($designerQuery)) {
>
> ?>
> <img src="Graphics/spacer.gif" width="10" height="1"><a href=""><font
> class="catalogueSubCatLink"><?php echo $designerResult['designer']; ?>
> Designers</font></a><br>
> <?php
>
> }
>
> ?>
>
> This works as I need it to.. shifting from one set of results to
> another. My problem is how do I format it like the following(assuming
> A-D was selected):
>
> A-D Designers
>
> Artists Collection The
> Barrick Samplers
> Bent Creek
> Brown House Studio
> Butternut Road
> Calico Crossroads
> Canterbury
> Cross My Heart
> Crossed Wing Collection
>
> D-G
> G-J
> J-M
> M-P
> P-S
> S-V
> V-Y
> Y-Z
>
> Or if D-G was selected:
>
> A-D
>
> D-G Designers
>
> Datta Bonnie
> Design Connection
> Design Connection The
> DMC
> Donna Gallagher Creative Needlearts
> Dragon Dreams
> Family Tree The
> Fanci That
> Full Circle Designs
>
> G-J
> J-M
> M-P
> P-S
> S-V
> V-Y
> Y-Z
>
> I've tried a few placements of the foreach loop but nothing seems to
> work. Any ideas?
>
> Thanks!
>
>
>
> -----Original Message-----
> From: Ramil G. Sagum [mailto:ramil@astra.ph]
> Sent: July 29, 2003 11:38 PM
> To: php-db@lists.php.net
> Cc: Aaron Wolski
> Subject: RE: alphabetical sorting... limiting and paginating
> onnext set of letter group
>
> On Wed, 2003-07-30 at 11:17, Aaron Wolski wrote:
> > Hey,
> >
> > Thanks.
> >
> > Is there anyway this can be performed one function/loop?
> >
>
> yes of course. =) just create a function that takes in two letters as a
> parameter,
> then build the query string from it.
>
>
> function($char_begin, $char_end)
>
> {
> $q_begin = strtolower($char_begin);
> $q_end = chr(ord(strtolower($char_begin))+1);
> $query = "SELECT designer_name FROM designer WHERE designer_name
> BETWEEN '".$q_begin."' AND '".$q_end."' ORDER BY designer_name";
>
>
> //do your query here.
> }
>
>
> > I knew it was possible with several queries.. I guess I was just
> looking
> > for a all_in_one solution.
> >
> > Thanks for your help!
>
> > Aaron
> >
> > -----Original Message-----
> > From: Ramil G. Sagum [mailto:ramil@astra.ph]
> > Sent: July 29, 2003 11:07 PM
> > To: Aaron Wolski
> > Subject: Re: alphabetical sorting... limiting and paginating
> > onnext set of letter group
> >
> > On Wed, 2003-07-30 at 10:36, Aaron Wolski wrote:
> > > Hi Guys,
> > > What I would like to do is:
> > > Pattern Designers:
> > >
> > > A/B/C
> > >
> > > Artists Collection The
> > > Barrick Samplers
> > > Bent Creek
> > > Bobbie G. Designs
> > > Calico Crossroads
> > > Charland Designs
> > > Country Cross Stitch
> >
> > > Click for D/E/F
> > > Click for G/H/I
> > > Click for J/K/L
> > >
> > > When the user clicks on one of the another Letter Groupings... the
> > > "A/B/C" changes to whatever they selected as does the displayed
> > results
> > > for their selection.
> > >
> > > Is this even possible?
> > >
> > > Aaron
> >
> > yes it is. =)
> >
> > try for a/b/c
> >
> > SELECT designer_name FROM designer WHERE designer_name BETWEEN 'a' AND
> > 'd' ORDER BY designer_name;
> >
> > for d/e/f :
> >
> > SELECT designer_name FROM designer WHERE designer_name BETWEEN 'd' AND
> > 'g' ORDER BY designer_name;
> >
> > for j/k/l:
> >
> > SELECT designer_name FROM designer WHERE designer_name BETWEEN 'j' AND
> > 'm' ORDER BY designer_name;
> >
> >
> >
> > hope this helps.
> >
> >
> > ramil
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
