# Update sql with looping

**URL:** <https://forum.kirupa.com/t/update-sql-with-looping/321343>\
**Category:** programming\
**Created:** [April 17, 2011, 9:27am UTC](https://forum.kirupa.com/t/update-sql-with-looping/321343 "2011-04-17T09:27:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sinyi88](https://avatars.discourse-cdn.com/v4/letter/s/ed8c4c/32.png) [@sinyi88](https://forum.kirupa.com/u/sinyi88)\
**Post date:** [April 17, 2011, 9:27am UTC](https://forum.kirupa.com/t/update-sql-with-looping/321343/1 "2011-04-17T09:27:26Z")

</div>

```auto

$query_query1="SELECT * FROM patterns WHERE status='$radiobutton' ORDER BY id";
   $result_query1= mysql_query($query_query1);
   $j=0; 
 
do {       
  $query_query= "UPDATE patterns SET patpic='../nailbg$alphabet/image $j.jpg' where status='$radiobutton'";    
     $result3 = mysql_query($query_query) or die(mysql_error());     
   $j++;
   die($query_query);
   } 
  while ($row_query = mysql_fetch_assoc($result_query1)); 
 
 
It shows this: UPDATE patterns SET patpic='../nailbgC/image 0.jpg' where status='2'
 

```

I want to update with different name for each data,but it seems no loop and updated with image 0.jpg for all data.

So,any suggestion?