mysql complex query

nicolasd

Hello,

I'am newbie and sorry for my english, i'm french.


For a db project for train modelism, i need to extract data from several db (marques, categories, inventaire, sigles).

How to adapt server_processing php file for this sql query for example :

[code]
SELECT mat_marques.marque_name, mat_marques.marque_id, mat_categories.categories_name, mat_inventaire.reference, mat_inventaire.num_em
FROM mat_inventaire, mat_marques, mat_categories
WHERE mat_inventaire.marque_id LIKE %s AND
mat_inventaire.categories_id LIKE %s AND
mat_marques.marque_id = mat_inventaire.fab_id AND
mat_categories.categories_id = mat_inventaire.categories_id
[/code]

Thanks for your help,

Nicolas