altering basket contents

[nagelkruid]

i noticed the products_id in the customers_basket tables can either be stored as the real products_id say 123 or as 123:a2345erttetcetera.
What i make from it, probably zen_id's get stored along with the products_id into this products_id field when someone is logged in as opposed to someone not being logged in?

Is there a reason for that behaviour, is it expected?
I would prefer just the products_id would be listed and not the extended string so i can do normal searches on this column based on the products_id.

Thanks,
Jeroen

[Kim]

The "long string" is the product's attributes in a hash code. So you can't just "not have it":

[nagelkruid]

The "long string" is the product's attributes in a hash code. So you can't just "not have it":

Ah, i see, thanks

[Ajeh]

This is just a trick to convert the products_id from a products_id with a prid to just the products_id ...

Try this in phpMyAdmin ... there are better ways but this is a quick method I have used when I forget other ways ...
SELECT customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added, products_id*1 as prod_id FROM customers_basket WHERE 1The prod_id will be created with the products_id without the prid attached ...

To do a search on a products_id without the prid, you could search using the Like %...% with 133: to find products_id 133 ...

[nagelkruid]

This is just a trick to convert the products_id from a products_id with a prid to just the products_id ...

Try this in phpMyAdmin ... there are better ways but this is a quick method I have used when I forget other ways ...
SELECT customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added, products_id*1 as prod_id FROM customers_basket WHERE 1

Hello Linda,
I really like it, works great, although i can't get my head around the logic behind it The column is tiny text field so if you multiply it by 1 it will disregard anything behind the : because it thinks this is some sort of decimal value...

Mmm, probably not, but i never understand how those magicians out there get the rabbits out of their hat either

Nice trick, cheers,
Jeroen

[Ajeh]

One note on the use of the LIKE and the prid in the SQL statement ... you really want LIKE command with just the trailing %, example:

SELECT * FROM customers_basket WHERE products_id LIKE '133:%';

to avoid the issue of getting things like:
133
1133
2133
etc. etc. etc.

from being included in the match ...