> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
> am I missing something?
I don't understand perfectly your question.
Do you mean "how do I keep records in order" or "how do I keep track of the
previous record's field value in the SELECTing query"?
"how do I keep records in order"
In the simple example, I don't. I don't care what order the records come
out, it's just an example database. :-)
In the complex (real-life) example there is an ORDER BY clause.
"how do I keep track of the previous record's field value when SELECTing"
I use a variable called @oldOrdine. The last thing I do in the SELECT is
stuffing in there the value of the record for the current field. Then, on
the subsequent record iteration, I compare its current value with the
then-current field value.
L.A.
------ End of Forwarded Message
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php