PHP and MySQL search mini-project to output combined data from four tables

Dear Freelancer, I will provide you all the details and you need to write a simple (no design) code. I need in the PHP-script: - a search form (lay-out will be provided), four criteria. I will guide you where to find the relevant data. - on the same page below the search form, the output: two simple, no design, tables. Basically, I have four tables in MySQL, which all have data that is linked (in a complicated way) with each other and I will guide you, which data is related to each other while you will write the script. It is important that you know how the: explode ";" command works in PHP to get the right result or identify the right data in a different column. The structure is as following: Table 1, has three relevant columns: Column 1 has the ID, Column 2 has the name, Column 3 has the shortname. In the search form we only show the shortname. Table 2, has two relevant columns: Column 1 has the ID we need to get, Column 2 has multiple ID's separated by ";". What we need to do is to match the ID from Table 1 Column 1 (lets say it;s 7) with one of the by ";" separated ID's in Table 2 Column 2 (lets say with 5;6;7;8 or 6;7 or 7;8) and then find what is written in Table 2 Column 1 (lets say 2). Table 3 is easy, we will match the ID we found in Table 2 Column 2, with Table 3 Column 1. If it matches, we show all data found in that row in the first table. Table 4 is easy aswell, we will match the ID we found in Table 2 Column 2, with Table 4 Column 1. If it matches we show all data found in that row in a second table. Quite easy. Looking forward to hear from you.