Re: [sqlite] Query with subqueries: is this the good way to go?

On 7/15/2011 9:54 AM, Gabriele Favrin wrote: > SELECT > otopic.id AS idtopic, otopic.titolo, > strftime('%d/%m/%Y', otopic.inserito) AS inserito, > (SELECT strftime('%d/%m/%Y %H:%M', max(inserito)) FROM topic WHERE pub=1 > AND id=otopic.id) AS ultimo, I don't understand this part. Presumably, topi

[sqlite] Query with subqueries: is this the good way to go?

Hello. First of all thanks in advance for any help. The last time I've asked here I got a very useful help about my database structure. I'm developing a very simple forum with PHP5.3 and SQLite. I have a message table where I store messages along with their flags and a column referencing the aut