CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Searching Multiple Tables with CodeCharge

Print topic Send  topic

Author Message
Ryan Kelley
Posted: 05/03/2001, 6:58 AM

Hi,

I am semi-new to the database driven website thing and i have chosen to go
with MySQL and PHP 4.0. I am also using codecharge for all of my page
design where i access the database.

What I am needing to do is to search with one field, 5 or more tables that
all have the same structure but different data. What i am building is a
vehicle search. On my first one the user will just be able to search one
make of trucks by the model. But there will be in essence 5 "dealers"
inputing there own data and i do not want them to be able to mess with each
others inventory. So thats why i need to use 5 tables. Also i need to use
5 tables because i am going to build a form in Excel so they can keep track
of all of there inventory locally and then post it to a text file and then
upload it into their table. I am sorry if i am confusing anyone. If you
can please help

Thanks,


Ryan Kelley

CodeCharge
Posted: 05/05/2001, 1:49 PM

Ryan,

You should consider using just 1 table for all your dealers, and add an
identifying field, such as "dealer_code" in your table.
If you use 5 tables, sure you can search them, but I don't know how would
you display the results. You will probably also run into many problems
later. And if you add or remove dealers, you will end up rewriting many
queries. This really wouldn't look like the right implementation of the
database.
If you use single table, you will need to be cautious as to select and
update only the records for specific dealer, but in the end you will spend
less time and will have much more reliable and solid application, than if
you chose to use multiple tables.
As for loading Excel into the table, you may need to write manual code for
this, and in such case it should be fairly easy to add "dealer_code" in such
program, to update the database correctly.
Please look at the Classifieds example included with CodeCharge, as there
are some similarities to your project.

Regards,

Adam S.
CodeCharge Support


"Ryan Kelley" <ryankelley@freightliner.com> wrote in message
news:9cro5i$8op$1@mail.tankhill.com...
> Hi,
>
> I am semi-new to the database driven website thing and i have chosen to go
> with MySQL and PHP 4.0. I am also using codecharge for all of my page
> design where i access the database.
>
> What I am needing to do is to search with one field, 5 or more tables that
> all have the same structure but different data. What i am building is a
> vehicle search. On my first one the user will just be able to search one
> make of trucks by the model. But there will be in essence 5 "dealers"
> inputing there own data and i do not want them to be able to mess with
each
> others inventory. So thats why i need to use 5 tables. Also i need to
use
> 5 tables because i am going to build a form in Excel so they can keep
track
> of all of there inventory locally and then post it to a text file and then
> upload it into their table. I am sorry if i am confusing anyone. If you
> can please help
>
> Thanks,
>
>
> Ryan Kelley
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.