Change table in mysql db

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
rickeyl
Forum Newbie
Posts: 4
Joined: Sat Mar 07, 2009 10:26 pm

Change table in mysql db

Post by rickeyl »

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
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Change table in mysql db

Post by Benjamin »

You'll have to post your code and tell us how your rebate system has been implemented.
rickeyl
Forum Newbie
Posts: 4
Joined: Sat Mar 07, 2009 10:26 pm

Re: Change table in mysql db

Post by rickeyl »

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
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Change table in mysql db

Post by JAB Creations »

This forum is not for asking programming related questions.
rickeyl
Forum Newbie
Posts: 4
Joined: Sat Mar 07, 2009 10:26 pm

Re: Change table in mysql db

Post by rickeyl »

I thought that was the purpose of this forum. Excuse me.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Change table in mysql db

Post by califdon »

rickeyl wrote:I thought that was the purpose of this forum. Excuse me.
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.
Post Reply