how to save selected data in mysql using php

[samuel_lopez]

 THis is my current code but it's not working

 

 

$sqlgetstud = $mysqli->query("Select stud_id, namestud from students");


      while($retvalran = mysqli_fetch_array($sqlgetstud ))

      {

      $a = $retvalran['sstud_id'];

      $b = $retvalran['namestud'];

      foreach ($a as $key => $b)

      {

       $sql = $mysqli->query("Insert into newstudent(stud_id,Name)

      VALUES('".$key."','".$b."');

      }

      }

Edited October 28, 2015 by samuel_lopez

[0x00]

You are looping over this variable you have just fetched from the database:

 

$a = $retvalran['sstud_id'];

 

Its only going to be a simple datatype, since its named *id, I'm guessing its an integer... and not an associative array

[Barand]

Also, $retvalran['sstud_id'] does not exist - the column name is 'stud_id' and not 'sstud_id'.

 

 

 

If you are just transferring data from students table to newstudent table then all you need is a single query

INSERT INTO newstudent (stud_id, name) SELECT stud_id, namestud FROM students