PHP - Update Mysql Using Result From Drop Down Box <select>

I am simply trying to insert a value generated from an array in a while loop, but it seems the value is not global and I can't pass it as I like. I did some research on this, but could not find an answer that solved my issue...

Here is my select box code which is working perfect:

<select name="city">
<?php
$sql = "SELECT id, city_name FROM cities ".
"ORDER BY city_name";
$results_set = (mysqli_query($cxn, $sql)) or die("Was not able to produce the result set!");
while($row = mysqli_fetch_array($results_set)) {
echo "<option value=$row[id]>$row[city_name]</option>";
}
?>
</select>

Are any variables defined in a while loop global to the while loop only?

Here is my SQL which you can see my $row[id] being passed thru field city_id... The value is being generated as supposed to based on value like: value="1", value="2" etc.. for the select options for each city name. So the values are there... But I CANNOT get that numerical id to pass to the database when submitting my form.

Any ideas for a workaround to get this value passing as normal?

if (isset($_POST['addPosting'])) {
      $query = "INSERT INTO Postings (id, city_id, title, description) VALUES
('','$row[id]','$_POST[title]','$_POST[description]')";

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

I'm new to function and I can't figure how to update/result the score.

I developed a game called Rock, Paper, & Scissors, so I can learn the function itself with a simple game for now.

http://pastebin.com/9MB7ATnt

Any tips or instruction would be much appreciated.
Thanks.

Does anyone see anything wrong with the SQL?  This function keeps returning false.

Thank you for your time.

Code: [Select]
function insert_survey1($survey1_anwers) {
  // extract order_details out as variables
  extract($survey1_anwers);
 
  $username = $_SESSION['valid_user'];
  $conn = db_connect();

  // select user_id based on the entered data
  $query = "SELECT user_id FROM user WHERE
gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
username = '".$username."'";

  $result = $conn->query($query);

  //if the resulting user_id exists (AND has the POST data just entered, since the query must match those to return a row) ,
  if($result->num_rows>0) {
    //return the current row of the result set as an object and place it into user variable
    $user = $result->fetch_object();
//set variable for user_id to the fetched user object data representing the user_id int he db( because it was fetched from the sql select result)
    $user_id = $user->user_id;
//update the fields since the user exists already.
$query = "UPDATE user
SET gender = '".$gender."',
birth_range = '".$birth_range."',
degree_year = '".$degree_year."'
WHERE user_id = '".$user_id."'";

// $query = "UPDATE `alumni_survey`.`user`
// SET `gender` = '".$gender."',
// `birth_range` = '".$birth_range."',
// `degree_year` = '".$degree_year."'
// WHERE `user`.`user_id` = '".$user_id"'";
  } else {
//otherwise, if the user doesn't exist already insert this new data.
    $query = "INSERT INTO user (gender, birth_range, degree_year)
VALUES('".$gender."','".$birth_range."','".$degree_year."')
WHERE user_id = '".$user_id."'";
    $result = $conn->query($query);

    if (!$result) {
       return false;
    }
  }
 
  return $user_id;
}

Can anyone post a generic update function to update mysql table.
The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;

Okay so, I'm adding a reply feature to my text-board, and I'm wondering how I can select a single result from the DB
I've tried this
$board = mysql_real_escape_string($_GET['board']);
$thread = mysql_real_escape_string($_GET['thread']);

$result = mysql_query("SELECT subject, name, id, timestamp, body FROM $board LIMIT $thread,$thread");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<div id='html1' style='background-color:#F0E0D6;border:solid 1px #800000;font-family:arial; font-size: 12px; padding:2px; margin:2px;'><font color='#CC1105'>%s </font><font color='#117743'>%s</font> <font color='#800000'>Post # %s - %s<br />%s<br /></div>", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6]);
mysql_free_result($result);
}
?>
Kinda works but if I pu
?thread=56
then it would show thread 57, which in this example does not exist.

Hi there I am new to this forum and not much of a php expert. I hope you can assist me. My problem is as follows: I have a column consisting of several values (in this case: sceience, art, humanistics and music) I would like to use the following mysqli query in order to count the appearances of each value in this column:     $query = "SELECT SUM (IF(department = 'science', 1, 0)) AS science, SUM(IF(department = 'art', 1, 0))-> AS art FROM new2"   I have tried lots of ways to loop the results but couldn't get the it working. Can anyone suggest any idea?   Thanks   Hanan  

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

Hello.   I'm having some issues with a select statement containing ABS(). Here's the select query:

"SELECT gadenavn, husnr, ABS(husnr - $husnr) AS husnr_range, postnr,db, shaping, dsl_node, ctr_node, db_ctr_luftlinje, bynavn FROM `TABLE 1`, Post_numre WHERE `postnr`=`postnummer` AND `gadenavn`=`$vejnavn` AND `postnr`=`$postnr` AND `husnr`>0 ORDER BY husnr_range ASC LIMIT 5"

Now lets asume my variable "$husnr" is a value of 15. In my table I have the values for coulmn "husnr":   13,12,11,10,9   What really bugs me is the outcome doing af simple "while loop"  is returning the values 12,11,10,9.   What happened to 13?!   printing the "husnr_range" values shows "3,4,5,6".   What puzzles is the row missing, as I only get 4 results, with a "LIMIT 5".   Can anyone explain why the last resulst isn't included?

Hi there.

Im a noob to sql and php not sure if this is right place to post,

Im trying to get a dynamic drop down menu to show the 1st column in my sql database the column is called cat and holds category info ie audio, internet, music ect. ( i have no idea how to do lol )

it has taken me 2 days to find and edit this  the bold and underline'd bit is what im trying to change with the dropdown menu.

Or thinking bout it is there a way to do it with the URL. IE.. page name.php?cat=audio ?
would that be easer ? is there any security issues with doing it that way ?


Code==================================
$db_host = '*******';
$db_user = '******';
$db_pwd = '*****;

$database = 'nbbcj_co_uk';
$table = 'penapps';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table} WHERE `cat` = 'audio' LIMIT 10 ");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

//echo "<h1>Table: {$table}</h1>";
echo "<table border='1' width='100%'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    //echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
?>
code end ======================

the test page can been seen here http://www.nbbcj.co.uk/testd/1/test1.php

Any more questions let me know

Thanks for any help you can give, a we all have to start some ware lol

thanks kaine.

Guys, you are so going to be sick of me. But I really appreciate the help I am receiving here thus far.

I have the code below sending the data from the form to the database. That's excellent. However, where I am stuck is doing the following two:

1. Updating currently inserted data
2. Displaying the data on the site.

Here is settings.php:

<?php
include "../settings.php";
include "../lang/english.php";
include "../config/config.php";
$errors = array();
// condition and map inputs
$fields = array('site_name'=>'sitename','site_email'=>'email','your_name'=>'name','meta_description'=>'meta-description','meta_keywords'=>'meta-keywords');
foreach($fields as $var => $field){
   $$var = isset($_GET[$field]) ? trim($_GET[$field]) : '';
}
// check if the form was submitted
if(isset($_GET['submit'])){
   // connect to/select database
   mysql_connect("$db_hostname", "$db_username", "$db_password") or die(mysql_error());
   mysql_select_db("$db_database") or die(mysql_error());
   
   // basic validation (not empty) and escape data
   foreach($fields as $var => $field){
      if(empty($$var)){
         $errors[] = "The form field: $field, is empty!";
      }
      // escape the data
      $$var = mysql_real_escape_string($$var);
   }
   // if no validation errors, insert the data
   if(empty($errors)){
      $insert = sprintf("INSERT INTO settings (site_name, description, keywords, email, name) VALUES ('%s','%s','%s','%s','%s')",
      $site_name,
      $meta_description,
      $meta_keywords,
      $site_email,
      $your_name
      );
      if(!mysql_query($insert)){
         // a query error occurred
         // check if due to duplicate data
         if(mysql_errno() == 1062){
            // 1062 = duplicate primary key error (your error number might be different depending on your table definition)
            $errors[] = "The site name: $site_name, already exists and cannot be inserted!";
         } else {
            // all other query errors -
            $errors[] = "A database error occurred and your query cannot be processed!";
            trigger_error(mysql_error()); // use error_reporting/display_errors/log_errors to display/log the error condition
         }
      } else {
         echo "The data was successfully inserted!";
      }
   }
}
//database_connect();
$sql = "UPDATE settings
SET site_name='$site_name', description='$description', keywords='$keywords', email='$site_email', name='$your_name'
WHERE id='$id'"; 


$query = mysql_query($sql)or die("There's a problem with the query: ". mysql_error()); 
if($query) echo "<br>The settings have been updated.<br>";
$_SESSION['tekst']="";
?>
<!DOCTYPE html>
<html>
<head>
    <title><?php echo $site_name; ?> :: :: Powered by osPHPSite</title>
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
    <link  href="css/admin.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <div id="main">
        <div id="header">
            <h1><?php echo $sitename; ?></h1>
            <ul id="top-navigation">
                    <li><a href="index.php"><?php echo $lang_button_index; ?></a></li>
                    <li><a href="settings.php" class="active"><?php echo $lang_button_settings; ?></a></li>
                    <li><a href="pages.php"><?php echo $lang_button_pages; ?></a></li>
                    <li><a href="gallery.php"><?php echo $lang_button_gallery; ?></a></li>
                    <li><a href="/"><?php echo $lang_button_viewsite; ?></a></li>
                    <li><a href="logout.php"><?php echo $lang_button_logout; ?></a></li>
            </ul>
        </div>
        <div id="middle">
            <div id="left-column">
                <h3><?php echo $eng_navigation; ?></h3>
                <ul class="nav">
                    <li><a href="index.php"><?php echo $lang_button_index; ?></a></li>
                    <li><a href="settings.php"><?php echo $lang_button_settings; ?></a></li>
                    <li><a href="pages.php"><?php echo $lang_button_pages; ?></a></li>
                    <li><a href="gallery.php"><?php echo $lang_button_gallery; ?></a></li>
                    <li><a href="/"><?php echo $lang_button_viewsite; ?></a></li>
                    <li><a href="logout.php"><?php echo $lang_button_logout; ?></a></li>
                </ul>
                <a href="http://www.osphpsite.com" target="_blank" class="link">osPHPSite</a>
                <a href="http://www.osphpsite.com/forums/" target="_blank" class="link">Support Forums</a>
                <a href="http://www.vichost.com" target="_blank" class="link">VicHost.Com</a>
            </div>
            <div id="center-column">
                <div class="table">
            <?php
               if(!empty($errors)){
                  echo 'The following errors occurred:<br />';
                  foreach($errors as $error){
                     echo "$error<br />";
                  }
               }
            ?>
                    <form action="" id="settings" name="settings">
                    <table class="listing form" cellpadding="0" cellspacing="0">
                        <tr>
                            <th class="full" colspan="2">Site Configuration</th>
                        </tr>
                        <tr>
                            <th colspan="2">From the options below, define the default settings for your website.</th>
                        </tr>
                        <tr>
                            <th colspan="2"></th>
                        </tr>
                        <tr>
                           <td>Site name: </td> <td><input type="text" name="sitename" value="<?php echo $site_name; ?>" width="172" /> <em>Site name for logo</em></td>
                        </tr>
                        <tr>
                           <td>Email: </td> <td><input type="text" name="email" value="<?php echo $site_email; ?>" width="172" /> <em>Your email address</em></td>
                        </tr>
                        <tr>
                           <td>Name: </td> <td><input type="text" name="name" value="<?php echo $your_name; ?>" width="172" /> <em>Your own name</em></td>
                        </tr>
                        <tr>
                           <td>Meta Description: </td> <td><input type="text" name="meta-description" value="<?php echo $meta_description; ?>" width="172" /> <em>SEO</em></td>
                        </tr>
                        <tr>
                           <td>Meta Keywords: </td> <td><input type="text" name="meta-keywords" value="<?php echo $meta_keywords; ?>" width="172" /> <em>Separate with Commas</em></td>
                        </tr>
                       <tr>
                       <td><input type="submit" class="button" name="submit" value="Submit"></td>
                       </tr>
                    </table>
      </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

This will be a huge hurdle if I can get passed this one, I am well and truly on my way.
Any help, advice etc that you can give, and what needs to go where, I would really appreciate it and I promise not to annoy you guys unless absolutely necessary.

This has been bugging me for quite a while and I've tried so many different things and just run into all kinds of problems...

What I'm doing or trying at least is pulling data from a table displaying it into a multiple select box allowing the user the oppertunity to remove one or more options.  As the code stands now I'm getting no value at all in the post variable, by taking the [] brackets out of the inputs name i was able to get the first selected option but the php code was then unable to remove that value from the database.  I hope I'm explaining this well enough but the code follows I'd really appreciate some help or direction on this one.

The FORM
Code: [Select]
                <FORM action='' method='post'>
                    <select size='8' multiple name='remove_player[]'>
<?php
foreach ($members as $key => $mem) {
    if ($mem != "") {
        $mem = str_replace("-", " ", $mem);
        $mem = ucwords($mem);
        echo ("<option value='" . $mem . "'>" . $mem . "</option>");
    }
}
?>
                    </select>


and then the handler code:
Code: [Select]
        $to_remove = $_POST['remove_player'];
$as_team = str_replace(" ", "-", $teamname);
$as_team = strtolower($as_team);
$for_remove = "SELECT * FROM teams WHERE name = '$as_team'";
$for_query = (mysql_query($for_remove));
foreach ($to_remove as $y => $z) {
$z = str_replace(" ", "-", $z);
$z = strtolower($z);
}
while($arr_remove = mysql_fetch_array($for_query)) {
foreach ($arr_remove as $a => $b) {
foreach ($to_remove as $c => $d) {
if ($b == $d) {
unset($arr_remove[$a]);
}
}
}
foreach ($arr_remove as $e => $f) {
$add_replace = (mysql_result($for_query, 0, 'members'));
$replace = ($add_replace . "\r\n" . $f . "\r\n");
$replace_mem = "UPDATE teams SET members = '$replace'";
$replace_q = (mysql_query($replace_mem));
}
}
echo "Member List successfully updated.<br>";
foreach ($to_remove as $h => $g) {
echo ($g . " removed from the team.<br>");
}
Also any time i try to print any part of the array/s I get no values but the database is being updated with 2 line breaks and a "3" at the end of the table which has me a bit confused as well.

Thanks!

I want to update a value by setting cookie. I use this code:

Code: [Select]
<?php
    if (isset($_POST['ChangeOrdering'])) {
        setcookie("Ordering", $_POST['ChangeOrdering'], time() + 31536000);
    }
echo $_COOKIE["Ordering"];
?>

<form method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>"> Reorder messages:
<select name="ChangeOrdering">
<option value="DateAdded ASC">Oldest first</option>
<option value="DateAdded DESC">Newest first</option>
<option value="Title ASC">By Title, A-Z</option>
<option value="Title DESC">By Title, Z-A</option>
</select>
<input type="submit" value=" Save Settings " />
</form>
Problem is that echo will return the previous cookie set, not the last value. As a matter of fact, my problem is about updating the cookie. It seems that the browser load the cookie before it is updated by the POST value.

Hi guys,

Im developing a stock system and so far new stock and can be added with the quantity, however im trying to update the stock by using a select box and selecting the type of stock and inputting a  new qty.

the form and everything is set up and i can select files from the database, however i dont know how to update files from a select box

The code i got so far is

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>stock manager</title>
</head>

<body>
<?php
$stockqty =&$_POST['stock_qty1'];
?>
<center>
<table>
<td>
    <table>
<td>
        <form action='stockview.php' method='POST'>
        Please Enter a Stock Name and Stock Value
       
        <table>
            <tr>
            <td>
                Stock Name:
            </td>
            <td>
              <input name="stock_name" type="text" /><BR />
            </td>
        </tr>
        <tr>
            <td>
                Stock Qty:
            </td>
            <td>
                <input name="stock_qty" type="text" />
            </td>
        </tr>
       
        </table>
         <input name="submit" type="submit" value="Add New Stock Items" />
        </form>
  </td>
</table>
</td>

<td>
   
<table>
<td>
<form action='stockmanager.php' method='POST' enctype="multipart/form-data">
        Please Select from the list the item you wish to update
          <table>
            <tr>
            <td>
                Stock Name:
            </td>
            <td>
               
                <?php
$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query=("SELECT id, stockname FROM stocks");
$result = mysql_query ($query);
echo "<select name=stock value=''>Edit Stock QTY</option>";

while($nt=mysql_fetch_array($result))
{ //Array or records stored in $nt
echo "<option value=$nt[id]>$nt[stockname]</option>";
/* Option values are added by looping through the array */
}


$queryreg = mysql_query("SELECT * FROM stocks WHERE stockqty='$stockqty'");
$numrows = mysql_num_rows($queryreg);

$update = mysql_query("UPDATE stocks SET stockqty='$stockqty' WHERE stockname  = '$stockname'");
echo("Its updated");
?>
               
               
            </td>
        </tr>
        <tr>
            <td>
                Stock Qty:
            </td>
            <td>
                <input name="stock_qty1" type="text" />
            </td>
        </tr>
        </table>
         <input name="submit" type="submit" value="Update stock items" />
        </form>
    </td>
</table>
</td>
</table>

</center>


</body>
</html>

Any help would be greatly appreciated.

Thanks

Lance