$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?