Member Avatar for mpc123

Hi im trying to random showing items from data base and when echoed the same ones appear? If anyone could help that would be great. This is the query

SELECT * FROM TABLE1, TABLE2 WHERE FIND_IN_SET(TABLE2.FIELD1, TABLE1.FIELD1) and `FIELDNAME` >= RAND() LIMIT 10
Edited by pritaeas because: Moved.
  • 2 Contributors
  • 1 Reply
  • 146 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Care to share your solution?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.