Hola, gracias por tu respuesta. Es eso justo lo que necesito pero no logro ponerlo a andar. Si me pudieses echar una manita te lo agradecería. Trabajo con php y mi base de datos es la siguiente:
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
--
http://www.phpmyadmin.net
--
-- Generation Time: Oct 31, 2004 at 11:05 PM
-- Server version: 4.0.18
-- PHP Version: 4.3.8
--
-- Database: `car`
--
-- --------------------------------------------------------
--
-- Table structure for table `site_cars`
--
CREATE TABLE `site_cars` (
`car_id` int(11) NOT NULL auto_increment,
`car_model` int(11) NOT NULL default '0',
`car_make` int(11) NOT NULL default '0',
`car_year` int(4) NOT NULL default '0',
`car_price` varchar(100) NOT NULL default '',
`car_mileage` int(4) NOT NULL default '0',
`car_track` varchar(100) NOT NULL default '',
`car_vin` varchar(100) NOT NULL default '',
`car_dealer_price` varchar(100) NOT NULL default '',
`car_sold_price` varchar(100) NOT NULL default '',
`car_sold_to` varchar(200) NOT NULL default '',
`car_dealer_notes` text NOT NULL,
`car_description` longtext NOT NULL,
`car_tn_image` int(1) NOT NULL default '0',
`car_image` int(1) NOT NULL default '0',
PRIMARY KEY (`car_id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
--
-- Dumping data for table `site_cars`
--
INSERT INTO `site_cars` VALUES (7, 21, 16, 2004, '21800', 8000, '', '', '', '', '', '', 'Almost new, super quiet ride. This has all the features that you want. Rated number 1 by ABC reports.', 1, 1);
INSERT INTO `site_cars` VALUES (6, 17, 14, 2002, '18900', 25900, '', '', '', '', '', '', 'Need to tow your trailer, this is the vehicle for the job. Imaculate inside and out. CD player and leather seating.', 1, 1);
INSERT INTO `site_cars` VALUES (5, 19, 15, 1995, '9800', 0, '', '', '', '', '', '', 'Test', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `site_make`
--
CREATE TABLE `site_make` (
`make_id` int(11) NOT NULL auto_increment,
`make_parent` int(11) NOT NULL default '0',
`make_name` varchar(200) NOT NULL default '',
PRIMARY KEY (`make_id`)
) TYPE=MyISAM AUTO_INCREMENT=23 ;
--
-- Dumping data for table `site_make`
--
INSERT INTO `site_make` VALUES (1, 0, 'Audi');
INSERT INTO `site_make` VALUES (2, 0, 'BMW');
INSERT INTO `site_make` VALUES (3, 0, 'Renault');
INSERT INTO `site_make` VALUES (4, 0, 'General Motors');
INSERT INTO `site_make` VALUES (5, 0, 'Ford');
INSERT INTO `site_make` VALUES (6, 3, 'Laguna');
INSERT INTO `site_make` VALUES (7, 3, 'Megane');
INSERT INTO `site_make` VALUES (8, 3, 'Clio');
INSERT INTO `site_make` VALUES (9, 3, 'Logan');
INSERT INTO `site_make` VALUES (10, 5, 'Escort');
INSERT INTO `site_make` VALUES (11, 5, 'Focus');
INSERT INTO `site_make` VALUES (12, 5, 'Mondeo');
INSERT INTO `site_make` VALUES (13, 5, 'Fiesta');
INSERT INTO `site_make` VALUES (14, 0, 'Chevrolet');
INSERT INTO `site_make` VALUES (15, 0, 'Honda');
INSERT INTO `site_make` VALUES (16, 0, 'Toyota');
INSERT INTO `site_make` VALUES (17, 14, 'Suburban');
INSERT INTO `site_make` VALUES (18, 14, 'Malibu');
INSERT INTO `site_make` VALUES (19, 15, 'Accord');
INSERT INTO `site_make` VALUES (20, 15, 'Civic');
INSERT INTO `site_make` VALUES (21, 16, 'Camry');
INSERT INTO `site_make` VALUES (22, 16, 'Sienna');
-- --------------------------------------------------------
--
-- Table structure for table `site_photos`
--
CREATE TABLE `site_photos` (
`id` int(11) NOT NULL auto_increment,
`car` int(11) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`description` text NOT NULL,
`tn` int(1) NOT NULL default '0',
`image` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `site_photos`
--
INSERT INTO `site_photos` VALUES (1, 2, 'Inside View', 'Image downloaded from .net', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `site_users`
--
CREATE TABLE `site_users` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL default '',
`user_login` varchar(100) NOT NULL default '',
`user_password` varchar(100) NOT NULL default '',
`user_level` int(1) NOT NULL default '0',
PRIMARY KEY (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
--
-- Dumping data for table `site_users`
--
INSERT INTO `site_users` VALUES (3, 'Admin', 'admin', 'test', 0);
INSERT INTO `site_users` VALUES (2, 'Jon Doe', 'test', 'test', 1);
-- --------------------------------------------------------
--
-- Table structure for table `site_vars`
--
CREATE TABLE `site_vars` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;
--
-- Dumping data for table `site_vars`
--
INSERT INTO `site_vars` VALUES (32, 'ipp', '15');
INSERT INTO `site_vars` VALUES (33, 'mail_address', '
[email protected]');
INSERT INTO `site_vars` VALUES (34, 'mail_title', 'AUTO: Details Request');
INSERT INTO `site_vars` VALUES (35, 'mail_link', '1');
INSERT INTO `site_vars` VALUES (36, 'task_user', '1');
Si me pudieses preparar un ejemplo para hacer una busqueda con alguno de estos datos te lo agradezco. Muchisimas gracias de antemano.