I was hoping to create a search script where a user can search for a mobile phone on my website. The user is able to put the manufacturer name or the phone name e.g. Nokia or 6230. Please could any1 help.
The following is the tables i have;
Code:
CREATE TABLE `my_phones` (
`manufacturer` varchar(20) NOT NULL default '',
`phone_id` int(4) unsigned NOT NULL auto_increment,
`manufacturer_id` int(3) unsigned NOT NULL default '0',
`phone_name` varchar(60) NOT NULL default '',
`price` decimal(6,2) NOT NULL default '0.00',
`weight` varchar(60) default NULL,
`dimensions` varchar(255) default NULL,
`image_name` varchar(30) default NULL,
`network` varchar(50) NOT NULL default '',
`introduced` varchar(20) NOT NULL default '',
`STATUS` varchar(15) NOT NULL default '',
`TYPE` varchar(50) NOT NULL default '',
`size` varchar(40) NOT NULL default '',
`ringtones` varchar(75) NOT NULL default '',
`vibration` varchar(20) NOT NULL default '',
`data` varchar(75) NOT NULL default '',
`phonebook` varchar(40) NOT NULL default '',
`call_records` varchar(50) NOT NULL default '',
`messaging` varchar(75) NOT NULL default '',
`Bluetooth` varchar(10) NOT NULL default '',
`CAMERA` varchar(100) NOT NULL default '',
`USB` varchar(30) NOT NULL default '',
`other` varchar(100) NOT NULL default '',
`other2` varchar(35) NOT NULL default '',
`other3` varchar(35) NOT NULL default '',
`other4` varchar(35) NOT NULL default '',
`other5` varchar(35) NOT NULL default '',
`infrared_port` varchar(30) NOT NULL default '',
`games` varchar(100) NOT NULL default '',
`colors` varchar(75) NOT NULL default '',
PRIMARY KEY (`phone_id`),
The results should display;
phone_name, image_name (image itself, along with a link to the actual phone) and the price.
Any help would be appreciated.
Search Script
