We have a problem. We have given the dates as date.month.year eg 27.12.2007
The field is named as varchar. We have to arrange ths list of dates in
ascending order. Can anyone help? Varchar arranges the list by scanning from
left side. Perhaps scanning from right side will do. How to do it?
--
PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] ordering date in varchar
We have a problem. We have given the dates as date.month.year eg 27.12.2007
The field is named as varchar. We have to arrange ths list of dates in
ascending order. Can anyone help? Varchar arranges the list by scanning from
left side
; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] ordering date in varchar
We have a problem. We have given the dates as date.month.year eg 27.12.2007
The field is named as varchar. We have to arrange ths list of dates in
ascending order. Can anyone help? Varchar arranges the list
*Questions on PHP*
In one of our tables, one of the field is acc_no, we had given the data type
as varchar, since it could take any alpha-numeric values. In viewing this,
we used 'order by acc_no.' The sequence of records shown was
1,10,100,1000,A1, A10, A100, etc. whereas we want the sequence
http://dev.mysql.com/doc/internals/en/select-union.html
Does anyone know what this means? Can it be implemented in the flow of
php code without explicitly creating temp tables in the database?
My query is like:
$query =
(SELECT
Table.field, [other fields]
FROM Table
I have a page that I put together that pulls in data for the time in
individual fields - hour, minute, am/pm, month, day. I am going to
alter the db to add year as well. I want to order this list by multiple
criteria - first by year, then by hour, am/pm, minute. It is a page
that lists shows
From: redhat [EMAIL PROTECTED]
I have a page that I put together that pulls in data for the time in
individual fields - hour, minute, am/pm, month, day. I am going to
alter the db to add year as well. I want to order this list by multiple
criteria - first by year, then by hour, am/pm,
Hi list!
How can I Order By in MySQL a column asceding and an other column desceding?
Qbit
- Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr
order by col1 asc col2 desc
nikos wrote:
Hi list!
How can I Order By in MySQL a column asceding and an other column desceding?
Qbit
- Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
Hi Bogdan et al...
Thanks! I've got that going now. I'm sure that I'll have more questions for
you as I work on it. In fact here's one now!
echo($myrow[1] $myrow[2]br\n);
In the line above, how can I get a tab to work? I tried \t but that did not
work. Also the \n does not work on this
/t is a tab, however tabs won't show up in HTML, you'll have to use something like:
nbsp;nbsp;nbsp;nbsp;nbsp;
Ryan
-Original Message-
From: Jim Hatridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Ordering question
] Ordering question .
/t is a tab, however tabs won't show up in HTML, you'll have to use something like:
nbsp;nbsp;nbsp;nbsp;nbsp;
Ryan
-Original Message-
From: Jim Hatridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
Hi,
I'm trying to build an article management system. Basically it will have
normal artcile type things, a picture or two etc. The articles will be
ordered by date by default, but I want to include the option of being able to
order the articles if need be. i.e. say I add more artciles but i
13 matches
Mail list logo