PHP MySQL
Posted: Wed Aug 28, 2013 6:19 am
Hello, Sorry for making this my first post on here.
I am in the process of creating a php web app. However im not 100% sure about SQL and PHP together.
Each one of those businesses is assigned to a category. EG:
Table 1:
[*]id - (Auto Generated)
[*]Category
[*]SubCategory
[*]LinkPage
etc...
Table 2
[*]id
[*]SubCategory
[*]Business Name
etc...
So Heres the thing... I am struggling with what code in php i need to cross reference table 1 with table 2. So If a customer is on say a page where the category is Shopping and the sub category is gifts. What is the php mysql code?
Sorry if this sounded a little confusing. It is to me too.
I am in the process of creating a php web app. However im not 100% sure about SQL and PHP together.
Each one of those businesses is assigned to a category. EG:
Table 1:
[*]id - (Auto Generated)
[*]Category
[*]SubCategory
[*]LinkPage
etc...
Table 2
[*]id
[*]SubCategory
[*]Business Name
etc...
So Heres the thing... I am struggling with what code in php i need to cross reference table 1 with table 2. So If a customer is on say a page where the category is Shopping and the sub category is gifts. What is the php mysql code?
Sorry if this sounded a little confusing. It is to me too.