Sql and php order list script problems
Posted on
16th Feb 2014 07:03 pm by
admin
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying to do) for a custom shopping cart im making... For some reason it comes up with all the orders in stead of 1. i.e. If there i start from scratch ill have order number 1 which will have the order in but if i create another order it displays order number 2 twice with both the customers details on...
Heres the code:
Code: <?php
include ('../includes/db.php');
include('search.php');
?>
<!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>Orders</title>
</head>
<body>
<a href="orders.php">Refresh</a> || <a href="admin.php">Back to Admin</a> <br/><br/>
<form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
<input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" />
<input type="submit" name="submit" value="Search!" /> ||
First Name: <input type="checkbox" name="firstname" value="on" <?php echo isset($_GET['firstname'])?"checked":''; ?> /> ||
Last Name: <input type="checkbox" name="lastname" value="on" <?php echo isset($_GET['lastname'])?"checked":''; ?> /> ||
House Name: <input type="checkbox" name="address1" value="on" <?php echo isset($_GET['address1'])?"checked":''; ?> /> ||
Post Code: <input type="checkbox" name="zip" value="on" <?php echo isset($_GET['zip'])?"checked":''; ?> />
</form>
<br />
<?php echo (count($error) > 0)?"The following had errors:<br /><span id="error">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
<?php echo (count($results) > 0)?"Your search for '{$searchTerms}' returned:<br /><br />" . implode("", $results):""; ?>
<?php
$result = mysql_query("SELECT * FROM customers INNER JOIN order_detail ORDER BY orderid DESC");
echo "<table border='1'>
<tr>
<th>Order Number</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Address 1</th>
<th>Address 2</th>
<th>City</th>
<th>State</th>
<th>Post Code</th>
<th>Phone</th>
<th>Payment</th>
<th>Price</th>
<th>Total</th>
<th>Payed</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['orderid'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['address1'] . "</td>";
echo "<td>" . $row['address2'] . "</td>";
echo "<td>" . $row['city'] . "</td>";
echo "<td>" . $row['state'] . "</td>";
echo "<td>" . $row['zip'] . "</td>";
echo "<td>" . $row['phone'] . "</td>";
echo "<td>" . $row['payment'] . "</td>";
echo "<td>£" . $row['price'] . "</td>";
echo "<td>£" . $row['total'] . "</td>";
echo "<td>" . $row['payed'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close();
?>
</body>
</html>
Im completely stuck on this as im no php or mysql gurru...
so any help or info would be greatfull..
No comments posted yet
Your Answer:
Login to answer
234 
14 
Other forums
Production Order Enterprise Service to Manufacturing Exctn Sys (MES) ???
Hello Experts,
In our current landscape SAP ECC 5.0 is integrated to MES system via PI 7.
PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.
I have PHP code and <
Must-Know Topics of PHP
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of
why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?
Tha
unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.
Open/Close Links in Php
Hello, Hoping someone can inform me how I can get PHP to automatically open a set of links in a new
Getting Resource id #11 while trying to connect..
So i tried using "DEFINE" for the first time and im using the variables i defined to conne
Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re
php wont update my db
hello,
sorry for posting in mysql forum but i dont know where exactly is the problem but here
do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work
