Moved by moderator to PHP - Code forum.
I have an oscommerce site that I am customizing. I have set up the php code on the admin side of the store to add a product rebate to the database. I also have the code to add the product rebate expire date but it dosen't remove the rebate when the set date passes. Does anyone know of a function or an if statement I can use for this purpose?
Thanks, Rickey
Change table in mysql db
Moderator: General Moderators
Re: Change table in mysql db
You'll have to post your code and tell us how your rebate system has been implemented.
Re: Change table in mysql db
I have put the whole pages in text format so you can see the code. There are two pages.
http://rickspcparts.com/product_info.txt
http://rickspcparts.com/categories.txt
I created the tables in the database, products_rebate and products_rebate_expire. Both these tables are in the main products table. The file "categories.txt" is what actually loads the rebate amount and expire date to the database. The "product_info.txt" is the file on the store side that the customer sees. here is an example of the customer side:
http://rickspcparts.com/catalog/product ... ts_id=4953
http://rickspcparts.com/product_info.txt
http://rickspcparts.com/categories.txt
I created the tables in the database, products_rebate and products_rebate_expire. Both these tables are in the main products table. The file "categories.txt" is what actually loads the rebate amount and expire date to the database. The "product_info.txt" is the file on the store side that the customer sees. here is an example of the customer side:
http://rickspcparts.com/catalog/product ... ts_id=4953
- JAB Creations
- DevNet Resident
- Posts: 2341
- Joined: Thu Jan 13, 2005 6:44 pm
- Location: Sarasota Florida
- Contact:
Re: Change table in mysql db
This forum is not for asking programming related questions.
Re: Change table in mysql db
I thought that was the purpose of this forum. Excuse me.
Re: Change table in mysql db
You're excused and I've moved the thread to the PHP - Code forum, where it belongs. Do look at the descriptions of the forums before posting, though. Thank you.rickeyl wrote:I thought that was the purpose of this forum. Excuse me.