query pengecekan data

 

halo, saya punya tabel database. pada tabel tsb ada kolom nama, a1,a2,a3, sampai a50.

saya mau melakukan pengecekan data pada kolom kolom tsb. jika ada satu nilai "0" pada kolom a1 sampai a50, maka akan ditampilkan kata "gugur", jika tidak ada nilai "0", maka ditampilkan kata "lulus"

MySQL PHP

Published Budget: Open to Suggestions
Finish Days: 1
Published Date: 13/12/2018 11:29:20 WIB
Start Date: 14/12/2018 11:00:55 WIB
Finish Date: 19/12/2018 07:56:49 WIB
Project Status: Closed
Accepted Worker: Iswanto (Iswanto)
Accepted Budget: Rp 50,000
Project Ending: Completed

Project Owner

deravenal
    
10.00/10.00
4 Point
#10,244 dari 344,237
Rated Worker: 10.00/10.00

adwafwafsafqe

Accepted Worker

Iswanto
Kota Jakarta Utara
    
9.72/10.00
24,736 Point
#2 dari 344,237
Rated Owner: 10.00/10.00

tq ya mas

semoga bisa bekerja sama lagi

  User Bids

googol
    
9.89/10.00

Govi37
    
10.00/10.00

Iswanto
    
9.72/10.00

raman23
    
9.97/10.00

anlichandra
    
9.67/10.00

alhafizputra
    
10.00/10.00

rizky04
    
10.00/10.00

donaldsir
    
10.00/10.00

sastrakom
    
10.00/10.00

fred_lim
    
9.97/10.00

ludmilamaudi
    
10.00/10.00

Syarif
    
10.00/10.00

awalmaulanarohman
    
9.82/10.00

daphino
    
9.94/10.00

Tisnadinata
    
9.88/10.00

cybersoftmedia
    
9.93/10.00

sgmsby
    
9.93/10.00

zer0evolution
    
10.00/10.00

kudou77
    
4.00/10.00

rasmuji
    
0.00/10.00

reedking
    
0.00/10.00

yehezqiel
    
0.00/10.00

Herman_Echo
    
0.00/10.00

Rammdhan.akbar
    
0.00/10.00

setiawannuha
    
0.00/10.00

Recommended Workers

Muhammad.Rahman

14,732 points
168 projects
    
9.79/10.00

steven.comptia

40,284 points
871 projects
    
9.97/10.00

manakreatif

13,222 points
109 projects
    
9.72/10.00

imzers

13,062 points
64 projects
    
9.89/10.00

rakifsul

13,945 points
58 projects
    
10.00/10.00

Recommended Services

Pembuatan bot line

Rp 1,500,000
6 sales
    
10.00/10.00

Tiru Website Lain Sesuai Keinginan (Cloning)

Rp 650,000
8 sales
    
9.75/10.00

Jasa Pembuatan website Wordpress + Elementor

Rp 650,000
9 sales
    
10.00/10.00

Jasa Pembuatan Robot Otomatisasi Website/Web Browser

Rp 500,000
4 sales
    
10.00/10.00

Open Projects

Sliding Window Python

Owner: lautpelaut
Budget: Rp 150,000 - 250,000

Butuh diajarkan proses pembuatan psikogram

Owner: ronaldtambupolon
Budget: Rp 100,001 - 200,000

Bug Fixing CodeIgniter (By Remote)

Owner: AYATSETIAWAN
Budget: Rp 150,000 - 300,000

Perbaiki Admin Panel EMKL / Freight Forwarding web apps

Owner: amirsalman
Budget: Rp 1,000,000 - 2,000,000

Membuat website company profile dengan wordpress

Owner: tirtak
Budget: Rp 5,000,000 - 5,000,000

 


Live Chat