WampServer

I'm trying to randomize a data from my SQL database using PHP - and I'm displaying the results in an HTML page.


It works fine using this code:

$random = mysqli_query($con,"SELECT * FROM tbData WHERE Selected != 0 order by RAND() LIMIT 1" ) ;
$row = mysqli_fetch_array($random);

I'm retrieving the names in the 'Name' column.

The problem is I want to prevent duplicates from being 'drawn'; so I added a second column named 'Selected' and added '1' as default to all records. So the code snippet above selects from any records that has '1' in the 'Selected' column, so logically, I need to turn this '1' into a '0' to prevent it from being 'drawn'.

I'm working with this second code block to do it, but it seems to fail in changing the '1's to '0's:

$random1 = mysqli_query($con,"UPDATE tbData SET Selected = '0' WHERE Name = ".$row['Name']." " ) ;

Any help with this?



Edited 1 time(s). Last edit at 11/13/2017 05:30AM by iamruthermelchor.

Hi,

This question is not On Topic
This site is for people having issues getting WAMPServer running and not a general HOW DO I site for everything web or database or PHP related.

But, as we are very nice, look at DISTINCT in the syntax of a SELECT query:
[dev.mysql.com]
I will not give any answer on this subject. Check out sites related to MySQL and its queries.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons