| | |
Grabbing newly enetered data from table once updated
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jan 2008
Posts: 16
Reputation:
Solved Threads: 0
I am putting together an inventory system which keeps count of the stock level.
I have the inventory database setup for example:
Product Stock_level
Battery1 25
Whenever "Battery 1" is bought, it adds a row to the "orders_products" table.
Is there a way where i can have an update button which will check to see if there are any new rows since the last press of the update button which will allow me to deduct 1 off the stock level of "Battery 1" ???
I hope I have made sense!
I have the inventory database setup for example:
Product Stock_level
Battery1 25
Whenever "Battery 1" is bought, it adds a row to the "orders_products" table.
Is there a way where i can have an update button which will check to see if there are any new rows since the last press of the update button which will allow me to deduct 1 off the stock level of "Battery 1" ???
I hope I have made sense!
![]() |
Other Threads in the PHP Forum
- Previous Thread: text editor using javascript
- Next Thread: Is That Possible in PHP
| Thread Tools | Search this Thread |
apache api array beginner beneath binary broadband broken button cakephp checkbox class cms code compression countingeverycharactersfromastring crack cron curl database date decode display dynamic echo email error file files folder form forms function functions google href htaccess html httppost image include insert integration ip javascript joomla limit link links login mail match md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf php problem protocol query radio random recursion regex remote script search server session sessions sms smtp soap source space sql strip_tags survey syntax system table tutorial undefined update upload url validator variable video virus votedown web window.onbeforeunload=closeme; xml youtube






