Re: timestamp updated on select

2002-11-07 Thread Paul DuBois
At 11:41 + 11/7/02, Nikolas Galanis wrote: Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id f

Re: timestamp updated on select

2002-11-07 Thread Michael T. Babcock
Nikolas Galanis wrote: and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the c

Re: timestamp updated on select

2002-11-07 Thread Nikolas Galanis
Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id from poems,translations where poems.poem_id=tran

Re: timestamp updated on select

2002-11-06 Thread Paul DuBois
At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated

Re: timestamp updated on select

2002-11-06 Thread Galanis Nikolas
Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. On Wed, 6 Nov 2002, Paul DuBois wrote: > A

Re: timestamp updated on select

2002-11-06 Thread Paul DuBois
At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT

Re: timestamp updated on select

2002-11-06 Thread Nikolas Galanis
Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. - Bef