Back to discussion

random banner

Last post was 23 Jul 2002 at 21:33
php United States
  • 18 years ago

    i have a table called bannerads
    which fields are
    id,bannerpic,site_address
    I want to display these as a random banner
    at the moment there are 5 rows in this table.
    How would i do that

    Report abuse
  • 18 years ago

    I have posted a new code on this site named Storing / Retrieving pictures from database I think It will help you. or try this link


    See this


    Report abuse
  • 18 years ago

    SELECT * FROM bannerads ORDER BY RAND() LIMIT 1


    that should do what you want it to

    Report abuse
  • 18 years ago

    So just call the DB and where youd put the Select add this to it. What if I have 1+ Banners

    Report abuse
  • 18 years ago

    then change the limit to what ever number you want to be displayed.

    Report abuse
  • 18 years ago

    Thanks heaps

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

PHP forum discussion

PHP tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“There's no test like production” - Anon