Converting PHP Process to MySQL

Question

select c.kupon, count(*) as count
            from kuponbahis c
            join bahis b 
                on b.sonuc = c.secim 
                and b.ID = c.bahis 
            group by c.kupon
            having count(case when c.bahis ='$sonuclandirilacakbahis' then 1 end) > 0

With this query I'm getting kupon IDs and counts. Then fetching them in PHP and matching with the result of

SELECT COUNT(*) FROM kuponbahis WHERE kupon='$kuponid'

(while fetching the second query, too.) If it's a match, i'm doing some work.

But now, I want to do this in SQL directly.

My PHP code is below;

$kazananKuponlariGetirSorgu = mysql_query("select c.kupon, count(*) as count
from kuponbahis c
join bahis b 
    on b.sonuc = c.secim 
    and b.ID = c.bahis 
group by c.kupon
having count(case when c.bahis ='$sonuclandirilacakbahis' then 1 end) > 0");

while ($kazananKuponlariGetirSorgux = mysql_fetch_array($kazananKuponlariGetirSorgu)){

        $kuponid = $kazananKuponlariGetirSorgux[0];
        $tutanbahisadet = $kazananKuponlariGetirSorgux[1];


        $kupondakiBahisAdeti = mysql_query("SELECT COUNT(*) FROM kuponbahis WHERE kupon='$kuponid'");
        $kupondakiBahisAdetix = mysql_fetch_array($kupondakiBahisAdeti);

        if ($kupondakiBahisAdetix[0]==$tutanbahisadet){
            //it's a match
        }

I tried many queries but they all failed. How can I merge this two sql process to only one?

match

Could you maybe show us a little of your data, or the structure of the table? — Nelewout
– Nelewout, Commented Jan 10, 2016 at 14:42
php.net/manual/function.mysql-query.php ... Be aware of mysql_query is dead .. — user4412122
– user4412122, Commented Jan 10, 2016 at 14:50

Gordon Linoff · Accepted Answer · 2016-01-10 14:43:06Z

4

The obvious way is in the having clause:

select c.kupon, count(*) as count
from kuponbahis c join
     bahis b 
     on b.sonuc = c.secim and b.ID = c.bahis 
group by c.kupon
having sum(c.bahis = '$sonuclandirilacakbahis') > 0 and
       count(*) = (SELECT COUNT(*) FROM kuponbahis WHERE kupon = '$kuponid');

answered Jan 10, 2016 at 14:43

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting PHP Process to MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related