While looping sql query

Question

I am trying to update all of the rows in a table in my database with a different value. I am trying to while loop the query to do this. Here's what I have...

<?php
$rand = rand(100,150000);
$start = 1;
$start += $start;
$start2 = $start +1;
echo $start;
while($start =< 686) {
echo "UPDATE table_video SET total_view = $rand WHERE id BETWEEN $start AND $start2;";
};
?>

I am sure most of you should be able to look at my code and understand what I am trying to accomplish. I would like the assistance. Thank You very much!

You only echo the query, never execute.. $rand also will only be generated once. All records will have the same integer on each iteration. You should put the assignment in the loop. — chris85
– chris85, Commented Feb 12, 2017 at 23:37
I'm trying to understand the $start thing... you initialise it to 1. Then you add 1 ($start = 2) and then $start2 is $start + 1 which is 3. (I don't know why you do all of that tbh. Then you make a while-statement that never ends because you're never increasing the $start (so it always is $start =< 686). — barbarity
– barbarity, Commented Feb 12, 2017 at 23:40
why you use a LOOP? instead just update all the columns with a random value? — Juan Carlos Oropeza
– Juan Carlos Oropeza, Commented Feb 12, 2017 at 23:52
What I want is for the first instance to echo UPDATE table_video SET total_view = 74956 WHERE id = 1; then UPDATE table_video SET total_view = 54687 WHERE id = 2; ... I made a mistake in my question, the BETWEEN was for a different trial and error. — Donald Faulknor
– Donald Faulknor, Commented Feb 12, 2017 at 23:52

Juan Carlos Oropeza · Accepted Answer · 2017-02-12 23:55:09Z

1

Use the mySQL RAND() function, min and max your range for the random values. I belive on this case are (100,150000)

UPDATE table_video 
SET total_view =  ROUND( (RAND() * (max-min)) +min )
WHERE id BETWEEN 1 AND 686;

answered Feb 12, 2017 at 23:55

Juan Carlos Oropeza

48.4k14 gold badges87 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Donald Faulknor Over a year ago

That worked. Thank You very much @JuanCarlosOropeza

Collectives™ on Stack Overflow

While looping sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related