Re: Urgent!!!
| From: | Thomas \"omega\" Henning | Date: | Thu, 03 Jan 2002 12:04:37 +0000 |
| Subject: | Re: Urgent!!! | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15326@lists.php.net to get a copy of this message | ||
Sorry but I don't have the query done yet . But maybe later I will have it
done but I don't know how to use the substr command in mySQL . If you tell
me how to use it I will post it on the forum.
Thomas "omega" Henning
"George Nicolae" <geomasterweb@hotmail.com> wrote in message
news:20020103084431.23678.qmail@pb1.pair.com...
> and who looks the query with "substr the date so i get only the year"?
Type
> the exact query you make.
>
> --
>
>
> Best regards,
> George Nicolae
> IT Manager
> ___________________
> X-Playin - Professional Web Design
> www.x-playin.f2s.com
>
>
>
> "Thomas "Omega" Henning" <tomi@mediasoft.ro> wrote in message
> news:20020103065519.93149.qmail@pb1.pair.com...
> > I forgot to type in something if i substr the date so i get only the
year
> > from it then is it possible?
> > "George Nicolae" <geomasterweb@hotmail.com> wrote in message
> > news:20020102182824.88893.qmail@pb1.pair.com...
> > > you can't make this query because type mismatches.
> > >
> > >
> > > --
> > >
> > >
> > > Best regards,
> > > George Nicolae
> > > IT Manager
> > > ___________________
> > > X-Playin - Professional Web Design
> > > www.x-playin.f2s.com
> > >
> > >
> > >
> > > "Thomas "Omega" Henning" <tomi@mediasoft.ro> wrote in
> > > message
> > > news:20020102174918.65567.qmail@pb1.pair.com...
> > > > Hello,
> > > >
> > > > Is it possible to order the table somethin like this
> > > > 'select * from intrat order by idatum+iszam DESC; '
> > > > where idatum is date
> > > > and iszam is int
> > > >
> > > > thanks
> > > >
> > > > Thomas "omega" Henning
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>