🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: chile.comp.programacion
Article #3218

Re: contar campos en mysql

#3218
From: Rickoj
Date: Thu, 14 Apr 2005 04:52
44 lines
2247 bytes
En las news:d3kmsk$sj3$1@news1.nivel5.cl, a RobertoCL se le ocurrio tipear:
> Pero mysql_num_rows() es PHP, no se  vale ;-P
>> En el cap�tulo anterior (news:d3kkib$rb7$1@news1.nivel5.cl), "+mArkO+"
>> <kitim@porta.com> dijo:
>>
>>> <?php
>>>
>>> $result = mysql_query("SELECT * FROM usuarios");
>>> if (!$result) {
>>>    echo 'Could not run query: ' . mysql_error();
>>>    exit;
>>> }
>>> /* retorna la cantidad total de campos de la consulta*/
>>> echo mysql_num_fields($result);
>>>>
>>>
>>
>> En ese caso, sugiero:
>>> $result = mysql_query("SELECT * FROM usuarios LIMIT 0,1");
>> Para ahorrar espacio...
>>
>> En todo caso, me parece m�s directo (la otra podr�a fallar si no hay
>> registros)
>>
>> <?php
>>
>>  // conectar...
>>
>> $result = mysql_query("DESCRIBE usuarios");
>> if (!$result) {
>>    echo 'Could not run query: ' . mysql_error();
>>    exit;
>> }
>> /* retorna la cantidad total de campos de la consulta*/
>> echo mysql_num_rows($result);
>>>
>>
>>
>> --
>>                           Jose M. Santiba�ez A.
>>                             <jms@nivel5.cl>
>>                           <http://caos.cl/jms>

grax no me acordaba como era, en todo caso en php y mysql me servian gracias
Technical Details
Message-ID: <d3kt37$ufo$1@news1.nivel5.cl>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!not-for-mail
References: <d3kjl9$qv0$1@news1.nivel5.cl> <d3kkib$rb7$1@news1.nivel5.cl> <Xns9637E7DE0F82Ejmsnews@200.27.221.71> <d3kmsk$sj3$1@news1.nivel5.cl>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,446a760b4d2d3ec7
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!not-for-mail
From: "Rick_oj" <rick_oj@[sin-esto]tutopia.com>
Newsgroups: chile.comp.programacion
Subject: Re: contar campos en mysql
Date: Thu, 14 Apr 2005 00:52:48 -0400
Organization: Varios
Lines: 46
Message-ID: <d3kt37$ufo$1@news1.nivel5.cl>
References: <d3kjl9$qv0$1@news1.nivel5.cl> <d3kkib$rb7$1@news1.nivel5.cl> <Xns9637E7DE0F82Ejmsnews@200.27.221.71> <d3kmsk$sj3$1@news1.nivel5.cl>
NNTP-Posting-Host: pc-97-201-120-200.cm.vtr.net
X-Trace: news1.nivel5.cl 1113454504 31224 200.120.201.97 (14 Apr 2005 04:55:04 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Thu, 14 Apr 2005 04:55:04 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478