I would like to know the answer too. Anyone here know what is the answer to that question. I'll do some research in Google and get back to you if I bump into an good answer. You should email the people at iPage as they probably could give you an answer..
I have a really modified store so this could be wrong - but if you are reffering to product_info.php not giving you the discriptions I know that the $product_info_query has.
P.products_id = '"(int)$HTTP_GET_VARS['products_id'].
In it so if your product id has a letter in it - it int a int.
(thus returning no row).
Hope this helps.
This post has been edited by.
: 19 April 2004, 14:56..
Okay, thanks i'll try changing that. I appreciate the responses..
Okay, I tried changing that (int) to (varchar), but I got a parse error. Is there another variable that should be changed to in order to allow the letters in the product id? thanks for all the help!..
It has to be a data type (e.g. int, float, etc etc - varchar isn't) or just try removing the int all together - will probebly do it..
Thanks so much!!! that worked, just deleted the (int) from the code...
You'll have bugs all around, osCommerce depends on ids being integers, and.
Ids are used internally as primary and foreign keys. Their actual value should not be used. If you need a code, just add a products_code field and use that...
Interesting. I thought there might be some kind of a snag like that. If I add another field though, will I have to reconfigure the preexisting fields. The reason I want to allow varchar for the prod id is so that I can recognize the prod id # easily without having to necessarily look it up in the product description table. So, if I bring everything back to the int values, and then add this extra field, i'm not sure it will really help with what i'm looking to do. There will be a field with the id I want, but in order to make use of it, I will still have to keep going back to compare the int prod id with the new field.
Again, thanks for all the help!!!..
I understand you'd like to recognize the product from the URL?.
Of course you can modify the code to use alphanum products_ids. It's not *that* difficult, but you'll have to check everywhere a products_id is used, and possibly change the code. There is a trick you can see if you select a product with attributes..
Maybe you could add.
To the URL you're interested in?..
I added an 'Item Number' field using the instructions found in this contribution:.
I've carried the number through from the product_info.php page to the checkout pages and into the Email confirmation and order form. You can see it in action via the WWW link below..
Thanks everyone for your help!!! I'm going to look into those suggestions...
I changed in phpadmin the defaults for product id to varchar from int so that I could add letters to my product ids. Everything is connected fine, except on the webpage, the three products that have ids with letters are not generating any descriptions. Does anyone know if there is any specific code that must be modified as well besides the database tables in mysql?.
I would really appreciate if anyone could help me on this..
Thanks for the response, but that's something I already knew. The problem is that the products that have letters in their product id are not displaying their descriptions on the webpage. I was wondering if there might be some code in the indes.php that I need to modify. Anybody?..