>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
>$HTTP_SESSION_VARS");
>// I need proper syntax to replace "is in"
>
>where Inventory has, ItemNumber (unique), Price, ItemName.
>So say the surfer has three items in the Session, then I stored the three
>unique ItemNumbers.
>Then with the above query I can get the rest of the information to represent
>to the user.
>I am looking down the avenues of a Set datastyp or maybe Enum, but I don't
>know if it will help.
create table cart(
session_id char(32),
item_id int
);
Then, if I have item #42, #57, and #314, there will be 3 rows in this table
for me:
adsfqweradfzxcvasdfqwer 42
adsfqweradfzxcvasdfqwer 57
adsfqweradfzxcvasdfqwer 314
So you can just:
select item_id from cart where session_id = $PHPSESSID
--
Like Music? http://l-i-e.com/artists.htm
I'm looking for a PRO QUALITY two-input sound card supported by Linux (any
major distro). Need to record live events (mixed already) to stereo
CD-quality. Soundcard Recommendations?
Software to handle the recording? Don't need fancy mixer stuff. Zero (0)
post-production time. Just raw PCM/WAV/AIFF 16+ bit, 44.1KHz, Stereo
audio-to-disk.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
