Random posts from mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alcstudio
    New Member
    • Sep 2007
    • 24

    Random posts from mysql

    Hey there. i wonder how i do to get 4 radom posts displayed on my webpage from mysql.

    For example. If i have total 10 images and every time i reload the page it changes between this 10 and show 4.
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    Select images at random from your gallery table and show them, e.g.
    [php]SELECT * FROM gallery ORDER BY RAND() LIMIT 4[/php]
    Ronald

    Comment

    • alcstudio
      New Member
      • Sep 2007
      • 24

      #3
      Thanks. I have used Access for to long.

      Comment

      • ronverdonk
        Recognized Expert Specialist
        • Jul 2006
        • 4259

        #4
        You are welcome. See you next time.

        Ronald

        Comment

        Working...