PHP - "fast" Select From Multidimensional Array?

I am currently creating a form and I want to populate a drop down selection menu with data from two fields in a form. For example, I want it to pull the first and last name fields from a database to populate names in a drop down menu in a form. I want the form to submit to the email address of the person selected in the drop down. Is this possible to do? The email is already a field in the record of the person in the database.

Can anyone give me some pointers or advice on how I should go about setting up the "Select" box drop down? I am not sure how to code it to do what I am wanting. Any links to relevant help would be appreciated too.

Thanks in advance!

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/aci/docs/admin/hours.php on line 20

Code: [Select]
<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}

?>
Code: [Select]
CREATE TABLE `hours` (
  `hoursID` int(5) NOT NULL auto_increment,
  `member` varchar(20) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`hoursID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `hours`
--

INSERT INTO `hours` VALUES (4, 'aci', '2010-11-30', '14:31:39');
INSERT INTO `hours` VALUES (2, 'aci', '2010-11-30', '14:31:08');
INSERT INTO `hours` VALUES (3, 'aci', '2010-11-30', '14:31:23');
INSERT INTO `hours` VALUES (5, 'aci', '2010-11-30', '14:31:40');
       

I am trying to print the list of a table which I requested with "SELECT DISTINCT" as below

Code: [Select]
$db_connect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

$sql_get = "SELECT DISTINCT category FROM con";

$sql_run = mysqli_query($db_connect, $sql_get) or mysqli_error($db_connect);

$sql_assoc = mysqli_fetch_assoc($sql_run);

What is now needed to print the list of the table data by this conditions?

I tried the while loop, but I seem to approach wrong, and get endless loops or errors.

Hi,
I need to call to this text to add a all with value "blank/empty" or "0" to the dropdownlist code below..
it should be inserted int the first position in the dropdownlist and have a value blank and call to this text from the language files:            
            $searchAll = gettext('_LANGUAGE_SEARCH_ALL',_LANGUAGE_SEARCH_ALL,false,false);
            example is:
            ratestitle=>0 gettext('_LANGUAGE_SEARCH_ALL',_LANGUAGE_SEARCH_ALL,false,false);
            the words it calls is "ALL" when the user selects or leaves the "ALL" in the list the value
             remains empty this allows the search to search everything..
basically im stuck how to get it in the dropdown list as the first default position:
can anyone help?

here is my code://this is a search function which calls to the field rate_title the text from the select box is matched to the database table and the search pages shows the search option is the search is successful.. I have 5 of these types of searches but cant give a broader search option to my users as the values must be selected to search--- i need the option "ALL" to have a "EMPTY" value or no value....
         

if (in_array("ratestitle",$searchOptions)&& $showSearchOptions )
            {
            if (empty($sch->filter['ratestitle']) )
               $selectOption=$output['LANGUAGE_SEARCH_RATESTITLE'];
            else
               $selectOption=$sch->filter['ratestitle'];
            $showButton=true;            
         $query = "SELECT DISTINCT rate_title FROM #__rates_table ORDER BY rate_title ASC";
         $dropDownList ="<select class=\"inputbox\" name=\"ratestitle\">";
         $ratesitles =doSelectSql($query);         
         foreach ($ratesitles as $ratetitle)
            {
            $selected="";
            $rate_title=$ratetitle->rate_title;
            if ($ratetitle==".$sch->filter['ratestitle'].")
               $selected="selected";
            $dropDownList .= "<option ".$selected." value=\"".$rate_title."\">".$rate_title."</option>";
            }
         $dropDownList.="</select>";
         $output['RATESTITLE']=$dropDownList;
            }
               

I am getting the following error when using composer: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Just started.  I am pretty sure composer.json wasn't changed.  journalctl doesn't show anything.  Maybe Doctrine related, however, nothing seems to help.

Any ideas?
 

[michael@devserver www]$ php -v
PHP 7.3.4 (cli) (built: Apr  2 2019 13:48:50) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies
    with DBG v9.1.9, (C) 2000,2018, by Dmitri Dmitrienko
[michael@devserver www]$ composer -V
Composer version 1.4.2 2017-05-17 08:17:52
[michael@devserver www]$ yum info composer
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.us.oneandone.net
 * epel: mirror.rnet.missouri.edu
 * extras: mirror.us.oneandone.net
 * remi-php73: mirror.bebout.net
 * remi-safe: mirror.bebout.net
 * updates: mirror.us.oneandone.net
Installed Packages
Name        : composer
Arch        : noarch
Version     : 1.8.4
Release     : 1.el7
Size        : 1.8 M
Repo        : installed
From repo   : epel
Summary     : Dependency Manager for PHP
URL         : https://getcomposer.org/
License     : MIT
Description : Composer helps you declare, manage and install dependencies of PHP projects,
            : ensuring you have the right stack everywhere.
            :
            : Documentation: https://getcomposer.org/doc/

[michael@devserver www]$ composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)


  [ErrorException]
  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?


update [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--lock] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [--with-dependencies] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--prefer-stable] [--prefer-lowest] [-i|--interactive] [--root-reqs] [--] [<packages>]...

[michael@devserver www]$

 

I am attempting to use use two tables from the same database as described below. My db connection is made and is good.

As part of a larger application I am creating a comments feature. Each row is a separate comment that was left by a user.  I've no problem getting each row from the database and printing each out as I want formatted.

The second table I am using contains all of the personal info of each member including their username, their displayed name, location and among other things the URL to an image they want associated with their account.

Each row in the comments table contains the following id # of the comment, username of the person that left it, the date and of course the body of the message itself.

Now I am trying to get the comment to show the image found at the URL in the second table (personal info).

So for each row in the comments table I want it to pull the commentor's img_url from the second table.


$result = mysql_query("SELECT * FROM page_comments WHERE page_id = '$id'");

if(mysql_num_rows($result)==0) {
echo "There are currently no comments.";
}else{
   while($row = mysql_fetch_array($result)) {

   echo "<table>";
echo "<tr>";
echo "<td>";
echo "<img sro=\"$img_url\" width=50 height=50>";
echo "</td>";
echo "<td>";
echo "<a href=profile.php?member=";
echo $row['commentor'];
echo ">";
echo $row['commentor'];
echo "</a>";
echo "</td>";
echo "<td>";
echo $row['date'];
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td cospan=3>";
echo $row['comment'];
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br />";


 }
}


As you can see I've thrown the "$img_url" in there as a placeholder for the time being.

I've tried a couple of ideas and while none of them threw any errors it, of course, didn't return a value so the img was broken and the HTML source was just empty.

Any and all ideas are greatly appreciated.

I want to post some form identifyer when I hit submit, so that I can use this in an SQL query.

Previously I used the below code and would retrieve either page1.php or page2.php etc from $_POST['subject']);

Code: [Select]
<td>
<select name="subject" id="subject" onchange="gotourl(this.value)">
<option value="" >Please Select</option>
<option value="page1.php" >page1</option>
<option value="page2.php">page2</option>
<option value="page3.php">page3</option>
</select>
</td>

will this work?

Code: [Select]
<form id="form1" name="form1" value="tableName" method="post" action="">

$_POST['form1']) returns tableName......

Thanks

This topic has been moved to Linux.

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

Ok, I am not sure if I can explain it correctly, but here it goes. I have a form where user is asked to enter up to three name. Let's say that the fields are called [name1], [name2] and [name3] and they are called the came in the table. Now I have a code which allows me to compare what names are in the database versus the name that was entered by the user.


$query  = "SELECT * FROM Project_Registrations WHERE name1= '$_POST[name1]' ";
$result2 = mysql_query($query);
if (mysql_numrows($result2) > 0) {
while($row = mysql_fetch_array($result2))
{echo" ...error code... ";} }
else { ...ok code... };


This works well for one name field but I have three in the form and three in the table. How do I define it so all three name fields in the form are compared to all three in the table and if just on matches I can give them the ...error code...?

Oh, and they can enter up to three names in the form, but it could be two or one.

Can I code it such:

$query  = "SELECT * FROM Project_Registrations WHERE name1= '$_POST[name1]'  OR name1= '$_POST[name2] OR name1= '$_POST[name2]' OR ...'";

Thanks

Why is this not working? I can not seem to incorporate and into the statement

$query  = "SELECT * FROM Project_Registrations WHERE 
(First_Name = '$_POST[name_1]' AND Teacher = '$_POST[teacher]' AND School = '$_POST[school]') OR
(Second_Name = '$_POST[name_1]' AND Teacher = '$_POST[teacher]' AND School = '$_POST[school]') OR
(First_Name = '$_POST[name_2]' AND Teacher = '$_POST[teacher]' AND School = '$_POST[school]') OR
(Second_Name = '$_POST[name_2]' AND Teacher = '$_POST[teacher]' AND School = '$_POST[school]')
";


Thanks

Hi, I currently have an if, elseif, else program that starts off with

Code: [Select]
if( $v_name == "" || $v_msg == "" )
echo "something"
how do I turn this into a switch?

but the very next elseif I have

Code: [Select]
elseif( strcspn( $_REQUEST['msg'], '0123456789' ) == strlen( $_REQUEST['msg'] ) )
echo "something"

is it possible to turn this into a switch with 2 different strings like that to evaluate?

I have a registration form on my website and after Registration I want the user to activate first his account. I don't have problem on sending this email to the user. What I want to appear is like this..

GoodDay "username",

Blah Blah!

how can you actually do that? I know that you can do that through session variables but the thing is email's can't accept scripts on sending emails. how can I get the value from a session variable for example and convert it to plain html text so that i can OUTPUT it to the email.. HELP PLEASE!

This topic has been moved to PHP Installation & Configuration.

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

Hello I have an issue with a form that has been built by someone else on Wordpress. 

using contact form 7 plugin there's a for to fill out and it emails a PDF copy to the customer.

however on the pdf any information from dropdown selections shows "Array" instead of what was selected, everything looks fine to me (with my very minimal knowledge of PHP) the title & Preferred Payment Method:  doesn't show on the pdf 

here is the contact form 7 code.


 

<div class="steps">
    <div class="step gap-large step-1">
        <h2 class="step-title"><span class="gold">Step 1.</span> Calculate the value of your <span class="gold">gold</span></h2>
        [gold_calculator your-items]    
    </div>
    <div class="step gap-large step-2">
        <h2 class="step-title"><span class="gold">Step 2.</span> Submit your details</h2>
        <div class="row">
            <div class="column col-xs-12 col-sm-2 col-lg-4">
                <label class="required" for="sell-title">Title</label>
                [select* your-title id:sell-title class:form-control "Mr" "Mrs" "Miss" "Ms"]
            </div>
            <div class="column col-first-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-first-name">First Name</label>
                [text* your-first-name id:sell-first-name class:form-control placeholder "Enter your first name"]
            </div>
            <div class="column col-last-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-last-name">Last Name</label>
                [text* your-last-name id:sell-last-name class:form-control placeholder "Enter your last name"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-email">Email Address</label>
                [email* your-email id:sell-email class:form-control placeholder "Enter your email address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-daytime-phone">Daytime Telephone</label>
                [tel* your-daytime-phone id:sell-daytime-phone class:form-control placeholder "Enter your telephone number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="" for="sell-mobile-phone">Mobile Telephone</label>
                [tel your-mobile-phone id:sell-mobile-phone class:form-control placeholder "Enter your mobile number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="required" for="sell-address-1">Address Line 1</label>
                [text* your-address-1 id:sell-address-1 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="" for="sell-address-2">Address Line 2</label>
                [text your-address-2 id:sell-address-2 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-city">Town/City</label>
                [text* your-city id:sell-city class:form-control placeholder "Enter your town/city"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-county">County</label>
                [text* your-county id:sell-county class:form-control placeholder "Enter your county"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-postcode">Postcode</label>
                [text* your-postcode id:sell-postcode class:form-control placeholder "Enter your postcode"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-6">
                <label class="required" for="sell-method">Choose your method of payment</label>
                [select* your-method id:sell-method class:form-control "Instant Bank Transfer" "Cash" "Cheque"]
            </div>
            <div class="column col-xs-12 ccol-sm-12 col-lg-6">
                <div class="input-label required">Terms &amp; Conditions</div>
                [acceptance your-price-acceptance id:sell-price-acceptance]I accept the price offered above for my gold.[/acceptance]
                [acceptance your-terms-acceptance id:sell-terms-acceptance]I accept the <a href="/terms-conditions/" target="_blank">terms &amp; conditions</a>.[/acceptance]
                [acceptance your-acknowledgement id:sell-acknowledgement]I declare and acknowledge that: 1. I confirm the property enclosed is mine to sell, 2. I believe the items(s) to be genuine gold or platinum 3. You will contact me if the value calculated upon receipt differs in weight or carat 4. I accept payment will only be made to the person named on the submission form.[/acceptance]
            </div>
            <div class="column col-submit col-xs-12 col-sm-12">
                <div class="alert alert-info">After clicking the ‘Submit’ button below, we'll email you a form to print off and include with the package you send to us. If you wish to be paid by bank transfer, please write your bank details on the form once printed.</div>
                <div class="submit">[submit class:btn class:btn-gold "Submit"]</div>
            </div>
        </div>
    </div>
</div>

here is the pdf php form code. 

 

<?php /** @var \Strive\Sections\Pdf_Form $this */ ?>
<head>
    <style>
        h1, h2 {
            margin-top: 0;
        }

        th, td {
            text-align: left;
            vertical-align: top;
        }

        .section {
            padding: 20px 0;
        }

        .border-top {
            border-top: solid 1px #E7E7E7;
        }

        .cut-top {
            border-top: dashed 1px #E7E7E7;
        }

        .text-placeholder {
            background-color: #F7F7F7;
        }

        .cut-note {
            text-align: center;
            font-size: 80%;
            margin-bottom: 5px;
        }
    </style>
</head>
<body>
<h1>Step 3. Print &amp; post this form with your gold</h1>
<div class="section quote border-top">
    <h2 class="section-title">Customer Quote:</h2>
    <div>
        <?php if ( $this->calculator['empty'] 😞 ?>
            <p>You didn't weigh your gold - don't worry, we'll do it for you and call you with an offer. </p>
        <?php else: ?>
            <ol>
                <?php foreach ( $this->calculator['items'] as $item 😞 ?>
                    <li><?php echo $item['weight']; ?>g of <?php echo $item['name']; ?> -
                        &pound;<?php echo $item['price']; ?></li>
                <?php endforeach; ?>
            </ol>
            <p>Total: &pound;<?php echo $this->calculator['total']; ?></p>
        <?php endif; ?>
    </div>
</div>
<div class="section details border-top">
    <h2 class="section-title">Customer Details:</h2>
    <table width="100%">
        <tr>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Reference:</th>
                        <td><?php echo $this->reference; ?></td>
                    </tr>
                    <tr>
                        <th>Name:</th>
                        <td></td><?php echo empty( $this->title ) ? '' : $this->title; ?>
                            <?php echo empty( $this->first_name ) ? '' : $this->first_name; ?>
                            <?php echo empty( $this->last_name ) ? '' : $this->last_name; ?></td>
                    </tr>
                    <tr>
                        <th>Email:</th>
                        <td><?php echo empty( $this->email ) ? '-' : $this->email; ?></td>
                    </tr>
                    <tr>
                        <th>Telephone:</th>
                        <td><?php echo empty( $this->daytime_phone ) ? '-' : $this->daytime_phone; ?></td>
                    </tr>
                    <tr>
                        <th>Mobile:</th>
                        <td><?php echo empty( $this->mobile_phone ) ? '-' : $this->mobile_phone; ?></td>
                    </tr>
                </table>
            </td>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Address 1:</th>
                        <td><?php echo empty( $this->address_1 ) ? '' : $this->address_1; ?></td>
                    </tr>
                    <tr>
                        <th>Address 2:</th>
                        <td><?php echo empty( $this->address_2 ) ? '' : $this->address_2; ?></td>
                    </tr>
                    <tr>
                        <th>Town/City:</th>
                        <td><?php echo empty( $this->city ) ? '' : $this->city; ?></td>
                    </tr>
                    <tr>
                        <th>County:</th>
                        <td><?php echo empty( $this->county ) ? '' : $this->county; ?></td>
                    </tr>
                    <tr>
                        <th>Postcode:</th>
                        <td><?php echo empty( $this->postcode ) ? '' : $this->postcode; ?></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
<div class="section payment border-top">
    <p>Preferred Payment Method: <?php echo empty( $this->method ) ? '' : $this->method; ?></p>
    <?php if ( $this->method === 'Instant Bank Transfer' 😞 ?>
        <p>Write down your bank details below for the account in which you wish funds to be deposited.</p>
        <table width="100%">
            <tr>
                <th width="25%">Bank:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Name on Account:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Sort Code:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Account No:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
        </table>
    <?php endif; ?>
</div>
<div class="cut-note">Print this form, include the above part in your package and post to the address below.</div>
<div class="section address cut-top">
    <p>
        SMG<br><br>
        <?php echo empty( $this->send_address ) ? '' : $this->send_address ?>
    </p>
</div>
</body>

 

 

 

any help would be appreciated. 

Edited July 28 by Barand
code tags added

Hi all,

just to get this out of the way i have now been working on html / css / php / mysql coding for about 3 weeks.

So i dont know too much, on to the problem...

I am creating a database for asset managment in and out of our shop I have setup the db and it works with no issues.
So I am currently trying to add fluff as i put it.

The guys in the shop want the web page to have a table of information on what is in the shop and when they click on the asset number in the table they want it to open a new page where you can edit the database information of that item.

I have no clue how to emplement this after reading diffrent ideas for about 4 hours today I am just stuck and confused.
any ideas or tips would be helpfull


This first block of code is my status page.
Code: [Select]

<style>

tr
{font-size:24px;}
button
{width:120px}

</style>

<body topmargin="50px">

<?php
 session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);

$currenttime = getdate();

$result = mysql_query("SELECT * FROM shop_inventory WHERE In_Shop='1'");
$test = mysql_fetch_array($result);

echo "<table border='1' align='center' style='text-align:center' cellpadding='10' width='100%'>
 <tr>
 <th>Asset number</th>
 <th>Building</th>
 <th>Room number</th>
 <th>In date</th>
 </tr>";

$_SESSION['array_row'] = $test;
 
while($row = mysql_fetch_array($result))
   {
   $style = '';
   //if ($currenttime - $row['Entered_Shop_Time'] == 0 || 1)
    $style = 'style="background-color:#00FF00"';
   
echo "<tr>";
echo "<td> <button onClick=../subpages/edititems.php>" . $row['Asset'] . "</button> </td>";
echo "<td>" . $row['Building'] . "</td>";
echo "<td>" . $row['Room_Number'] . "</td>";
echo "<td $style>" . date("F j, Y", strtotime($row['Entered_Shop_Time']))  . "</td>";
echo "</tr>";
   
   }
echo "</table>";
 
mysql_close($connect);
 
?>

</body>



This second block of code is the page where i want to dump the table info into for editing.

Code: [Select]

<?php
session_start(); 

include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
//$Asset = $_POST['Asset'];
$Session = $_SESSION['array_row'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$session");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$Session = mysql_fetch_array($data);

?>


<!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>Add Items</title>
</head>

    <body>
    <div style=" padding-top:5px;">
                <h1><center>Add New Items</center></h1>
        </div>
      <form name="myForm" action="afteredititems.php" method="post">
            Asset Number: <input type="text" name="Asset" value="<?php echo $Session['Asset']?>"/><br /><br />
            Manufactu <input type="text" name="Manufacture" value="<?php echo $Session['Manufacture']?>"/><br /><br />
            Model: <input type="text" name="Model" value="<?php echo $Session['Model']?>"/><br /><br />
            Serial Number: <input type="text" name="Serial_Number" value="<?php echo $Session['Serial_Number']?>"/><br /><br />
            Building: <input type="text" name="Building" value="<?php echo $Session['Building']?>"/><br /><br />
            Room Number: <input type="text" name="Room_Number" value="<?php echo $Session['Room_Number']?>"/><br /><br />
            <input type="hidden" name="In_Shop" value="1"/>
            Type of Equipment: <select name="Type" value="<?php echo $Session['Type']?>">
                                <option value="desktop">Desktop</option>
                                <option value="laptop">Laptop</option>
                                <option value="ipad">Ipad</option>
                                <option value="ipod">Ipod</option>
                                <option value="projector">Projector</option>
                                <option value="printer">Printer</option>
                               </select><br /> <br />
            <center><input type="submit" value="Add Item"/></center>
        </form>
    </body>
</html>



And lastly I have a page that redisplays the edited information.

Code: [Select]

<?php

//$Asset = $_POST['Asset'];

//$data = mysql_query("SELECT * FROM shop_inventory WHERE Asset=$Asset");
//$query = mysql_query($data) or die ("Cannot select database." . mysql_error());
//$data2 = mysql_fetch_array($data);


include("../../Connections/db_connection.php");
$table = "shop_inventory";
mysql_select_db("$db_database", $connect);
unset ($db_username, $db_password);
$Asset = $_POST['Asset'];
$Manufacture = $_POST['Manufacture'];
$Model = $_POST['Model'];
$Sn = $_POST['Serial_Number'];  //<---- possibly fubar check sn everywhere
$Building = $_POST['Building'];
$Room_Number = $_POST['Room_Number'];
$Type = $_POST['Type'];

$data = mysql_query("UPDATE `shop_inventory` SET  Manufacture='$Manufacture', Model='$Model', Serial_Number='$Sn', Building='$Building', Room_Number='$Room_Number', Type='$Type' WHERE Asset=$Asset");
//$query = mysql_query($data) or die("could not execute query.". mysql_error());

?>

<!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>Untitled Document</title>
</head>

<body>

<!-- display changes -->
Asset: <?php echo $Asset ?><br />
Manufactu <?php echo $Manufacture ?><br />
Model: <?php echo $Model ?><br />
Serial number: <?php echo $Sn ?><br />
Building: <?php echo $Building ?><br />
Room Number: <?php echo $Room_Number ?><br />
Type: <?php echo $Type ?><br /><br />

</body>
</html>



I know there is a lot of poorly formated code and more then likely it is hard to read as I was going to do cleanup after I had all my features working.

After doing all the digging i found out about sessions and how they are used to pass data, I thought it would be a good method but I just could not figure out how to send information from the table if the table is reciving its info from an array.

any help would be appreciated thanks.