Member Avatar for sparkles_links

I need to randomly select 10 winners phone numbers from mysql database with php without repeatation one after the other

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 31 Minutes Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Add an extra column to indicate the ones that have been selected (1 for selected, 0 for not yet selected) and then use in your query WHERE selected=0 ORDER BY RAND() LIMIT 10 After that update those records.

Edited by pritaeas
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.