Random selection

[Binay Agarwal]

Hi

You can use "select distinct names from table_name order by rand() limit 3".
Hope this helps and let me know.

cheers
Binay


----- Original Message -----
From: <fkeessen@planet.nl>
To: <php-general@lists.php.net>
Sent: Saturday, August 23, 2003 6:36 PM
Subject: [PHP] Random selection

> Hi,
>
> Can you help me with this one??
>
> In my mysql db i have a colum called names;
>
> In names their are:
>
> Frank
> Frank
> Bob
> Alice
> Bob
> Alice
> Jim
> Alice
> Frank
>
> I want to make a random selection (max 3 value's for example).. Only it

may not produce two times the same name. For example;

>
> This is the output:
>
> Frank, Jim, alice
>
> Wrong output
>
> Frank, Frank, Jim
>
> Please help!
>
> Thanks,
>
> Frank
>
>
>

----------------------------------------------------------------------------
----

> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

[fkeessen@planet.nl]

Hi,

Can you help me with this one??

In my mysql db i have a colum called names;

In names their are:

Frank
Frank
Bob
Alice
Bob
Alice
Jim
Alice
Frank

I want to make a random selection (max 3 value's for example).. Only it may not produce two times the same name. For example;

This is the output:

Frank, Jim, alice

Wrong output

Frank, Frank, Jim

Please help!

Thanks,

Frank

[Jim Lucas]

Try this:

SELECT name FROM table GROUP BY name ORDER BY RAND() LIMIT 3

This will group together all the names and then choose from a list that has
only unique names and then return 3 at random.

Jim Lucas

----- Original Message -----
From: <fkeessen@planet.nl>
To: <php-general@lists.php.net>
Sent: Saturday, August 23, 2003 6:06 AM
Subject: [PHP] Random selection

> Hi,
>
> Can you help me with this one??
>
> In my mysql db i have a colum called names;
>
> In names their are:
>
> Frank
> Frank
> Bob
> Alice
> Bob
> Alice
> Jim
> Alice
> Frank
>
> I want to make a random selection (max 3 value's for example).. Only it

may not produce two times the same name. For example;

>
> This is the output:
>
> Frank, Jim, alice
>
> Wrong output
>
> Frank, Frank, Jim
>
> Please help!
>
> Thanks,
>
> Frank
>
>
>

----------------------------------------------------------------------------
----

> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

[pwiop]

I have a number of details stored in an xml document that I use to dynamically
create content on a webpage. I have sorted it so only four items are displayed.

All fine and dany so far and working a treat.

What I want to know is, is it possible to randomly select four items from the
xml files each time the page is accessed or refreshed

If it is any help the code I am using at present in the xsl file is here;

<xslaram name="itemsPerPage" select="5" />
<xsl:template match="/">
<h1><xsl:value-of select="rss/channel/title"/></h1>
<div id="intro"><xsl:value-of select="rss/channel/description"
disable-output-escaping="yes"/></div><br /><!--<p>-->

<xsl:for-each select="rss/channel/item[position() <= $itemsPerPage]">

<h2><xsl:value-of select="title"/></h2>
<div id="dateShow">Date posted - <xsl:value-of select="pubDate"/></div>
<p><xsl:value-of select="description" disable-output-escaping="yes"/><br
/><a href="{link}">more . . .</a></p><br />
</xsl:for-each>

<p><a href="#">More NEWS :: EVENTS :: UPDATES</a></p>
<!--</p>-->

</xsl:template>