Can someone help me finish the WHERE statement? -based on itemID from cart contents

I want to display only those records whose cart's content "itemID" is in the cart.
BUT the cart contents do NOT contain ALL the information that the corresponding db table has in it (which I want to display here).

The final objective is show the item's additional information on the confirm.php page below the shopping cart display.

Can someone help me finish the WHERE statement?

SELECT *
FROM PD_Courses
**eCart Contents ItemID*****help needed here*****eCart Contents ItemID**
WHERE PD_Courses.CoursesID = <?php echo $eCart1->DisplayInfo("ID"); ?>
??????
ORDER BY DisplayOrder ASC

Thank you in advance your time and know-how,

John

your query is correct already:

SELECT *
FROM PD_Courses
WHERE PD_Courses.CoursesID = <?php echo $eCart1->DisplayInfo("ID"); ?>
ORDER BY DisplayOrder ASC


you just need to place it in a cart loop along with the code to display it:

<?php while (!$eCart1->EOF()) { ?>
<recordset here>
<code to display record information here>
<?php
$eCart1->MoveNext();
}
$eCart1->MoveFirst();
?>

Thanks very much Jason.

you're welcome.