Lively discussions on the graphic arts and publishing — in print or on the web

Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 10-11-2013, 03:01 AM   #2
Barrie Greed
Join Date: May 2006
Location: Stringston, Somerset,UK
Posts: 114

A few thoughts which may or may not be of help.

I am not clear why you want to have a single form for amending records and adding records. Personally I would not mix, on the same form, two separate processes. I would have one web page for amending existing records and one page for entering new records.Once you start writing the data to mysql you will need to split the data between two separate statements anyway. An UPDATE statement to amend the existing records and an INSERT INTO statement to add the new records.

I may be misunderstanding your intentions but your post seems to suggest you were planning to use a single INSERT INTO statement for all the data. I cannot see how that could work. If you have any fields with unique data you will end up with a mysql error. If there is no unique data field you will duplicate the existing records.

Personally I use phpMyAdmin to administer databases. It is far easier. But you may need to set up arrangements for your web site users to update databases in the future so your current exercise will probably be useful in the long run.

If I have completely misunderstood what you are trying to do please post back with some more detail.

Barrie Greed
Barrie Greed is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
hold the Javascript! john_b Web Site Building & Maintenance 6 02-15-2012 08:17 AM
Eudora 7.1 with Java, JavaScript dthomsen8 Software 14 05-17-2007 01:43 PM
Firefox 1.5 JavaScript Console Kelvyn Web Site Building & Maintenance 0 12-13-2005 11:01 AM
Help with JavaScript coding ilox Web Site Building & Maintenance 15 09-07-2005 12:50 AM

All times are GMT -8. The time now is 06:06 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Contents copyright 2004–2018 Desktop Publishing Forum and its members.