This is the following code that I made and imported using PHPmyAdmin...
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 29, 2011 at 09:25 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `school_of_engineering`
--
-- --------------------------------------------------------
--
-- Table structure for table `Inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`ID` varchar(10) NOT NULL,
`Name` varchar(20) NOT NULL,
`Qty` int(10) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `Inventory`
--
INSERT INTO `Inventory` (`ID`, `Name`, `Qty`) VALUES
('1', 'Breadboard', 1),
('10', 'Utility Cutter', 2),
('12', 'Screwdriver', 1),
('13', 'Phillip screwdriver', 1),
('15', 'Long nose plier', 1),
('16', 'Combination Plier', 1),
('17', 'Adjustable Spanner', 1),
('18', 'Ring Spanner', 1),
('2', 'Glue Gun', 1),
('21', 'Digital multimeter', 1),
('22', 'Analogue multimeter', 1),
('25', 'Multi Extension', 1),
('26', 'Measuring Tape', 1),
('28', 'Semi-Circle File', 1),
('29', 'Triangle File', 1),
('3', 'Soldering Iron', 1),
('30', 'Square File', 1),
('31', 'Round File', 1),
('32', 'Flat File', 1),
('33', 'Bench Vice', 1),
('34', 'Multi-Adapter', 1),
('35', 'Hacksaw', 1),
('36', 'Hand Saw', 1),
('37', 'Metal Ruler', 1),
('39', 'Goggle', 1),
('4', 'Soldering stand & sp', 1),
('40', 'Battery Drill', 1),
('41', 'Electric Hand Drill', 1),
('42', 'Jig saw', 1),
('43', 'Hammer', 1),
('44', 'Mallet', 1),
('45', 'Drill bits', 1),
('46', 'Mallet', 1),
('5', 'Soldering Lead', 1),
('6', 'De-soldering pump', 1),
('60', 'OSC Probe', 1),
('64', 'BNC - BNC', 1),
('7', 'Wire stripper', 1),
('8', 'Wire cutter', 1);
I'm really confused how to work on the data-retrieval, as well as making it display in a table form..
Please help me..This is my assignment and I've been working on it for a week to get through it...