2 replies to this topic

[horacio2009]

Bom dia a todos!!
gostaria de saber a sintaxe correta para o seguinte pesquisa:
[codebox] $busca = mysql_query("SELECT count(*) FROM negociacao WHERE origem_boleto='banco';");[/codebox]
porém, quero apenas dados onde origem do boleto seja igual a "banco", "site","cliente"
aí, acabei tentando o seguinte, sem sucesso...


$busca = mysql_query("SELECT count(*) FROM negociacao WHERE origem_boleto='banco' or origem_boleto 'site' OR cliente='cliente';");

porém, não deu certo, não...
O que faço para chamar esses valores?
Obrigado a todos!!!
Horácio

[Felipe Pena]

Simplesmente utilize com IN.

Exemplo:

SELECT COUNT(*) FROM negociacao WHERE origem_boleto IN ('banco', 'site', 'cliente')

[hapedlok]

Discounts! best makeup for 2017


Products which fall under this return policy can be returned domestically, as long as they are unused and in the original packaging. No questions asked!
If a product that falls under this guarantee is found to be counterfeit, you will get a full refund (shipping costs included).


READ MORE
40inch malaysian virgin hair kinky straight hair natural black double sealer hair extension ( 132.08 $)
Sexy women bandage bikini set push up padded bra bathing suit swimsuit swimwear ( 2.51 $)
Middle Frame Plate Bezel Hex Screwdriver Repair Tool ( $2.06 )
2pcs 4 inch 18w led work light off road 4x4 4wd atv utv suv driving motorcycle light truck fog lamp headlight spot flood 12v 24v ( 37.46 $)
Gold-plated Flower Drop Necklace ( 160.00 $)
White Camelia Flower Brooch ( 84.00 $)
Pomogaj posle etogo lyudyam.. (Video)
045794P Universal Replacement 3.7V 2800mAh Li - polymer Rechargeable Battery ( $4.55 )
2016 cheap natural wave brazilian virgin hairllace front wigs short bob human hair full lace human hair wigs for black women ( 56.00 $)
Peruvian straight virgin hair with frontal closure 3 bundles straight hair with closure 360 lace frontal closure with bundles ( 130.00 $)
Joe Kennedy on Trump: His word is not good
Nightingale micro light pink leather satchel bag ( 1340.37 $) Givenchy
Brazilian lace frontal closure with bundles 3 Pieces hair with Lace Closure Straight Brazilian Virgin Hair with Closure Grade 8A ( 140.00 $)
OUKITEL U13 4G Phablet-168.22 $
Moskva slezam ne verit