[thelist] mysql select query

[Martin Kuplens-Ewart]

<snip>
SELECT * FROM $db.$table WHERE ((SectionID = $SectionID AND Live = 1) OR
(Section ID = $SectionID2 AND Live = 1)) AND Published = 1 ORDER BY
RAND() LIMIT 3
</snip>

[I assume you've got something like a SectionID defined...]
[Also assuming that you have a checkboks or whatever for liveness... If
it's a status, I'm sure you'll know how to modify.]
[If you find yourself getting dupe articles... Try replacing the * with
'DISTINCT ContentID [or whatever the unique ID is.]

hth

-m

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of kris burford
[midtempo]
Sent: April 4, 2002 9:30 AM
To: thelist at lists.evolt.org
Subject: [thelist] mysql select query


sorry, me again.

trying to wrestle with sql statement and was hoping for some pointers.
i've a table containing story articles and their relevant story sections
which can be published/unpublished _and_ live/archived. am trying to
select a limited number of random stories that are published and, if
they're from particular sections, only live.

so basically i've need a statement that does:

select stuff from stories where published is not null and, if its a news
story or a feature story, make sure live is not null, order by random
limit 3

it's the "if it's a news story..." bit that i'm stumped on.

any help *really* appreciated.

tia

kris
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !