Re: erro al pretender contar desde php contra mysql

Article View: es.comp.os.linux.programacion

Article #7498

Back to es.comp.os.linux.programacion Previous Next

#7498

From: Woden Malkav
Date: Tue, 18 Feb 2003 12:33

24 lines
1917 bytes

>> $result = mysql_query ("select count(*) as cuenta  from usuarios where
>> nick='$nick'");
>> $row = mysql_fetch_assoc ($result);
>> $cuantos=$row["cuenta"];
>> 
>> pero esto me da este error:
>> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
>> result resource in /home/usuario/pagina.php on line 317
>> siendo la linea 317 esta: $row = mysql_fetch_assoc ($result);

Prueba con esto:
$result = mysql_query ("SELECT COUNT(*) FROM usuarios WHERE nick='$nick' ");

... sin el "as cuenta" ...

por otro lado no entiendo mysql_fetch_assoc, por que no usas 
mysql_fetch_row ?

-- 
Woden Malkav
ICQ: 10786243 / MSN: wodenmalkav / AOL: karvader
http://www.infohackers.org
PGP -> http://www.keyserver.net/en/
Key ID: 0x86678F94

Technical Details

Message-ID: <b2t8o7$qht$1@nsnmrro2-gest.nuria.telefonica-data.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!fu-berlin.de!nsnmpen1-lo.nuria.telefonica-data.net!nsnmrro2-lo.nuria.telefonica-data.net!not-for-mail

References: <b2lktn$1da7rm$1@ID-59646.news.dfncis.de> <b2p38g$g2b$1@pinsa.escomposlinux.org>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f86c8,87626d83aff48a11
X-Google-Attributes: gidf86c8,public
X-Google-ArrivalTime: 2003-02-18 04:25:50 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!fu-berlin.de!nsnmpen1-lo.nuria.telefonica-data.net!nsnmrro2-lo.nuria.telefonica-data.net!not-for-mail
From: Woden Malkav <wodenmalkav@hotmail.com>
Newsgroups: es.comp.os.linux.programacion
Subject: Re: erro al pretender contar desde php contra mysql
Date: Tue, 18 Feb 2003 13:33:04 +0100
Organization: AIH
Lines: 24
Message-ID: <b2t8o7$qht$1@nsnmrro2-gest.nuria.telefonica-data.net>
References: <b2lktn$1da7rm$1@ID-59646.news.dfncis.de> <b2p38g$g2b$1@pinsa.escomposlinux.org>
NNTP-Posting-Host: 58.red-80-34-140.pooles.rima-tde.net
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
X-Trace: nsnmrro2-gest.nuria.telefonica-data.net 1045571143 27197 80.34.140.58 (18 Feb 2003 12:25:43 GMT)
X-Complaints-To: usenet@nsnmrro2-gest.nuria.telefonica-data.net
NNTP-Posting-Date: Tue, 18 Feb 2003 12:25:43 +0000 (UTC)
User-Agent: KNode/0.6.1

Reply to Parent Message