Creating Order History

I am trying to create or Order History page per the .pdf help file. On page 6, it says to modify the sql statement. Everything works until my where statement. I changed it as told to WHERE orderdetails.DetailOrderID = paramOrderID AND orders.OrderUserID = paramUserID

When I try to test it says paramOrderID is an invalid variable name. It does not appear in the sql. This is after I adder the new variable on page 8 of instructions.

Any help would be appreciated.

That error suggests that the when you created the variable, the name was not exactly the same as what was used in the SQL.

Remember, the variable names are case sensitive. paramOrderID is not the same as ParamOrderID (Note the capital P) If you continue to get an error, post a screen shot of the Recordset window showing the SQL and the variable.

Thanks that seemed to solve that problem but now I get a error message when I load the page after I am already logged in.

Fatal error: Call to undefined function: wa_auth_rulepasses() in /homepages/44/d232789399/htdocs/buyorsellvideos/Templates/customer_order_history.php on line 333

Here is the code on customer_order_history.php line 333

<?php if (!WA_Auth_RulePasses("Logged in to Users")){ ?>
<a href="../Users_LogIn.php">Login</a>
<?php } else { ?>
<a href="../Users_LogOut.php?ID=<?php echo $_SESSION['UserID']; ?>">Logout</a>
<?php } ?>
<?php if (WA_Auth_RulePasses("Logged in to Users")){ ?>
Welcome <?php echo $row_welcome['UserFirstName']; ?> &nbsp;<a href="../orderhistory.php">My Listings</a>
<?php } ?>

There is most likely a problem with the code order,

Find the line similar to:
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>

and move it to line 1.

I did have a coding error but now I get results but there are blank records but still numbered (1-4) Also, when I click to view the details of the results I get following error.

Fatal error: Cannot redeclare class wa_altclassiterator in /homepages/44/d232789399/htdocs/buyorsellvideos/Templates/customer_order_details.php on line 162

This is line 162

<?php
//WA AltClass Iterator
class WA_AltClassIterator {
var $DisplayIndex;
var $DisplayArray;

function WA_AltClassIterator($theDisplayArray = array(1)) {
$this->ClassCounter = 0;
$this->ClassArray = $theDisplayArray;

That error means the following code is duplicated on the page:

<?php
//WA AltClass Iterator
class WA_AltClassIterator {
var $DisplayIndex;
var $DisplayArray;

function WA_AltClassIterator($theDisplayArray = array(1)) {
$this->ClassCounter = 0;
$this->ClassArray = $theDisplayArray;
}

function getClass($incrementClass) {
if (sizeof($this->ClassArray) == 0) return "";
if ($incrementClass) {
if ($this->ClassCounter >= sizeof($this->ClassArray)) $this->ClassCounter = 0;
$this->ClassCounter++;
}
if ($this->ClassCounter > 0)
return $this->ClassArray[$this->ClassCounter-1];
else
return $this->ClassArray[0];
}
}
?>


The second instance of that code can be deleted.

Thanks, I'm not getting any error messages but still not getting order history to come up. It says there are records but the columns are blank. Then when I click on view,edit or delete. It says no records found. Should I open a ticket?

Please advise.

I have created a support ticket for you. Please replay to your ticket by logging into your support history at the following URL:
supporthistory.php

Looking at the code on the page, i found that the recordsets where not created properly:

On the Order History page, the problem is the WADAOrders recordset.


the select statement was limiting the columns returned:
SELECT OrderUserID FROM Orders

It should be:
SELECT * FROM Orders


On the order details, User ID Session Variable was being compared to the Order ID column in the Where statement:
AND Orders.OrderID = paramUID

it should be the OrderUserID column
AND Orders.OrderUserID = paramUID

This problem is very similar to mine -- I'm sure it's something wrong with my code.

Here's a screenshot of what I have. I've pasted the code below in case you can't read the image.

Note that my table is "visitors" and not "users."

SELECT orders.*, orderdetails.*
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailOrderID
WHERE orderdetails.DetailOrderID = WADAOrderID AND orders.OrderVisitorID = paramUserID

Also note that in the wizard when I create the param I already have an exisiting param. Are there supposed to be 2 param?

Thanks.