php nested while loop. Inner loop works only once [closed]

by

Try This: 

<?php  

//connect to the database 
    $con=mysql_connect("localhost","root","") or die("Error in connection");
    mysql_select_db("riffadb",$con)or die("Error in database");
// 
    $sql1 ="select category_id,category_code from category";
    $res1 = mysql_query($sql1); 


    $i=0;
    $j=1000;
    while($row1 = mysql_fetch_array($res1))
    {
        echo $row1['category_code'];
        echo '<br/>';
          // execute second query under the first loop
         $sql2 = "select category_id1,product_id  from product";
         $res2 = mysql_query($sql2);

        while($row2 = mysql_fetch_array($res2))
        {   
            if($row1['category_code'] == $row2['category_id1'])
            {   
                $sql3 = "update product set category_id = ".$row1['category_id']." where product_id = ".$row2['product_id'];
                echo '<br/>';
                mysql_query($sql3);
            }
        }
        $i++;
    }
    echo $i;
?>

More Related Contents:

  1. While loop within While loop not looping
  2. Sign in form always showing "Wrong Credentials"
  3. Prevent creating duplicate entries in PHP
  4. php/mysql with multiple queries
  5. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  6. Using PHP read word in textarea line by line and insert to mySQL
  7. Update Select Query
  8. PHP / PDO echo data from database into a table
  9. Use PHP to render multiple images to the browser [closed]
  10. MySQL connection not working: 2002 No such file or directory
  11. Sum values of multidimensional array by key without loop
  12. mysqli: can it prepare multiple queries in one statement?
  13. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  14. What is the best collation to use for MySQL with PHP? [closed]
  15. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  16. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  17. Do SQL connections opened with PDO in PHP have to be closed
  18. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  19. mysql select query within a serialized array
  20. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in php [duplicate]
  21. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  22. What is the advantage of using try {} catch {} versus if {} else {}
  23. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  24. How to convert ISO8601 to Date format in php
  25. Algorithm for generating a random number
  26. return one value from database with mysql php pdo
  27. onbeforeprint() and onafterprint() equivalent for non IE browsers
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. MySQL & PHP Parameter 1 as Resource
  30. mysql_connect VS mysql_pconnect [closed]

Leave a Comment