PHP - Must Be An Easier Way? - Display Data From Database Under Category Heading

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=321339.0

Hi guys,

Should be a simple 1.

If i have the following at the top of the page:


$page_views = $row['page_views'] + 1;
mysql_query("UPDATE table SET page_views='$page_views'");


and then the following at the bottom of the page:


echo $row['page_views'];


Should I see the page views as 1 the first time the page is visited, 2 the second time the page is visited, and so on......?
At the moment im seeing 0 on the first page visit, 1 on the second page visit, 2 on the third.....

I had this problem before on another page i was working, and i simply solved it by displaying the mysql query above the echo similar to the code above. However now it does not seem to be working.

Am i missing something really simple? lol

Thanks

This is actually a page to edit the drama details.
Database-  3 tables

1. drama                           dramaID    drama_title
                                              1              friends

2. drama_genre             drama_genreID     dramaID    genreID
                                               1                        1               2
                                               2                        1               1
                                               3                        1               3
3. genre                              genreID       genre
                                                1            comedy
                                                2            romance
                                                3            family
                                                4            suspense
                                                5            war
                                                6            horror

<?php       

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'drama';
$link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');

$id = $_GET['dramaID'];

$link2 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql2 = "SELECT * from drama , drama_genre , genre
WHERE drama.dramaID='".$id."' AND drama_genre.dramaID='".$id."' AND drama.dramaID = drama_genre.dramaID AND drama_genre.genreID = genre.genreID";
$status2 = mysqli_query($link2,$sql2) or die (mysqli_error($link2));

$link3 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql3 = "SELECT * from genre ";
$status3 = mysqli_query($link3,$sql3) or die (mysqli_error($link3));

<form method='Post' action='doUpdate.php' enctype="multipart/form-data">

<?php while ($row2 = mysqli_fetch_assoc($status2)) { ?>
                  <td height="1"></td>
               
                             <td><select name="gdrop">      
                     
      <option value="<?php echo $row2['genreID'];?>"><?php echo $row2['genre'];?></option>
                     
      <?php while ($row3 = mysqli_fetch_assoc($status3)) { ?>
                        
      <option value="<?php echo $row3['genreID'];?>"><?php echo $row3['genre'];?></option>
                     
                     
      <?php }   mysqli_close($link3);  ?>
                     
 <input type='hidden' id='drama_genreID' name='drama_genreID' value = "<?php echo          $row2['drama_genreID']; ?>"/>
                 </select>

<input type="hidden" id="dramaID" name="dramaID" value = "<?php echo $row['dramaID'];?>"/>
<input type="submit" Value="Update"/>
 
The result was there were 3 dropdown menus but only the first dropdown menu has all 6 genres from my database and also the genre that belongs to the drama.

I'm also wondering how I can bring all the drama_genreIDs to my save(doupdate.php) page and update all 3 of them because it seems like only the last dropdown menu's data is saved.

And also how can I display only 6 genres instead of 7 with the genre that belongs to the drama , being set as the default selection.


                                       

As a complete newbie to php and webdesigning i have a following problem.I would like to retrieve the data from database and display it in a drop down menu.Then i should allow the user to select the values from drop down list along with other details,in other words i have to embed the drop down output as the form input for the user and store the form data in another table.I am running a xampp server and i am using php 5.4 version.Please help.My code is as follows.In this case project_name is displayed as the drop down output.but how do i use the same drop down output as a input in the form.
 
 
 
<html>
<head></head>
<body>
<?php
error_reporting(E_ALL ^ E_DEPRECATED);
include 'connect.php' ;
$tbl_name="projects";


$sql="SELECT project_name FROM $tbl_name ";

$result=mysql_query($sql);


if($result === FALSE) {
    die(mysql_error());
}
?>


<form name="resources" action="hourssubmit.php"  method="post" >

<?php
echo "<select name='project_name'>";
while ($row = mysql_fetch_array($result)) {
    
    echo "<option value='" . $row['project_name'] ."'>" . $row['project_name'] ."</option>";
}
echo "</select>";
?>

</form>
</body>
</html>

Hi all.

This seems like a pretty basic function but I can't work it out.

I'm developing a WordPress site and want to list posts (products) by category. I'm using Advanced Custom Fields and have set up the taxonomy of 'category'.

I just want to produce a heading for that category and then list all of the posts with that category assigned.

Please see below functions.php excerpt and section-archive.php excerpt.

Can anyone please help??? Massive good karma if you can.

----------------------- functions.php --------------------------------------

//Assign Category to Products

function taxonomy ()
{

    $args = array (
    
        'labels' => array(
            
            'name' => 'Category',
            'singular_name' => 'Category',
        ),    
        'public' => true,
        'hierarchical' => true, 
    
    );
    
    register_taxonomy('name', array('products'), $args);

};
add_action('init', 'taxonomy');

?>

------------------------- section-archive.php ------------------------------------------------

<?php if(have_posts()):while(have_posts()): the_post();?>

  

****** if product category= this

***** Category heading

****** Posts

******* Else

****** if product category= this2

***** Category heading

****** Posts

**** etc

 

 <div class="prod-listing">
    
        <div class="align-top d-flex">
       
            <div class="blog-content">
        
            <h2><?php the_title();?></h2>
        
            <?php the_content();?>
        
            </div>
            
        </div>
    
    </div>
    
<?php endwhile; else: endif;?>

 

 

 

i have 8 division (div), i want to display 4 rows in 4 division and the remain 4 rows in the next 4 division here is my code structure for carousel

<div class="nyie-outer">    
<div class="container">
    <div  id="nyieFull" class="carousel slide carousel-multi-item" data-interval="false" data-ride="carousel">
        <div class="outer-controls-top">
        <div class="nyie-title"><h5>THIS IS NYIE</h5></div>
        <div class="controls-top">    
            <a class="btn-floating" href="#nyieFull" data-slide="prev"><i class="fa fa-chevron-left"></i></a>
            <a class="btn-floating" href="#nyieFull" data-slide="next"><i class="fa fa-chevron-right"></i></a>
        </div>
        </div>
        <div class="carousel-inner" role="listbox">
            <div class="carousel-item active">
                 first row

                 second row

                 third row

                 fourth row
            </div><!--/.First four rows here-->
            <div class="carousel-item">

                  fifth row

                 sixth row

                 seven throw

                 eighth row

            </div><!--/.second four rows here-->
        </div
    </div>    
</div> 
</div>

 

 

sql code   

CREATE TABLE  product(
prodId INT(11) NOT NULL UNIQUE AUTO_INCREMENT, 
image VARCHAR(255) NOT NULL,
prodName VARCHAR(255) NOT NULL,
prodPrice VARCHAR(255) NOT NULL,
description TEXT NOT NULL
PRIMARY KEY (prodId) 
);

php code

<?php 
include_once('db.php');
$sql = "SELECT image,prodName, prodPrice, description FROM product ORDER BY prodId ASC LIMIT 4";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    // output data of each row
        while($row = mysqli_fetch_array($result)) {
            $activeprod =  '
            <div class="col-lg-3">
            <a href="more.php" class="newAdded">    
            <figure class="figure">   
               <img src="images/'. $row['image'] .'" alt="" class="img-responsive" >
                <figcaption class="figure-caption">
                    <span class="prodName"><b>Name: </b>'. $row['prodName'] .'</span>
                    <span class="prodPrice"><b>price: </b>'. $row['prodPrice'] .'</span>
                    <span class="desc"><b>description: </b>'. $row['description'] .'</span>    
                </figcaption>    
            </figure> 
            </a>
            </div>
            ';
    }
} 
?>

how can i echo that result in those rows 

 

 

 

friends my url is like this

Category=Love&ID=1

now in url if i do something like this

Category4637=Hate19203&ID=1

the details are still showing, how can i fix this? if someone type Capegory instead of Category and a wrong category name which do not exist with that id in db send them to index.php?

Hi, im trying to echo some mysql data. What i want to do is under a category show the articles that is for the specific category

have a look at my attachment, the blue is where the categorys titles and below is supposed to show the different articles for the specific category.

Here is my code
Code: [Select]
<div class="NewsCateg">
<div class="NewsCategBG">
<?php 
$query = "SELECT * FROM tblnews_categories WHERE ShortId != 0 ORDER BY `ShortId`";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{

?>
<div class="quartetin2">
<div id="HomeMoreNewsIMG2"><div id="HomeMoreNewsTitle2"><a href="summary.asp?catid=19167"><?php echo strtoupper($row['Name']);?></a></div></div>
<div id="HomeMoreNewsText">
<?php 
$query2 = "SELECT tblnews.Category, tblnews.Title, tblnews_categories.Id FROM tblnews LEFT JOIN tblnews_categories ON tblnews.Category = tblnews_categories.Id";
$result2 = mysql_query($query2);
while($row2 = mysql_fetch_assoc($result2)) {
?>
<tr>
<td id="HomeLatestNewsDate"><li><?php echo strtoupper($row2['Title']);?></li></td>

</tr>
<?php } ?>



</div>
</div>
<?php } ?>
    </div>
    </div>


Any help please?


Thank you

Hello,

I have been searching and trying all sorts of ways to get my sub categories drop down to show the correct info after selecting a category from the main drop down but im getting stuck.

It's pulling the categories and sub categories from the mysql database fine but no matter which main category i pick it keeps showing the same result in the sub category.

My brother said i need to use some sort of onchange do this so the sub category list refreshs but everything i have tried doesn't work..


PLEASE could some one help.

MANY MANY THANKS


This is the category form
Code: [Select]
  <select name="job_cats" style="width:165px">
    <?PHP

$query1 = "SELECT * FROM job_cats";
$result1 = mysql_query($query1) or die ("query 1 failed");
$count1 = mysql_num_rows($result1);

for ($i = 0; $i < $count1; $i++) {
$row1 = mysql_fetch_array($result1);
$job_cats_title1 = $row1['title'];
$job_cats_id1 = $row1['id'];


echo '<option value="'.$job_cats_id1.'">'.$job_cats_title1.'</option>';

echo $job_cats_id1;
}
    ?>
    </select>
this would echo this in the main category list:

cat1
cat2
cat3
cat4




this is the sub category form
Code: [Select]
  <select name="job_sub_cats" style="width:165px">
 
    <?PHP
$query1 = "SELECT * FROM job_sub_cats WHERE job_cats_id = $job_cats_id1";

$result1 = mysql_query($query1) or die ("query 1 failed");
$count1 = mysql_num_rows($result1);


for ($i = 0; $i < $count1; $i++) {
$row1 = mysql_fetch_array($result1);

$sub_cats_id1 = $row1['id'];
$sub_cats_title1 = $row1['subTitle'];
$cats_id1 = $row1['job_cats_id'];

echo '<option value="'.$sub_cats_id1.'">'.$cats_id1.'</option>';

}
    ?>
    </select>


this should echo this:

1
2
3
4

but it keeps echoing just the number 4.


THANKS
PLEASE HELP

ricky

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

Hi, I've currently started to modify a chat script of mine to output a moderation panel but the moderation page seems empty(blank) every time I load it. What im trying to do is to take the ID part in my URL via the $_GET and look it up in my database table in the column named id, then select that specific row to be able to retrieve the StringyChat_ip and place it into another table to ban the IP and the second thing im trying to do is to be able to delete the specific row from my table.   My Http link look something like    http://imagecrab.fre.../ban.php?id=159   and my ban.php page where I want to lookup the 159 part and do the banning etc looks like

<?
include("admin_code_header.php");


if ($_POST["DeletePost"]) {
    $id = $_POST['id'];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }


if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
  }
$result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'",$db);

  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];
$idm = $myrow["id"];



?>
<html>
<form name="form<? echo $myrow["id"];?>" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<input name="DeletePost" type="submit" id="DeletePost" value="Delete">

<input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
    </form>
</html>
<?
}
?>

Hi..

Sorry, if I need to repost my problem in while loop. cause until now I can't resolve my problem in saving all data from while loop.

I have this code StockRequisition.php where FORM was displayed.

<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }        
            
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);   
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    
    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>

</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">    
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/> 
</div> 
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";       
     
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 
 while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];         
     
    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>     
        </tr>";
}
}   
   
               
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');
   
   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');
   
   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');
   
   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP'); 

?>

 <div id='Requested_By'>
<label>Requested By:</label>
 <select name="RequestedBy">
 <option value="Select">Select</option>
 <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
 <option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
 </select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
 <option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
 <option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
 <option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()">
</div>
</form>
</body>
</html>



and here is StockRequisitionSave.php
code for saving data to database :


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items1', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
";  

$result = mysql_query($sql, $con);            
?>


the problem is only the last data was save.

I will attach my form.

I hope somebody can help me..
I really don't know how can I save all data from form into my database.

Thank you so much for your understanding and help.

Currently what I have is this:

$url="http://www.nfl.com/liveupdate/scorestrip/postseason/ss.xml";
  $ch = curl_init();
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_URL, $url);    // get the url contents
  $data = curl_exec($ch); // execute curl request
  curl_close($ch);
  $xml = simplexml_load_string($data);
  foreach($xml->gms->g as $games)
    {
  	if(!empty($games['vtn']))
    {
     if ((($games['gt']) =='WC') && (($games['q'])== 'F')) {
 	 	echo "<li data-subcategory='Final Scores' data-category='Wild Card Games' data-color='1979ab'><a href='#'>",$games['htn']," ",$games['hs'],"  ",$games['vtn'],"  ",$games['vs'],"&nbsp;&nbsp;Final</a></li>";
 	 		 }
     if (($games['gt']) =='DIV') {
 		echo "<li data-subcategory='Final Scores' data-category='Divisional Games' data-color='14ab05'><a href='#'>",$games['htn']," ",$games['hs'],"  ",$games['vtn'],"  ",$games['vs'],"  ",$games['d']," at ",$games['t'], "</a></li>";
 	 }
 	 if (($games['gt']) == 'CON') {
 echo "<li data-subcategory='Conference Games' data-category='Sunday' data-color='000000'><a href='#'>",$games['htn']," ",$games['hs'],"  ",$games['vtn'],"  ",$games['vs'],"  ",$games['d']," at ",$games['t'], "</a></li>";
 	  }
    }
  }

It works great, Thanks to some help!   The only thing I'd like to do now is have the output be a little more inline ...currently it reads the xml line by line and outputs the each item.. the order is the problem... It does this:   Wild Card game Wild Card game Div game Div game Conference game Conference game Div game Div game Wild Card game Wild Card game   I'd like it to output one type at a time....basically grouping all types together.. WC game Div game Conference game   I continue to learn but this one is stumping me...  I did get an idea from someone but not sure how to carry this one out...     Instead of outputting it directly you could just add it to an array in the first loop So for each game you do
$games[$type][] = $game;

Then you can add another loop (for output) where you will have them sorted   Just not sure how to handle that.. I'm feeling a bit lost at the moment...   Is this in reference to putting $games[$type] = $game in place of foreach($xml->gms->g as $games)?   I guess the second part has me lost as well adding another loop for output... needing to be sorted because each output is styled differently   I guess I'm just not understanding....  can anyone clarify for me please?   Thanks everyone!