The following code takes the values from the db and echos them inside a list. Then when the user selects a value from the list, the value must be stored to the db, but this doesn't work. Could anyone help?
Thank you in advance for your effort.
<?php
$query = "SELECT categorydescrip tion, categoryname FROM categories ORDER BY categoryname ASC";
$result = mysql_query($qu ery,$conn) or die('Query...
TKB
Last Activity: Jul 4 '07, 08:55 AM
Joined: Nov 25 '06
Location:
-
Problem With Php Insertion From List! Urgent
-
If Else Statement Wrong
Could anyone tell me what's wrong with this code?
Thank you in advance for your effort.
<?php
If ($CategoryName == 'U-100') {
($UnitPrice = 500);
} else if ($CategoryName == 'U-130') {
($UnitPrice = 400);
} else if ($CategoryName == 'U-105') {
($UnitPrice = 350);
} else if ($CategoryName == 'U-95') {
($UnitPrice = 200);
}else if($CategoryNam e == 'U-85')... -
Insert Into Multiple Tables
I have the following tables/fields, how can I make the insertion into 1? Now as I have the code into different querries there is nothing added in mysql.
Thank you in advance for your help.
mysql_query ("INSERT INTO categories (CategoryName)
VALUES
('$_POST[CategoryName]')");
?>
<?php
mysql_query ("INSERT INTO insurancecharge s (InsuranceType)... -
Insert And Then Update
I have the following code but it doesn't work. Does anybody know?
Thank you in advance for your effort.
<?php
$query = "INSERT INTO transportationc harges (Transportation Unit)
VALUES ('$Transportati onUnit')";
$updateSQL = $conn->GetUpdateSQL($ query, $Transportation Unit);
$conn->Execute($updat eSQL);
?> -
What I want is after a user hits the submit button to display a list of what he/she has ordered.I'm dealing only with php code hence the b paragraph is of my concern.
Awaiting your response with many thanks.
TKB... -
I'm sorry for the mistake.
I have re-written a code with which I want each time a member logs in and places an order when they click on the view my order button to have results according to their username and password. Could you please help me out?
[php]
<?php
$_SESSION['logged_in'] = TRUE;
$query = "SELECT * FROM categories";
$result = mysql_query($qu ery) or die('Query failed: ' . mysql_error());...Leave a comment:
-
php code to retrieve latest data from mysql
I have the following code and I want to retrieve the latest data from mysql and have it inside a table I have created. Could anyone tell me what's wrong with it?
Thank you in advance for your effort.
<td>Category Name :
</td>
<td><?php
$query= "SELECT * FROM categories;
$result = mysql_query($qu ery);
$num=mysql_numr ows($result);
mysql_close();... -
Need Help
I have the following code in order to retrieve the latest data inserted from mysql table. Does anybody know where is the problem?
When a client submits the placeorder.php page, does anybody know how I can retrieve this date from mysql and present it in the viewmyorder.php page ?
Thank you in advance for your effort.
<?PHP
include 'connectDB.php' ;
$result = mysql(asbestos, "select...
No activity results to display
Leave a comment: