nigma,
Thanks again for your help. I will try this tomorrow. I will also read the manual pages and tutorial you recommended. This is why I come to this site. The helpful individuals like yourself.
Thanks,
Mark
Search found 8 matches
- Tue Aug 03, 2004 11:32 pm
- Forum: Databases
- Topic: Inserting and populate new field
- Replies: 4
- Views: 461
- Tue Aug 03, 2004 9:43 pm
- Forum: Databases
- Topic: Inserting and populate new field
- Replies: 4
- Views: 461
- Tue Aug 03, 2004 8:45 pm
- Forum: Databases
- Topic: Inserting and populate new field
- Replies: 4
- Views: 461
Inserting and populate new field
I have a site that is running on PHP/MySQL. I need to add a new field to a table. This is no problem, but I want to automatically populate this field in all records in the table. The value will be the same for every record, FL. I could go through manually and do this but there are 800 records to do....
- Mon Jul 26, 2004 10:42 pm
- Forum: Databases
- Topic: [SOLVED] Linking Tables
- Replies: 7
- Views: 585
- Sun Jul 25, 2004 9:51 pm
- Forum: Databases
- Topic: [SOLVED] Linking Tables
- Replies: 7
- Views: 585
- Sun Jul 25, 2004 9:13 pm
- Forum: Databases
- Topic: [SOLVED] Linking Tables
- Replies: 7
- Views: 585
- Sun Jul 25, 2004 9:03 pm
- Forum: Databases
- Topic: [SOLVED] Linking Tables
- Replies: 7
- Views: 585
ol4pr0, Thanks for the input. Maybe I am missing something but the resource.id I don't beleive will help me with the county part. I had tried something like this. SELECT resources.id, resources.name, resources.company, resources.phone, resources.category, resources.counties, sale.county FROM resourc...
- Sun Jul 25, 2004 8:25 pm
- Forum: Databases
- Topic: [SOLVED] Linking Tables
- Replies: 7
- Views: 585
Linking Tables
:x I have a site that I have developed using MySQL and PHP. On a particular page, I have two table that I would like to link. First table, resources, contains a field with a list of counties. The second table, sale, contains a field with a particular county. I have created several different recordse...