zackj85
Posts: 1
|
| Posted: 09/16/2008, 2:24 PM |
|
Hello,
I am kind of new to both CCS and PHP and still learning. While these forums make a large part of that (and I'm very thankful for it), I am running into a problem. Now, I believe the problem is very basic, and related to my lack of SQL/PHP knowledge so here it is.
A conventional e-commerce script, OSCommerce uses like 97 tables, storing almost everything conceivable in a separate table. So there is one table products, and one products description, and one products categories, that each uses a product_id field to determine the attributes (like names, price, etc. ) of one product. Here is the problem
When I build a query from multiple tables, and create a master detail form, I get like 23645 records, although there are only 27 in the database. I've tried numerous work arounds, including figuring out the relationships and implementing them in the query builder, but nothing works.
Any leads will mean a lot.
Cheers,
Zack
|
 |
 |
paulmason411
Posts: 127
|
| Posted: 09/18/2008, 6:15 PM |
|
Can you post the sql of your query?
_________________
http://paulmason.name - Web Development Blog
|
|
|
|
|
