Page 1 of 1

PHP MySQL

Posted: Wed Aug 28, 2013 6:19 am
by windywindle
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.