-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy, et al --
...and then Andy Jackman said...
%
% David,
% > Gah. That's what I was hoping to avoid. It's like writing BASIC and
% > having to leave yourself room...
% Yes, but unlike a basic program of 1 lines (heh, remember that!) you
Yeah
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy, et al --
...and then Andy Jackman said...
%
% David,
% Firstly, to answer your question I don't know of a MySQL function that
% may allow you to sort indirectly by the contents of a field - there are
How very odd! It seems so natural to me :-
David,
> Gah. That's what I was hoping to avoid. It's like writing BASIC and
> having to leave yourself room...
Yes, but unlike a basic program of 1 lines (heh, remember that!) you
only need to leave room for n questions. If n is small - no problem,
even if you have to 'renumber'. If n is lar
David,
Firstly, to answer your question I don't know of a MySQL function that
may allow you to sort indirectly by the contents of a field - there are
many many functions and some of them are very specialised, and if you
ever move to another db all those great little functions may not be
there. Howe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have a few tables something like
create table SURVEY
( SID int primary key not null auto_increment,
SNAME varchar(20),
QUESTION_ORDER varchar(20) ) ;
create table SURVEY_QUESTION
( QID int primary key not null aut
