drjay Posted February 9, 2009 Posted February 9, 2009 I'm working on customizing the databases a little bit and I made the products_id into my own unique part number instead of auto_increment. Here's the problem though, any time a products_id starts with '0' it will not add it to the shopping cart nor display any info on it, it just says that the product was not found. EG: product_info.php?products_id=90585 works fine product_info.php?products_id=090585 Product not found, even though it exists. It seems like it's failing a check somewhere but I can't seem to find where. I have looked in shopping_cart.php and a few others but nothing clearly shows where starting a products_id with 0 would mess it up. Please help me! :)
abremen Posted February 13, 2009 Posted February 13, 2009 I'm working on customizing the databases a little bit and I made the products_id into my own unique part number instead of auto_increment. Here's the problem though, any time a products_id starts with '0' it will not add it to the shopping cart nor display any info on it, it just says that the product was not found. EG: product_info.php?products_id=90585 works fine product_info.php?products_id=090585 Product not found, even though it exists. It seems like it's failing a check somewhere but I can't seem to find where. I have looked in shopping_cart.php and a few others but nothing clearly shows where starting a products_id with 0 would mess it up. Please help me! :)
abremen Posted February 13, 2009 Posted February 13, 2009 I'm working on customizing the databases a little bit and I made the products_id into my own unique part number instead of auto_increment. Here's the problem though, any time a products_id starts with '0' it will not add it to the shopping cart nor display any info on it, it just says that the product was not found. EG: product_info.php?products_id=90585 works fine product_info.php?products_id=090585 Product not found, even though it exists. It seems like it's failing a check somewhere but I can't seem to find where. I have looked in shopping_cart.php and a few others but nothing clearly shows where starting a products_id with 0 would mess it up. Please help me! :) I belive it has to do with the TYPE of the field in the database. Alter it to VARCHAR and try. I havent looked at the problem at all and its only me guessing so be sure to backup the database if you alter it. Good luck
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.