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');
<!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">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />


<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":''; ?> />
<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):""; ?>

$result = mysql_query("SELECT * FROM customers INNER JOIN order_detail ORDER BY orderid DESC");

echo "<table border='1'>
<th>Order Number</th>
<th>Address 1</th>
<th>Address 2</th>
<th>Post Code</th>

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>";
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 Like 14 Dislike
Previous forums Next forums
Other forums

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

PHP5 - Verifying a secure mail is secure
I need to send an e-mail from a form to a external department and because it contains personal custo

replica orologi, orologi economici, Rolex Watches, orologi a buon mercato vendere, comprare orologi di sconto, orologi di lusso on-line
rolex orologirolex orologi
omega orologi


Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Google+ Indyaspeak @ Pinterest RSS