11 replies to this topic

[jinyam]

Quero fazer uma paginação por letras para um site de detonados e dicas de games .
Me ajudem please

[victorpfm]

Cria um link pra cada letra (pagina.php?letra=x).
E faz querys no banco de dados usando o parâmetro LIKE.

Edição feita por: victorpfm, 25/06/2005, 23:14.

[Felipe Pena]

Obtendo as iniciais dos registros (c/ distinção):

$Consulta = mysql_query("
            SELECT UPPER(LEFT(campo, 1)) inicial
            FROM tabela
            GROUP BY inicial
            ORDER BY inicial")
            or die (mysql_error());

while ($rs = mysql_fetch_array($Consulta)) {
    $aIniciais[] = $rs["inicial"];
}

print join(" | ", $aIniciais);

[jinyam]

Obtendo as iniciais dos registros (c/ distinção):

$Consulta = mysql_query("
            SELECT UPPER(LEFT(campo, 1)) inicial
            FROM tabela
            GROUP BY inicial
            ORDER BY inicial")
            or die (mysql_error());

while ($rs = mysql_fetch_array($Consulta)) {
    $aIniciais[] = $rs["inicial"];
}

print join(" | ", $aIniciais);

o inicial seria a letra??

[Felipe Pena]

Se tenho na tabela os registros:

ASP
PHP
CGI
PHP
ASP

Irá imprimir:
A | C | P

Ou seja, terá as iniciais dos registros do BD.
Com isso, você poderá colocar um link em cada INICIAL, indicando a mesma numa variável passando-a pela URL (Método GET), ex.: ver.php?inicial=A

Daí na página ver.php você pega o valor da variável inicial e faz uma consulta aonde os dados de uma (ou mais) colunas começam com a INICIAL constatada na URL...

[jinyam]

Bom pelo que percebi esse script so pega as primeiras letras do campo eu queria saber como selecionar todos registros começando com tal letra

Edição feita por: jinyam, 26/06/2005, 00:16.

[victorpfm]

Cria um link pra cada letra (pagina.php?letra=x).
E faz querys no banco de dados usando o parâmetro LIKE.

Faz isso

Exemplo:

$sql = "SELECT * FROM tabela WHERE campo LIKE " . $letra . "% ORDER by campo ASC";

[jinyam]

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\profilegames\teste.php on line 6

$sql = "SELECT * FROM tutoriais WHERE titulo LIKE " . $letra . "% ORDER by titulo ASC";

PQ TA DANDO ESSE ERRO??

[X-PHP]

Olá,

Tenta desta forma

$banco = mysql_query("select * from tabela WHERE LEFT(nome,1) = '$letra' ORDER BY nome");

Qualquer coisa é só dar o toque.

T+

[jinyam]

Bom eu fiz funcionar com o esquema do X-PHP só que tipo quando eu boto no

AND categoria = '$categoria'

No query não acha nenhum resultado me ajudem

Edição feita por: jinyam, 26/06/2005, 10:23.

[RonsisM]

Mixing Amoxicillin With Penicillin viagra Buy now worldwide isotretinoin shop
Levitra De 10mg Conseil Utilisation Du Viagra online pharmacy Tabletten Viagra Foto Cialis Over The Counter Buy Orlistat 120mg In Usa
Clomid Boule buy viagra Dexamethasone Over Counter Kamagra Tabletten Wirkung
Dapoxetine 30 Mg Precio Cialis 20 Mg En Farmacia Isotretinoin acutane viagra online Where To Buy Nexium Vente Viagra Sur Internet

[zapedlok]

Discounts! great makeup products 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 2016white peel off liquid nail art tape latex tape finger skin protected liquid palisade easy clean ( 1.75 $)Leather Zip-Around Wallet ( 94.50 $)7a brazilian deep wave with closure queen hair products with closure 4pcs brazilian deep curly human hair with lace closure a+ ( 56.73 $)Aquarium Siphon Water Suction Filter Pump Pipe ( $3.39 )LEGO and robotics, to purchase in the online store EduCubeLand - carry-on trolley ( 372.96 $) PiquadroNew Suspension Trainer Fitness Training Strength Training Hanging Strap Workout Sport Equipment Resistance Bands Hanging Trainer ( 28.98 $)V-neck 3d dragon and thorns printed short sleeve t-shirt for men ( 21.07 $)Graz navy blue suede loafer shoe wrubber sole ( 321.29 $) MoreschiBiver, DzhimHotsale diving mask underwater breathing tube water sport full dry snorkeling swimming training scuba anti fog for gopro camera ( 24.02 $)Black Baker 36.5MM Round Womens Watch ( 199.00 $)ROCK Metal MFI certified Lightning to USB Cable For iPhone 5 SE 6 6s plus iPad Nylon Braid Fibre fast charging iPhone Cable USB ( 11.52 $)car seat covers set black faux fur cute car interior accessories cushion styling winter new plush car pad seat covers for car ( 25.00 $)Prevailing maysu short human hair wigs for women middle parting mono top brazilian virgin hair blonde wig capless european style ( 80.00 $)
Discounts! best skin products 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
Modelej obyazali predyavlyat pri trudoustrojstve medspravku. (Video)
MY — 20 Electronic Candle LED Light Simulation Decorative Lamp 3pcs-10.69 $
SUHARI
Top quality inlay led dots rosewood fretboard canadian maple electric guitar neck wholesale guitar parts accessories ( 101.37 $)
Usa size foot ball team men women super warm thicken fleece zip up hoodie jacket sweatshirts coat ( 36.50 $)
40cm acrylic round hanging modern led pendant light lamp for dining living room lighting , lustres de sala teto ( 136.48 $)
5 in 1 Waterproof Electric Hair Clipper Kemei Professional Hair Trimmer Shaver Beard For Men Waterproof Family Haircut Tool #55 ( 51.12 $)
Indian virgin hair water wave 4 bundle vip beauty indian curly virgin hair natural weave ali moda raw indian wet wavy human hair ( 58.00 $)
Sleek body wave 3 pcs lot 8a brazilian virgin hair deep wave mink brazilian human hair ( 154.17 $)
Kerui english spanish russian french voice home security alarm system gsmpstn dual net android or ios app gsm alarm system ( 126.34 $)
DrWeb CureIt! Rus [] skachat besplatno Dr.Web CureIt! 10.0.7 Rus [2017-04-11]
Stainless Steel Cardinal Points Rudder Pendant Necklace ( 109.00 $)
Motospeed V10 USB Gaming Wired Mouse-15.79 $
HONHX 62B Sports Children LED Digital Wristwatch ( $1.95 )
Promotion! 15 Pcs Chinese Medical Pain Relief Patch 1218CM Porous Capsicum Plaster for JointArthriticMuscle Pain Health Care ( 15.60 $)



Discounts! best and beauty


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
Outdoor survival watch bracelet with compass flint fire starter paracord thermometer whistle multifunction camping band ( 7.98 $)
18 SheetsSet French Manicure DIY Nail Art Tips Guides Stickers Stencil Strip #M01615 ( 1.80 $)
2016 police tactical vest outdoor camouflage military body armor sports wear hunting vest army swat molle vest black ( 90.00 $)
3 ports 2a micro usb eu plug charging portable mobile phone adapter travel wall charger for ( 2.88 $)
On sale automatic control valve cd-ft for water filter rohs ce ( 106.93 $)
Leisure lace-up and hidden wedge design women's platform shoes ( 34.39 $)
Cowhide genuine leather shoulder bags small crossbody bag ipaid men messenger bags handbag small men's leather bag male flap mva ( 63.00 $)
Baseus 0.23mm tempered glass film for iphone 7 7 plus 9h hardness pet soft 3d curved full cover anti-blue light screen protector ( 10.65 $)
Professional XIAOMI MI4 Original PU Protective Cover Case with Wake up Function ( $5.99 )
Women backpack 2016 famous brand school bags for teenagers travel canvas laptop backpack travel mochila printing backpack women ( 62.00 $)
Auxmart s2 car led headlight kit h4 h7 h11 h13 9005 hb3 9006 hb4 cob led ( 26.88 $)
Jeff Sessions: Travel ban protects Americans
Sexy black scoop neck long sleeve see-through t-shirt for women ( 5.28 $)
2016 Summer Retro Round Sunglasses Men Women Multicolor Vintage Sun Glasses Eyewear Women Oculos de sol feminino Sunglass UV400 ( 4.20 $)
Hot sale 2016 thick powerful vibrators g-spot vibrator for women sex toys anal nipple vibrator sex products magic sex machine ( 49.90 $)



Discounts! product web page 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 Original Anytek AT66A Car DVR full HD Novatek 96650 Car Camera Recorder Black Box 170Degree 6G Lens Supper Night Vision Dash Cam ( 68.22 $)Carteras mujer women wallet clutch wallet female case phone carteiras femininas money bag purse card holder ( 3.98 $)5 Kinds of Categories Purple Blueberry Seed Windowsill Roof Fruit Seed Potted Bonsai Tree Plant Vaccinium Seed a Pack 200 Pcs ( 1.08 $)Ophir pro 3 tips dual action airbrush gravity paint gun compressor tank kitfor temporary tattoo tanning hobby#ac090+ac074 ( 101.51 $)Le Galenn, EvaMarylin - Heart w Crystal Drop ( 135.00 $)NEW ZOEVA 15 PCS ROSE GOLDEN COMPLETE MAKEUP BRUSH SET Professional Luxury Set Make Up Tools Kit Powder Blending brushes ( 20.98 $)New 2 in 1 car camera radar detector 720p russian english language laser radar night vision ( 58.56 $)Square Style Digital Hand Warmer-15.15 $Ms cat hair brazilian body wave 3pcs lot 7a grade brazilian virgin hair body wave 100% virgin brazilian human hair weave bundles ( 43.08 $)Winter jacket women large fur collar hooded jacket thick coat for women outwear parkacoatscasacos de inverno feminino ( 35.00 $)ELEMENTAREE all food for 3280 R.Silicone Magnetic Clasp Clip Case Holder for Xiaomi Mi Band ( $2.07 )Lovely pet new lingerie underwear bra sock laundry washing aid net mesh zip bag rose 922 ( 0.99 $)Off White Fabric and Leather Sneaker ( 136.00 $)
Discounts! best face care products 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
Mini Paisley Print Twill Silk Ascot ( 48.00 $)
New 2016 winter coat women slim plus size outwear medium-long wadded jacket thick hooded cotton wadded warm cotton parkas ( 22.98 $)
Pair of chic bohemian geometric pattern knitted leg warmers for women ( 7.60 $)
New arrival 5d square diamond painting snow house cross stitch kit diy set embroidery rhinestone home decor needlework az007 zx ( 13.80 $)
Super bright home decoration luminous diy funny cute cat switch sticker glow in the dark living ( 1.36 $)
Plus size women hoodies & sweatshirts winter thickening warm cotton fashion female cat print big size casual turtleneck dress ( 32.80 $)
New high quality women clutch bag fashion pu leather handbags flap shoulder bag ladies messenger bags ( 8.40 $)
8 inch Teclast X80 Pro Tablet PC-114.30 $
2 pcs car seat crevice interior seat cover leakproof protective sleeve seam for audi a1 a3 a4 a6 a8 a7 tt q3 q5 q7, car styling ( 7.99 $)
Cycling Motorcycle Bicycle Chain Crankset Brush Cleaner Cleaning Tool Cleaner Blue Car Accessory Free Shipping ( 3.41 $)
3 styles 2016 hot sales cartoon funny cat moving tail stickers reflective car window wiper decals ( 4.90 $)
K13 Cree XML T6 600Lm Rechargeable LED Headlamp ( $8.15 )
Online store construction materials in Moscow best prices in Geostroy.ru
Lcd security wireless gsm alarm system home house office burglar intruder alarm ( 124.44 $)
Men's Genuine Leather Briefcase Shoulder Bag Casual Handbag Totes Crossbody Men Messenger Laptop Bag Business Leather Briefcase ( 90.25 $)