[w2n]

Hi everyone,

What I have is a multi-dimensional array in a plain text database, like follows...

Code:

Film Name | Director | Country | Synopsis | Runtime | Venue | Date | Time
Movie 1 | Director 1 | USA | Text goes here | 180 Minutes | London | November 11 | 6 PM
Movie 2 | Director 2 | Belgium | Text goes here | 90 Minutes | New York | November 13 | 4 PM
Movie 3 | Director 3 | India | Text goes here | 120 Minutes | Paris | November 17 | 8 PM

Now, with my code, I can show all these film details, in a HTML table, where I can put these data fields. This is DONE.

What I am trying to achieve is...

If I want to show 'all the films', for which the venue is LONDON (for example, total 5 films), or all the films to be shown on November 15, what should be the piece of code.

I know, there must be an use of 'in_array' or 'array_search', but I am not being able to finalize the shortest and simplest code to be used for this.

This should be an function, where I can mention, 'what field to be sorted' and what is the field value. To be more specific, if I want to show all the films in LONDON as the venue, the function should be like this...

films('Venue', 'London'); // To show all the films, in London

-OR-

films('Date', 'November 15'); // To show all the films shown on November 15.


Then, this function will return an multi-dimensional array, consisting of similar structure as the original and full array like above, and the function will return something like this (for London Venue)...

Code:

Film Name | Director | Country | Synopsis | Runtime | Venue | Date | Time
Movie 1 | Director 1 | USA | Text goes here | 180 Minutes | London | November 11 | 6 PM
Movie 32 | Director 32 | Belgium | Text goes here | 90 Minutes | London | November 14 | 4 PM
Movie 46 | Director 46 | India | Text goes here | 120 Minutes | London | November 17 | 8 PM

Notice, these are the films, where 'London' is common as 'Venue' field.

Please help me writing this small piece of code.

Thanks in advance,

[End User]

This would be trivial to do in a real database, but in a plain text format it becomes much more complicated. Is there a reason you don't want to put this into a real database system?

[Jay6390]

I would suggest you use a foreach loop and add the rows to an array that correspond to the query however without seeing any code for how you have set up the multidimensional array i cant really expand on that

Jay

[w2n]

Dear everyone,

I wanted to use plain text database, as the film numbers are somewhere around 300. And, I thought, doing it in plain text database will be easier than MySQL, since I don't know MySQL much.

Anyway, I came with a solution on my own and it's working perfectly now. It is using in_array and preg_match and it's working fully, exactly like the way I wanted it.

Thanks again for all the help!