Insert or Update Record

[teamfox20]

Can someone please show me how to add a Insert record or if record exisits then update it.

[kgt]

That's a very general question. Here's a general answer:

 

http://dev.mysql.com/doc/refman/5.1/en/insert.html

http://dev.mysql.com/doc/refman/5.1/en/update.html

 

If you can ask a specific question, a more specific answer could be given. For example, explain what you're trying to do.

[teamfox20]

I have a form where a customer can enter misc. information we will call them fields 1-9...

 

None of these fields are found in the oscommerce database so i created a new table and added a row manually via mysql admin...and it updates just fine....but when i log in as another user(not the one i manually created a record for), i need it to be able to create a new row as well as update a current row if customers_id and email matches any of the records...i pass the customers_id and email address also, along with field 1-9 as to be able to keep everything in sync.

 

Im assuming i have to add/edit the query info in the database.php page but im not sure what to do.

 

I am available via AIM if you want to contact me... CEBCSDanny

 

Thank you!

[kgt]

Is this form part of the account edit page? Or is it a separate page you have added?

[teamfox20]

I added an extra page, called account_edit_rates.php

 

 

Is this form part of the account edit page? Or is it a separate page you have added?

[teamfox20]

I added an extra page, called account_edit_rates.php

 

 

i figured it out....when they sign up i made it add an empty field in TABLE_RATES with only the email address and customers_id....so then they can update it.....

 

thanks anywho!