Fetch Categories with Get method

[eugene2009]

Lets start with this code..

 

CREATE TABLE category(
category_id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
parent INT DEFAULT NULL);

INSERT INTO category
VALUES(1,'ELECTRONICS',NULL),(2,'TELEVISIONS',1),(3,'TUBE',2),
(4,'LCD',2),(5,'PLASMA',2),(6,'PORTABLE ELECTRONICS',1),
(7,'MP3 PLAYERS',6),(8,'FLASH',7),
(9,'CD PLAYERS',6),(10,'2 WAY RADIOS',6);

SELECT * FROM category ORDER BY category_id;

 

So look.. i create this table.. but how do I actually create more inputs for items under that category for prices, and other information.. How will I be able to have a page named categories.php and have it list only the categories linked with the get method going to the products in each category.. somebody please help..

 

[Cardale]

Sounds like you need to learn the basic of connecting to a database and using select and insert queries.  Google that stuff and you will be well on your way.

[eugene2009]

i know how to connect to the database.. i got this..

 

$query = "SELECT * FROM comments ORDER BY tutorialid"; //get the customer list
$result = mysql_query($query); //perform the query

//display the customer list
$array = array();
while($row = mysql_fetch_array($result)){
     $array[] = $row;
}
$midPoint = ceil(count($array) / 2);
echo "<table border=\"1\">";
for($i = 0; $i < $midPoint; $i++){



echo "<tr>";

echo '<td><a href="category.php?tutorialid='.$array[$i]['tutorialid'].'">'.$array[$i]['tutorialid'].'</a>';

echo "</td>";


if (isset($array[$i + $midPoint]))


echo '<td><a href="category.php?tutorialid='.$array[$i+$midPoint]['tutorialid'].'">'.$array[$i+$midPoint]['tutorialid'].'</a></td';

echo "</td>";

echo "</tr>";
}

 

My problem is it displays the same category over and over.. i want it to display it only once.. thats where im stuck at..