Lost in record filter

Hello

I am lost in a data filter situation and can't figure it out how to do it. Pls help me.

My situation is like as below;

I have a table where the data is like

suraid ---- aya
1 ---- 1
1 ---- 2
1 ---- 3
2 ---- 1
2 ---- 2
2 ---- 3

I need to query the result like 1:2,2:3 which means the first digit 1 should match with suraid and the second digit 2 should match with aya from the same row and so on and the with a coma separate it will look for next query value match in same way

My live url is new.hadithbd.com/quran/filter/index.php?id=1:2,2:3

You would have to hand code this. You would use the explode() function to break up the string into an array around the comma, then write a loop to go through that array and then use explode again to break up the strings on the colon.

Then you could loop on those values and build the appropriate WHERE clause to find the results.

Originally Said By: Ray Borduin

  You would have to hand code this. You would use the explode() function to break up the string into an array around the comma, then write a loop to go through that array and then use explode again to break up the strings on the colon.

Then you could loop on those values and build the appropriate WHERE clause to find the results.  

Noted, seems it's not easy task for me :(

I've gone ahead and got this working for you. In the future I'd need you to purchase a premier support ticket for custom coding help like this.

Originally Said By: Ray Borduin

  I've gone ahead and got this working for you. In the future I'd need you to purchase a premier support ticket for custom coding help like this.  

Really appreciate your support Ray. For sure I will. Thanks a lot. :)