Customer Service Chat
Get quote & make Payment
Php / mysql issues, computer programming, Programming Languages
Im having problems with my php / mysql code.
I am trying to make it so it looks for an asset Number and if it is in the shop
if the asset is in the database but is not in the shop I want it to change it to be in the shop.
If the asset is not in the database I want it to create a new row with the information provided by my table.
here is all the php code
$table = "shop_inventory";
unset ($db_username, $db_password);
//$Log_Time = $_POST[''Log_Time''];
//$Log_Date = $_POST[''Log_Date''];
$Asset = $_POST[''Asset''];
$Manufacture = $_POST[''Manufacture''];
$Model = $_POST[''Model''];
$sn = $_POST[''sn''];
$Type = $_POST[''Type''];
$Building = $_POST[''Building''];
$RoomNumber = $_POST[''Room_Number''];
$In_Shop = $_POST[''In_Shop''];
$all = mysql_query(''SELECT * FROM $table'');
//$row = mysql_fetch_array($all);
if ("SELECT * FROM $table WHERE Asset=$_POST[Asset] and In_Shop=0")
mysql_query("UPDATE $table SET In_Shop=1 WHERE Asset=$_POST[Asset]");
echo "If ran";
"INSERT INTO $table (Asset, Manufacture, Model, Serial_Number, Type, Building, In_Shop, Room_Number)
($_POST[Asset], $_POST[Manufacture], $_POST[Model], $_POST[sn], $_POST[Type], $_POST[Building], $_POST[In_Shop], $_POST[Room_Number]";
echo "else ran";
echo "$Asset Added to Inventory";
header(''Refresh: 5; URL=../subpages/shopmain.php'');
Posted Date: 3/16/2012 10:47:33 PM | Location : United States
Ask an Expert
Php / mysql issues, computer programming, Assignment Help, Ask Question on Php / mysql issues, computer programming, Get Answer, Expert's Help, Php / mysql issues, computer programming Discussions
Write discussion on Php / mysql issues, computer programming
Your posts are moderated
Write your message here..
What are attributes in html langauge, What are Attributes in HTML langauge?...
What are Attributes in HTML langauge? A few tags have attributes. An attribute is a name, followed through an = sign, followed by the value. For instance, to make a centered H1
Write an implementation for the prime machine, You should use the BToolkit ...
You should use the BToolkit to produce the answers to the questions below. Where applicable, please use the machine names and identifier names suggested in the question to help me
Write a program to compute the standard deviation, Write three functions, s...
Write three functions, statistics, average, and sD as follows. The statistics function returns no value and has six parameters: four scores followed by their average and standard d
Assembly language program, a program that enter an alphabet from the user a...
a program that enter an alphabet from the user and compare it is vowel or not?
Php programming help, How to read file in PHP.
How to read file in PHP.
Information system analysis, Context diagram and Data Dictionary
Context diagram and Data Dictionary
Assembly language, how to concatinate two strings in assembly
how to concatinate two strings in assembly
Matrices and vectors, This section is proposed to be a catch all for severa...
This section is proposed to be a catch all for several of the fundamental concepts which are used occasionally in working with systems of differential equations. There will not be
Genetic diseases, Genetic Diseases Problem Description Many human di...
Genetic Diseases Problem Description Many human diseases could be controlled by the knowledge of the gene's structure and pattern. The human gene could be represented by fou
Write a program to read a text file and create a dictionary, Write a progra...
Write a program to read a text file and create a dictionary. The keys for the dictionary should be all 26 letters of the alphabet and the values of the dictionary should be the lis
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.