PHP - Insert Into Won't Work

My while loop to do the process to every member_id won't work.Its only printing one member_id thats done.Also my INSERT statement wont insert even that 1 member_id. Can someone please point my mistake.
Code: [Select]
<?php
include 'config.php';
    
function tree_gather($node)   
  {
     
 $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']) || !empty($array['rchild']))
    {
      if(!empty($array['lchild']))
      $child[] = $array['lchild'];
      if(!empty($array['rchild']))
      $child[] = $array['rchild'];
      if(!empty($array['lchild']))
      $lchild = tree_gather($array['lchild']);
      if(!empty($array['rchild']))
      $rchild = tree_gather($array['rchild']);
      if(!empty($lchild) && !empty($rchild)) {
      $merge_both = array_merge($lchild, $rchild);
      $child = array_merge($child, $merge_both);    
      }
      elseif(!empty($lchild) && empty($rchild))
      $child = array_merge($child, $lchild);
      elseif(!empty($rchild) && empty($lchild))
      $child = array_merge($child, $rchild); 
     
    } 
     return $child;
  } 
  
$sql = mysql_query("SELECT member_id FROM member");
while($array = mysql_fetch_array($sql)) {
    
$memid = $array['member_id'];

$pair = tree_gather($memid)  ;

$remove = mysql_query("SELECT lchild,rchild FROM tree WHERE parent ='".$memid."'");
$remove_array = mysql_fetch_array($remove);
if(!empty($remove_array['lchild']) || !empty($remove_array['rchild']))
{
   $count = count($pair);
    for($i = 0 ; $i < $count ; $i++) {
        if($pair[$i] != $remove_array['lchild'] && $pair[$i] !=$remove_array['rchild']) {
            $trimmed[] = $pair[$i];
        }
        else {
            $two_one[] = $pair[$i];
        }
    }
}

$add = mysql_query("SELECT lchild,rchild FROM tree WHERE parent='".$remove_array['lchild']."'");
$add_array = mysql_fetch_array($add);
if(!empty($add_array['lchild']) || !empty($add_array['rchild'])) {
    $count = count($trimmed);
    for($i=0;$i < $count ; $i++) {
        if(!empty($add_array['lchild'])) {
            if($add_array['lchild'] == $trimmed[$i]) {
                $two_one[] = $add_array['lchild'];
                unset($trimmed[$i]);
                $done = 1;
                break;
                
            }
        }    
        if(!empty($add_array['rchild']) && $done !=1) {
            if($add_array['rchild'] == $trimmed[$i]) {
                $two_one[] = $trimmed[i];
                unset($trimmed[$i]);
                $done = 1;
                break;
                
            }
        }    
               
    }
}

if($done != 1) {
    
    $add = mysql_query("SELECT lchild,rchild FROM tree WHERE parent='".$remove_array['rchild']."'");
    $add_array = mysql_fetch_array($add);
    if(!empty($add_array['lchild']) || !empty($add_array['rchild'])) {
    $count = count($trimmed);
    for($i=0;$i < $count ; $i++) {
        if(!empty($add_array['lchild'])) {
            if($add_array['lchild'] == $trimmed[$i]) {
                $two_one[] = $add_array['lchild'];
                unset($trimmed[$i]);
                $done = 1;
                break;
                
            }
        }    
        if(!empty($add_array['rchild']) && $done !=1) {
            if($add_array['rchild'] == $trimmed[$i]) {
                $two_one[] = $trimmed[i];
                unset($trimmed[$i]);
                $done = 1;
                break;
                
            }
        }    
               
    }
}
    
}  
  
  $select_child = mysql_query("SELECT rchild,lchild FROM tree WHERE parent='".$memid."'");
  $select_array = mysql_fetch_array($select_child);
  
  if(!empty($select_array['rchild']))
  $rchild = tree_gather($select_array['rchild']);
  $rchild[] = $select_array['rchild'];
  
  if(!empty($select_array['lchild']))
  $lchild = tree_gather($select_array['lchild']);
  $lchild[] = $select_array['lchild']; 
  
  if(!empty($rchild)) {
      $right_count = count($rchild);
      
      }
 
  if(!empty($lchild)) {
      $left_count = count($lchild);
      
      
  }
 
    
if($right_count < $left_count) {

    $pair_num = $right_count;
    
    }    

elseif($right_count == $left_count)
{
     $pair_num = $right_count - 1;
}
    else {

    $pair_num = $left_count;

    }
    if(count($two_one) == 3) {
        $dues_adjust = 100;
    
    if($pair_num >= 1) {
        $dues_adjust = $dues + 100; 
        $calcom = 200 * $pair_num;
        $tds = 20.60 * $pair_num;
        $service = 9.40 * $pair_num;
        $paid = $calcom - $dues_adjust;
        $insert = mysql_query("INSERT INTO `payout` (member_id, binary, tds, service, total, dues, amount_paid, dues_adjust, pairs) VALUES ('".$memid."', '".$calcom."', '".$tds."', '".$service."', '".$calcom."', '0', '".$paid."', '".$dues_adjust."', '".$pair_num."')");
        unset($pair);
        
        echo "<br />".$memid." Done";
    }
    }
    
    
}
?>

Hi coders,     i have a js to add multiple input and its depend to a user how many input should he want to add. and my problem is, it work insert data in a first line of rows but the rest of rows are not save.   any idea, what should i add to make it work.    js

<script>
$(document).ready(function(){
  $('#add').click(function(){
   var inp = $('#box');
   var i = $('input').size() + 1;
      $('<div id="box' + i +'"><input type="text" id="name" class="name" name="code[]' + i +'" placeholder="Input '+i+'"/><img src="remove.png" width="32" height="32" border="0" align="top" class="add" id="remove" /> </div>').appendTo(inp);
				
i++;
});
$('body').on('click','#remove',function(){
$(this).parent('div').remove();
});
});
</script>

html

<div id="box">
<input name = "code[]" type="text" id="name" class="name" placeholder="Input 1">
<img src="add.png" width="32" height="32" border="0" align="top" class="add" id="add" />
</div>

php

$rf = $_POST['regform'];
$b = $_POST['branch'];
$d = $_POST['date'];
$c = $_POST['code'];
$u = $_POST['user'];
				
for($i = 0; $i<count($c); $i++)
  {
    $a_query = mysql_query("INSERT INTO code_number(ts_number,branch_id,yy,code,username) VALUES('$rf','$b','$d','$c[$i]','$u')");
  }		
  return $a_query;

Hi Guys, in code below i dont see any reason why it doesnt add anything into my mysql, can u please tell me where is wrong?


<?php
session_start();
include ("includes/db.php");
include ("includes/function.php");
//authentication
if (loggedin()==FALSE)
{
Header("Location: login.php");
exit();
}
//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];
echo "Welcome, " .$_SESSION['username']."!<p>";
//get details from user table to be passed to page(text fields)

$getdetails=mysql_query("SELECT * FROM users WHERE username='$username'");
while($row = mysql_fetch_array($getdetails))
{
$users_id=$row['id'];
$first_name=$row['first_name'];
$last_name=$row['last_name'];
$email=$row['email'];

}

///////////////////////////////////////
//****************************//


//post starts here
if (isset($_POST['next']) && $_POST['next'])
    {


$myfirstname = addslashes(strip_tags($_POST['firstname']));
$mylastname = addslashes(strip_tags($_POST['lastname']));
$myemail = addslashes(strip_tags($_POST['email']));
$mybookingdate = addslashes(strip_tags($_POST['datetime']));
$mytime = addslashes(strip_tags($_POST['time']));
$myseatnumber = addslashes(strip_tags($_POST['seatnumber']));
$ride_id=1;

//check if booking exists

$checkbooking=mysql_query("SELECT * FROM booking WHERE date='$mybookingdate' AND time='$mytime' AND seat_no='$myseatnumber'");
   if (mysql_num_rows($checkbooking)>=1)
   {
           echo "Seat No $myseatnumber For $mybookingdate at $mytime has been already taken, Please try a different seat, time or date";
   }
else
{
$addbooking=mysql_query("INSERT INTO booking (ride_id, users_id, time, date, seat_no) VALUES ('$ride_id','$users_id','$mytime','$mybookingdate','$myseatnumber'");
}
}



?>
<html>
<head>

<link type="text/css" href="css/smoothness/jquery-ui-1.8.6.custom.css" rel="stylesheet" />

<script type="text/javascript" src="includes/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="includes/jquery-ui-1.8.6.custom.min.js"></script>


<script type="text/javascript">  


 $(function() {  
    $('#datetime').datepicker({  
dateFormat: 'dd.mm.yy'
 });  
});  
</script>

</head>

<body>

<form name="booking" method="post" action="">

  <p>First Name:<br />
    <input type="text" name='firstname' value="<? echo "$first_name";?>">
    
<p>Last Name:<br />
  <input type="text" name='lastname' value="<? echo "$last_name";?>">
    
<p>Email:<br />
  <input type="text" name='email' value="<? echo "$email";?>">


<p>Choose a Date:<br />
    <input type="text" name='datetime' id="datetime">
        </p>
<p>
        Select a Time:<br/>
  <select name='time'>
    <option value="9:00">9:00
    <option value="9:07">9:07
    <option value="9:14">9:14
    <option value="9:21">9:21
    <option value="9:28">9:28
    <option value="9:35">9:35
    <option value="9:42">9:42
    <option value="9:49">9:49
    <option value="9:56">9:56
    <option value="10:03">10:03
    <option value="10:10">10:10
    <option value="10:17">10:17
    <option value="10:24">10:24
    <option value="10:31">10:31
    <option value="10:38">10:38
    <option value="10:45">10:45
    <option value="10:52">10:52
    <option value="10:59">10:59
    <option value="11:02">11:02
    <option value="11:09">11:09
    <option value="11:16">11:16
    <option value="11:23">11:23
    <option value="11:30">11:30
    <option value="11:37">11:37
    <option value="11:44">11:44
    <option value="11:51">11:51
    <option value="11:58">11:58         
    </select>
        </p>
<p>
          
  Select Seat Number:<br/>
  <select name='seatnumber'>
    
    <option value="1">Seat 1
      <option value="2">Seat 2
        <option value="3">Seat 3
          <option value="4">Seat 4
          <option value="5">Seat 5
          <option value="6">Seat 6
          <option value="7">Seat 7
          <option value="8">Seat 8
          <option value="9">Seat 9
          <option value="10">Seat 10
          <option value="11">Seat 11
          <option value="12">Seat 12
          <option value="13">Seat 13
          <option value="14">Seat 14
          <option value="15">Seat 15
          <option value="16">Seat 16
          <option value="17">Seat 17
          <option value="18">Seat 18
          <option value="19">Seat 19
          <option value="21">Seat 20
          <option value="22">Seat 22
          <option value="23">Seat 23
          <option value="24">Seat 24
          <option value="25">Seat 25
          <option value="26">Seat 26
          <option value="27">Seat 27
          <option value="28">Seat 28
          <option value="20">Seat 29
          <option value="30">Seat 30
          <option value="31">Seat 31
          <option value="32">Seat 32
          <option value="33">Seat 33
          <option value="34">Seat 34
          <option value="35">Seat 35
          <option value="36">Seat 36
          <option value="37">Seat 37
          <option value="38">Seat 38
          <option value="39">Seat 39
           <option value="40">Seat 40
           <option value="41">Seat 41
           <option value="42">Seat 42
           <option value="43">Seat 43
           <option value="44">Seat 44
           <option value="45">Seat 45
           <option value="46">Seat 46
           <option value="47">Seat 47
           <option value="48">Seat 48                                                                                              
                 </select>                                                          
                                                                                            

<p>
  <input type='submit' name='next' value='Next Step'>
</form>
<p>
    </body>
    
</html>

Code: [Select]
<?php
include_once("includes/config.php");
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><? $title; ?></title>
<meta http-equiv="Content-Language" content="English" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
</head>
<body>
 
<div id="wrap">
 
<div id="header">
<h1><? $title; ?></h1>
<h2><? $description; ?></h2>
</div>
 
<? include_once("includes/navigation.php"); ?>
 
<div id="content">
<div id="right">
<h2>Create</h2>
<div id="artlicles">
<?php
 
if(!$_SESSION['user'])
{
 
        $username = $_POST['username'];
        $password = $_POST['password'];
        $name = $_POST['name'];
        $server_type = $_POST['type'];
        $description = $_POST['description'];
 
        if(!$username || !$password || !$server_type || !$description || !$name)
        {

        echo "Note: Descriptions allow HTML. Any abuse of this will result in an IP and account ban. No warnings! All forms are required to be filled out.<br><form action='create.php' method='POST'><table><tr><td>Username</td><td><input type='text' name='username'></td></tr><tr><td>Password</td><td><input type='password' name='password'></td></tr>";
        echo "<tr><td>Sever Name</td><td><input type='text' name='name' maxlength='35'></td></tr><tr><td>Type of Server</td><td><select name='type'>
       
        <option value='Any'>Any</option>
        <option value='PvP'>PvP</option>
        <option value='Creative'>Creative</option>
        <option value='Survival'>Survival</option>
        <option value='Roleplay'>RolePlay</option>
       
        </select></td></tr>
       
        <tr><td>Description</td><td><textarea maxlength='1500' rows='18' cols='40'></textarea></td></tr>";
        echo "<tr><td>Submit</td><td><input type='submit'></td></tr></table></form>";
        }
        elseif(strlen($password) < 8)
        {
        echo "Password needs to be higher than 8 characters!";
        }
        elseif(strlen($username) > 13)
        {
                echo "Username can't be greater than 13 characters!";
        }
        else
        {
                $check1 = $db->prepare("SELECT username,name FROM servers WHERE username = ? OR name = ? LIMIT 1");
                $check1->execute(array($username, $name));
               
                if($check1->rowCount() > 0)
                {
                        echo "Sorry, there is already an account with this username and/or server name!";
                }
                else
                {
                        $ip = $_SERVER['REMOTE_ADDR'];

                        $insertQuery = $db->prepare("INSERT INTO servers (id, username, password, name, type, description, ip, votes, beta) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
                        $insertQuery->execute(array(null, $username, $password, $name, $server_type, $description, $ip, 0, 1));

if($insertQuery->errorInfo() > 0)
{
echo "Sorry, there was the following error:";
print_r($insertQuery->errorInfo());
}
else
{
                        echo "Server has been succesfully created!";
}
                }
        }
       
}
else
{
        echo "You are currently logged in!";
}
 
?>
</div>
</div>
 
<div style="clear: both;"> </div>
</div>
 
<div id="footer">
<a href="http://www.templatesold.com/" target="_blank">Website Templates</a> by <a href="http://www.free-css-templates.com/" target="_blank">Free CSS Templates</a> - Site Copyright MCTop
</div>
</div>
 
</body>
</html>

Whats wrong with that page? :/

MySQL version 5.1.73-cll   I can't seem to get the inventory table to insert the information I have stared in an array any help would be appreciated!!

<?php
$username = $_SESSION['username'];
ini_set('display_errors',1); 
error_reporting(E_ALL);
	
	//include "php/db/db_config.php";
	include "php/db/db_config.php";
	include "php/db/item_connect.php";
	
	$id = $items_id['id'];
	$player = $account_info['player_id'];
	
	//Update database
	$sql = mysqli_query($my_database,"INSERT INTO inventory ( player_id, username, id ) VALUES('$player', '$username', '$id')");
				
//echo values of item id		
echo "<div class=\"loot\">";	
echo "<b>Required Level:" . $items_id['requ_level'] . "</b><br />";
echo "<b>Name:" . $items_id['name'] . "</b><br />";
echo "<b>Min Str:" . $items_id['min_str'] . "<br />";
echo "<b>Min Int:" . $items_id['min_int'] . "<br />";
echo "<b>Min Dex:" . $items_id['min_dex'] . "<br />";
echo "<b>Type:" . $items_id['type']. "<br />";
echo "<b>Min Physical Dmg:" . $items_id['min_dmg'] . "<br />";
echo "<b>Max Physical Dmg:" . $items_id['max_dmg'] . "<br />";
echo "<b>Min Magic Dmg:" . $items_id['mag_attk_min'] . "<br />";
echo "<b>Max Magic Dmg:" . $items_id['mag_attk_max'] . "<br />";
echo "<b>Phys Defense:" . $items_id['phy_def'] . "<br />";
echo "<b>Magical Defense:" . $items_id['mag_def'] . "<br />";
echo "</div>";
?>

I get no errors or notices and the info fields show up as being populated.