Re: newbie sql question: select every day another quote

Am Samstag, 12. Mai 2001 14:37 schrieb Len Morgan:
> >lastdayshown is always null on insert.
> >works fine. Now i want to select every day a different quote.
> >
> >Is it possible to
> >select the row with lastdayshown = today
>
> SELECT * FROM quotes WHERE lastdayshown = now()::date ;
>
> >if no result

Hi,

thanks for your answer
i already manages this part :-)

> The "no result part" is harder.  You'll have to have some sort of client
> program that can tell you if the above quote returned a row or not.  Once
> you have that, if the above query did NOT return a row, you can use the
> following two steps:
>
> UPDATE quotes SET lastdayshown = now():: WHERE oid = (SELECT oid FROM
> quotes WHERE lastdayshown IS NULL LIMIT 1) ;

i managed this now in php. works fine
but the idea was to put this structure into the database, so the db user just
have to send one select and once a day there is an automagical update.

maybe its not possible...

thanks
janning

--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de