Ver Mensaje Individual
  #1 (permalink)  
Antiguo 05/11/2012, 02:12
Avatar de syntex
syntex
 
Fecha de Ingreso: noviembre-2002
Ubicación: Cataluña
Mensajes: 978
Antigüedad: 21 años, 5 meses
Puntos: 4
contar consulta de registros

Hola buenas,

Tengo que hacer una consulta y contar los registros mostrados de unos 20000 registros pero quiero expluir unos cuantos, habría otra mejor manera?


Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\pixelpointonline_server\app\lib\Bd .php on line 183

$consulta = mssql_query("SELECT CODIGO FROM dbo.articulo WHERE (CODIGO !='' and BAJA != 1 and CODIGO != '882224240628' and CODIGO != '9315514330' and CODIGO != '4010869184335' and CODIGO != '8432596017407' and CODIGO != '8432596021343' and CODIGO != '8432596017490' and CODIGO != '8808992491040' and CODIGO != '4010869184359' and CODIGO != '4010869184342' and CODIGO != '4010869184366' and CODIGO != '4010869184908' and CODIGO != '4010869184236' and CODIGO != '4010869184229' and CODIGO != '4010869184212' and CODIGO != '4010869184243' and CODIGO != '4010869184922' and CODIGO != '8432596019432' and CODIGO != '8432596019173' and CODIGO != '4010869184588' and CODIGO != '4010869184731' and CODIGO != '4010869184717' and CODIGO != '045496369736' and CODIGO != '5030917099205' and CODIGO != '8429015011580' and CODIGO != '8429015011597' and CODIGO != '8429015012044' and CODIGO != '8429015012051' and CODIGO != '8806071605098' and CODIGO != '8436532300608' and CODIGO != '8436532300615' and CODIGO != '8436532302114' and CODIGO != '8429015012440' and CODIGO != '8429015012464' and CODIGO != '8436044523458' and CODIGO != '4560389460216' and CODIGO != '4027301054538' and CODIGO != '6700372710197' and CODIGO != '6700372722060' and CODIGO != '8713439158571' and CODIGO != '8429015012501' and CODIGO != '8713439156492' and CODIGO != '8436025918334' and CODIGO != '8436532303470' and CODIGO != '8436532303432' and CODIGO != '8436532303456' and CODIGO != '4560389460360' and CODIGO != '4905524853353' and CODIGO != '8436025918372' and CODIGO != '8436025915715' and CODIGO != '8436025918396' and CODIGO != '8436025918402' and CODIGO != '8436025918389' and CODIGO != '4905524853469' and CODIGO != '8436025918419' and CODIGO != '5025232275809' and CODIGO != '5025232275762' and CODIGO != '8436025918440' and CODIGO != '885370291278' and CODIGO != '885370357431' and CODIGO != '882224092142' and CODIGO != '885370356809' and CODIGO != '885370268089' and CODIGO != '882224623223' and CODIGO != '4005209118712' and CODIGO != '5030934072427' and CODIGO != '3296580804238' and CODIGO != '3391891955867' and CODIGO != '3391891955799' and CODIGO != '3296580806836' and CODIGO != '885370091694' and CODIGO != '885370091786' and CODIGO != '5030934097147' and CODIGO != '5055277005680' and CODIGO != '3546430124338' and CODIGO != '3546430135471' and CODIGO != '5055277001606' and CODIGO != '5026555245104' and CODIGO != '9315514317' and CODIGO != '5030917089497' and CODIGO != '5030917092152' and CODIGO != '9006113173144' and CODIGO != '8023171010106' and CODIGO != '3307211504530' and CODIGO != '5030934059015' and CODIGO != '5030934067478' and CODIGO != '5030934078443' and CODIGO != '3307217923595' and CODIGO != '3307210334800' and CODIGO != '3307210263421' and CODIGO != '3307210451453' and CODIGO != '3307217927234' and CODIGO != '3307219942815' and CODIGO != '3307215634936' and CODIGO != '3307212315128'),$conexion);
$count_alta = mssql_num_rows($consulta);

El problema es si tuviera que excluir de la consulta 15000 registros como ejemplo.
Muchísimas gracias.
__________________
------------------------------------------------
La paciencia es el rey de la ciencia
------------------------------------------------


Última edición por syntex; 05/11/2012 a las 02:19