Search found 8 matches

by CyberGarage
Tue Aug 03, 2004 11:32 pm
Forum: Databases
Topic: Inserting and populate new field
Replies: 4
Views: 461

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
by CyberGarage
Tue Aug 03, 2004 9:43 pm
Forum: Databases
Topic: Inserting and populate new field
Replies: 4
Views: 461

nigma,

Thanks for the input but unfortunately I am new to both PHP and MySQL so I don't know how to create the queries. Any help you could give would be appreciated.

Thanks,
Mark
by CyberGarage
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....
by CyberGarage
Mon Jul 26, 2004 10:42 pm
Forum: Databases
Topic: [SOLVED] Linking Tables
Replies: 7
Views: 585

:D :D

Thanks guys for the help. I ended up passing the county when linking to the page and it is finally working. Thanks again for your help.

Mark
by CyberGarage
Sun Jul 25, 2004 9:51 pm
Forum: Databases
Topic: [SOLVED] Linking Tables
Replies: 7
Views: 585

feyd,

Thanks for the help. I would rather not have each county in its own field but have been thinking about doing it just to save some hassle.

Thanks,
Mark
by CyberGarage
Sun Jul 25, 2004 9:13 pm
Forum: Databases
Topic: [SOLVED] Linking Tables
Replies: 7
Views: 585

feyd, Thanks for the input. I tried the code you posted. Unfortunately no items were listed in my repeat region. In the resource table the field 'counties' is a text field with the counties list like "county1, county2, county3, ....". Could this be part of my problem? This is just driving ...
by CyberGarage
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...
by CyberGarage
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...