Peter >How do i go about saving data to multiple tables from >one entry form or should this happen automatically If the model is that a user can have radios which in turn can have events, you need a userid column in users and radios, and a radioid column in radios and events. You need to read a bit about relational design (eg http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html). To add a user, a radio and an event, save the user info, get the user id from that insert, save the radio info, get back the radioid from that insert, then save the event info. To add a radio, retrieve the userid from the user's input and offer the user a blank radio form. And so on. PB ----- Peter Nikolic wrote: Hi folks I have several small data bases running on mysql 4.1.13 no problem brought a book read it yes welli have a data base consisting of 3 tables , radios , users , events radios contains 4 fields csgn , setid , sernum cmmnts. this is populated and is more a lookup table for the radio info then there is events this contains 5 fields evnt , eloc , edate , cllct_date , rtn_date and lastly users this contains 6 fields sur_nme , fr_name , ph_w , ph_h , ph_m , addrss Using knoda (part of kde) i have created an form that looks all very nice (to me ) the selection of the radio works enters the right info into the form i can enter users data and event data but when i try to save the data and insert a new row i am unable to my question is How do i go about saving data to multiple tables from one entry form or should this happen automatically The book i purchased "Beggining SQL" i did not find any help at all i could not find anything on mysql in my local store or a bit further out any help pointers much appreaceted Thanks Pete . |
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 8/14/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]