Posted by James54321 on 10/21/07 11:03

On Oct 18, 2:49 pm, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 18 Oct 2007 15:40:26 +0200, James54321 <webmas...@jstokell.co.uk>
> wrote:
>
>
>
> > Hi, I did quite a bad subject heading so I'll try to explain it better
> > here.
>
> > I have a website (it is indeed really bad right now, I know that, so
> > please don't remind me). For a very long time now I have wanted it to
> > display a random slogan of my site from all of the possible slogans
> > that are stored in my MySQL database. I have recently found out how
> > to count the rows of a MySQL table and so I have made a script that
> > will select an appropriate row (according to the list of rows 1-12 for
> > example). BUT the problem I am having is that if i have a row that
> > I've deleted then that row can still be selected, as I have no way
> > (that I know) as to reference which rows are not deleted ..to be able
> > to ONLY show the slogans and not just an empty row of nothingness.
>
> > Is this possible, and if so, how?
>
> > P.S.
> > You can see the page which outputs the relevant random number here:
> >http://flavouredcandy.com/page.php?id=2(its just under the right
> > banner).
>
> Use RAND() in MySQL to select a random slogan from the database.
>
> $chosen_slogan = mysql_query('SELECT slogan_id FROM slogans ORDER BY
> RAND() LIMIT 1');
>
> --
> Rik Wasmus

I'll try that now, and if it works thats really really clever, thank
you.

James.

[Back to original message]