I am using PHPRunner 2.0 (I know, I know, I need to update... it's been a while since I've needed to do anything database driven) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9451&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
My query is kinda detailed so bear with me. What I'm trying to do works kind of like a shopping cart, except it's just for my own use to help me put together orders (I own a convenience store in Old Town Alexandria and I'm trying to make my life easier).
I want to be able to look up everything I purchase from a specific vendor, display it on the web, input how many of each item I need to purchase for this week, save that data for historical trending & generate an email to myself with the order.
I have been playing around with PHPRunner trying to see if I can use the generated code to give me a base and then manually alter things in the code to do what I need but I'm getting hung up on being able to display everything from a specific vendor within my "products" table, edit the "order" field and then have it insert the new record with the updated "order" field into my "order_history" table.
Is this something I can accomplish fairly easily if I just spend the time to think it through and edit the code manually or would I be better off buying the shopping cart template items listed on the site and trying to finesse that into working?
Thanks!