jeudi 20 août 2015

MYSQL/Laravel - Select based on condition?

I'm having a hard time figuring this out:

I have multiple lotteries and a user can participate in each. Now when selecting the winners I only want to select users which havent won in a lottery before.

table lotteries
table "users" (column won is either 0 or 1)

How would I do this in mysql, preferably in laravels eloquent? Thanks!

laravel php laravel 5 laravel 4 laravel with laravel tutorial

Aucun commentaire:

Enregistrer un commentaire