select random products (records) from mysql database.

Discussion in 'PHP' started by Kyriakos, May 30, 2008.

  1. #1
    i want to select some random products from mysql database. i want also to set the number of random products that must appear in php page.
     
    Kyriakos, May 30, 2008 IP
  2. Freud2002

    Freud2002 Peon

    Messages:
    29
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SELECT * FROM products ORDER BY RAND() LIMIT 12
     
    Freud2002, May 30, 2008 IP