Re: [PHP] mySQL Queries using PHP's SESSION variables

2002-07-25 Thread Analysis & Solutions
On Thu, Jul 25, 2002 at 02:51:13PM -0400, Anup wrote: > Hello, I am stuck here. In the name of efficiency I want to lower the number > of callls to the database. So I am trying to give the most stringent query > possible. This is the problem: I have stored the surfers shopping cart, > where each i

Re: [PHP] mySQL Queries using PHP's SESSION variables

2002-07-25 Thread Tech Support
well, you could simply loop through the session vars and build the query as you go. $query = "SELECT * FROM Inventory WHERE"; // I'm assuming you keep your item numbers in a "items" or something similar foreach ($HTTP_SESSION_VARS['items'] as $pid) $subquery .= " ItemNumber = '$pid' OR "; //