Aynı nerede ile Çoklu seçiniz

0 Cevap php

Ben orada kimliği üzerinden masa "harfleri" bir item ile masa "sayı" bir items ilişkilendirmek 'karşılaşmalar' adında bir tablo var.

Yani benziyor

number_id, letter_id 
1,10 
2,10
3,10
5,11
4,23
7,19 
1,19
3,64

now the user inputs an array of numbers, say 1,2,3 and I have to find the letter where all of it's numbers are 1,2,3, which would be 10. If they gave 1,7 it would give them 19, if they gave 3 it would give them and 64.

Bunu nasıl yapabilirim?

I've been trying to write a recursive function for this but it always breaks. is there some sort of:

SELECT letter_id WHERE **number_id***s* = 1,2,3. That would be perfect. :)

0 Cevap