Tema: Problema con Mysql_num_rows
Ver Mensaje Individual
  #2 (permalink)  
Antiguo 11/02/2011, 10:24
smolina
 
Fecha de Ingreso: enero-2011
Ubicación: Bucaramanga
Mensajes: 60
Antigüedad: 13 años, 3 meses
Puntos: 1
Respuesta: Problema con Mysql_num_rows
tabla glpi_tracking

Código MySQL: 
Ver original
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.10.3
  3. -- http://www.phpmyadmin.net
  4. -- 
  5. -- Servidor: localhost
  6. -- Tiempo de generación: 11-02-2011 a las 11:11:18
  7. -- Versión del servidor: 5.0.51
  8. -- Versión de PHP: 5.2.6
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. -- 
  13. -- Base de datos: `casu`
  14. -- 
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. -- 
  19. -- Estructura de tabla para la tabla `glpi_tracking`
  20. -- 
  21.  
  22. CREATE TABLE `glpi_tracking` (
  23.   `ID` int(11) NOT NULL auto_increment,
  24.   `FK_entities` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_entities (ID)',
  25.   `name` varchar(255) collate utf8_unicode_ci default NULL,
  26.   `date` datetime default NULL,
  27.   `closedate` datetime default NULL,
  28.   `date_mod` datetime default NULL,
  29.   `status` varchar(255) collate utf8_unicode_ci default 'new',
  30.   `author` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_users (ID)',
  31.   `recipient` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_users (ID)',
  32.   `FK_group` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_groups (ID)',
  33.   `request_type` smallint(6) NOT NULL default '0',
  34.   `assign` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_users (ID)',
  35.   `assign_ent` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_enterprises (ID)',
  36.   `assign_group` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_groups (ID)',
  37.   `device_type` int(11) NOT NULL default '0' COMMENT 'see define.php *_TYPE constant',
  38.   `computer` int(11) NOT NULL default '0' COMMENT 'RELATION to various table, according to device_type (ID)',
  39.   `contents` longtext collate utf8_unicode_ci,
  40.   `priority` smallint(6) NOT NULL default '1',
  41.   `uemail` varchar(255) collate utf8_unicode_ci default NULL,
  42.   `emailupdates` smallint(6) NOT NULL default '0',
  43.   `realtime` float NOT NULL default '0',
  44.   `category` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_dropdown_tracking_category (ID)',
  45.   `cost_time` decimal(20,4) NOT NULL default '0.0000',
  46.   `cost_fixed` decimal(20,4) NOT NULL default '0.0000',
  47.   `cost_material` decimal(20,4) NOT NULL default '0.0000',
  48.   `date_required` datetime default NULL COMMENT 'Representa la fecha en la que es requerido el caso',
  49.   PRIMARY KEY  (`ID`),
  50.   KEY `computer` (`computer`),
  51.   KEY `author` (`author`),
  52.   KEY `assign` (`assign`),
  53.   KEY `date` (`date`),
  54.   KEY `closedate` (`closedate`),
  55.   KEY `status` (`status`),
  56.   KEY `category` (`category`),
  57.   KEY `FK_group` (`FK_group`),
  58.   KEY `assign_ent` (`assign_ent`),
  59.   KEY `device_type` (`device_type`),
  60.   KEY `priority` (`priority`),
  61.   KEY `request_type` (`request_type`),
  62.   KEY `FK_entities` (`FK_entities`),
  63.   KEY `recipient` (`recipient`),
  64.   KEY `assign_group` (`assign_group`),
  65.   KEY `date_mod` (`date_mod`)
  66. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=38 ;
  67.  
  68. -- 
  69. -- Volcar la base de datos para la tabla `glpi_tracking`
  70. -- 
  71.  
  72.  
  73.  
  74. INSERT INTO `glpi_tracking` VALUES (25, 0, 'clave correo', '2011-01-26 18:04:09', '2011-01-31 17:11:22', '2011-01-31 17:11:22', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: sdsdsd\r\nJustificacion: dssd\r\nRecomendaciones: sdds\r\nTelefono de contacto: sdsdsddsd', 3, NULL, 0, 0, 3, 0.0000, 0.0000, 0.0000, '2011-01-27 00:00:00');
  75. INSERT INTO `glpi_tracking` VALUES (31, 0, 'Instalar oficce', '2011-02-04 08:57:49', '2011-02-04 08:58:37', '2011-02-04 08:58:37', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: paquete ofimatico\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 5, NULL, 0, 0, 1, 0.0000, 0.0000, 0.0000, '2011-02-05 00:00:00');
  76. INSERT INTO `glpi_tracking` VALUES (27, 0, 'FECHA-DE CREACION DEL TICKET', '2011-01-31 09:24:59', '2011-01-31 17:11:54', '2011-01-31 17:11:54', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: COMPARACIOND DE FECHAS\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 5, NULL, 0, 0, 2, 0.0000, 0.0000, 0.0000, '2011-02-01 00:00:00');
  77. INSERT INTO `glpi_tracking` VALUES (28, 0, 'probando fechas', '2011-01-31 09:52:24', '2011-01-31 17:09:26', '2011-01-31 17:09:26', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: aaa probando\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 5, NULL, 0, 0, 2, 0.0000, 0.0000, 0.0000, '2011-02-01 00:00:00');
  78. INSERT INTO `glpi_tracking` VALUES (32, 0, 'problemas de conexion', '2011-02-07 16:40:45', '2011-02-07 16:45:26', '2011-02-07 16:45:26', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: problemas de conexion\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 1, NULL, 0, 0, 1, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');
  79. INSERT INTO `glpi_tracking` VALUES (33, 0, 'red', '2011-02-07 16:41:11', '2011-02-07 16:45:16', '2011-02-07 16:45:16', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: red conexion\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 2, NULL, 0, 0, 2, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');
  80. INSERT INTO `glpi_tracking` VALUES (34, 0, 'correo', '2011-02-07 16:41:30', '2011-02-07 16:45:07', '2011-02-07 16:45:07', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: cambia clave\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 3, NULL, 0, 0, 3, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');
  81. INSERT INTO `glpi_tracking` VALUES (35, 0, 'informatica', '2011-02-07 16:41:52', '2011-02-07 16:44:55', '2011-02-07 16:44:55', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: salas de informatica\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 4, NULL, 0, 0, 4, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');
  82. INSERT INTO `glpi_tracking` VALUES (36, 0, 'otro requerimiento', '2011-02-07 16:42:16', '2011-02-07 16:44:37', '2011-02-07 16:44:37', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: requerimientos\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 3, NULL, 0, 0, 6, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');
  83. INSERT INTO `glpi_tracking` VALUES (37, 0, 'portales', '2011-02-07 16:42:44', '2011-02-07 16:44:10', '2011-02-07 16:44:10', 'old_done', 3, 3, 0, 1, 0, 0, 0, 0, 0, 'Descripcion: publicar inf en la web\r\nJustificacion: \r\nRecomendaciones: \r\nTelefono de contacto: ', 3, NULL, 0, 0, 7, 0.0000, 0.0000, 0.0000, '2011-02-08 00:00:00');