RetroBBS - comp.lang.php - Re: ORDER BY Problem

Re: ORDER BY Problem

<690afc51-07d9-4a52-9c8c-2f9004c5dba8n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=428&group=comp.lang.php#428

X-Received: by 2002:a05:622a:115:: with SMTP id u21mr18315364qtw.197.1643708681980;
Tue, 01 Feb 2022 01:44:41 -0800 (PST)
X-Received: by 2002:a05:6902:110a:: with SMTP id o10mr3341134ybu.84.1643708681671;
Tue, 01 Feb 2022 01:44:41 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.php
Date: Tue, 1 Feb 2022 01:44:41 -0800 (PST)
In-Reply-To: <p122du$ihm$1@jstuckle.eternal-september.org>
Injection-Info: google-groups.googlegroups.com; posting-host=193.40.120.146; posting-account=s3OxiwkAAABE2kqiXXKi7ZVC4Hsq_zQz
NNTP-Posting-Host: 193.40.120.146
References: <9j093dlnrqntphtsn4hi8rsgs2ff1sr7h8@4ax.com> <p122du$ihm$1@jstuckle.eternal-september.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <690afc51-07d9-4a52-9c8c-2f9004c5dba8n@googlegroups.com>
Subject: Re: ORDER BY Problem
From: ya3891921@gmail.com (He)
Injection-Date: Tue, 01 Feb 2022 09:44:41 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 60

by: He - Tue, 1 Feb 2022 09:44 UTC

Jerry Stuckle kirjutas Laupäev, 16. detsember 2017 kl 05:03:37 UTC+2:
> On 12/15/2017 9:28 PM, Jim H wrote:
> >
> > I have PHP code containing:
> >
> > $query = "SELECT name, level, date_entered
> > FROM $table
> > WHERE name = 'Annual'
> > ORDER BY level DESC
> > LIMIT 10";
> >
> > Field "level" is VARCHAR(13) and can contain either all numeric
> > (numeric string) or all alpha data, but for records where name =
> > "Annual" the content is always all numeric (numeric string)
> >
> > So, after stepping thru $query and printing the content of "level" I
> > get the following desired result:
> >
> > 580
> > 393
> > 346
> > 192
> > 157
> > 156
> >
> > And after adding another record containing level = 1174 I get the
> > following undesired result:
> >
> > 580
> > 393
> > 346
> > 192
> > 157
> > 156
> > 1174
> >
> > What I want is:
> >
> > 1174
> > 580
> > 393
> > 346
> > 192
> > 157
> > 156
> >
> > What am I doing wrong?
> >
>
> You're asking a database question in a language newsgroup. Try an
> appropriate newsgroup.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> jstu...@attglobal.net
> =================
Hey. Would you help me out with a little bit of money (maybe at least 2100 dollars)...... I have no job momentarily.......

Radioactive cats have 18 half-lives.

devel / comp.lang.php / Re: ORDER BY Problem