How to filter one database query by another

[dennismcdougall]

What I am hoping to do is filter one database query by another.

I have two databases and they both have a field call vehicle_type. What I want to happen is that vehicle_type from the products database filters what is shown from the accessories database.

These are my SQL queries

SELECT * FROM products WHERE id = %s",

SELECT * FROM accessories WHERE vehicle_type=''";

I think the accessories query should look like
SELECT * FROM accessories WHERE vehicle_type=''$vehicle_type";

but I don't know how to give $vehicle_type a value from the products database.

Hope this makes sense, any help would be greatly appreciated.

Thanks Dennis :0)

[vaaaska]

You can do this to access both...or either...or whatever...

products.vehicle_type
accessories.vehicle_type

I think that you really want to do this however...

WHERE products.vehicle_type = '$id' AND products.vehicle_type = accessories.vehicle_type

😉

[Roger_Ramjet]

First problem is just a matter of terminology.
You do NOT have 2 Databases, you have 2 Tables in the same Database.

This shows that you do not yet understand what a relational database is. Try reading these articles so that you do:
SQL Theory
Data normalisation and databasedesign

Once you do understand the technology then you will easily realise that what you need to solve this particular problem is a query with a JOIN

SELECT * FROM products INNER JOIN accessories ON products.vehicle_type = accessories.vehicle_type
WHERE products.id = %s

Will return the product and all accessories for a given product id.