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 item is stored as a session variable.Now on the database I have
> ALL inventory items, but I want to only display the details of what the user
> has in his cart.
> eg. : I want something like this:
> $result = mysql_query("SELECT * from Inventory where ItemNumber is in

Other folks have made suggestions, but this is way simpler.  Assuming 
the session vars and ItemNumber are numbers:

  $result = mysql_query('SELECT * from Inventory where ItemNumber IN (' .
  implode(',', $_SESSION) . ')');

If it's strings:

  $result = mysql_query("SELECT * from Inventory where ItemNumber IN ('" .
  implode("','", $_SESSION) . "')");


               PHP classes that make web design easier
        SQL Solution  |   Layout Solution   |  Form Solution
    sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to