I need to randomly select 10 winners phone numbers from mysql database with php without repeatation one after the other
sparkles_links 0 Newbie Poster
pritaeas 2,211 ¯\_(ツ)_/¯ Moderator Featured Poster
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.
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.