This topic is locked

Copying from one table to another

12/2/2009 11:52:47 PM
PHPRunner General questions
J
junior79 author

ok here's the deal,
I am trying to create a simple thing that I just cant figure out how to do.
I have a mysql databse all setup in phprunner and such,

I want to add a button in the list menu that after I Search for a record I can select it, click the "Need" button and have that selected entry copy to another table in the same database.
database its layed out
shoptlist

+..........+

items printlist
so the idea it find it in items table and once found click "need" button and have it copied to printlist so that at the end of the week i can print the printlist table and go shopping.
anyone have a few minutes to show me how/point me in the right directon/ write a few lines of code
I am making a simple project for a barcode enabled shoppinglist via the web for my wife
Many thanks

jerome

J
Jane 12/3/2009

Jerome,
here is a helpful link:

http://www.xlinesoft.com/phprunner/docs/update_multiple_records.htm

Just replace UPDATE query with your custom INSERT query in the sample event.