Categories and Contents

Sonic_Rage

I'm trying to create a page that has a listing of video clips to be downloaded. I have made a table that holds all of the video clips names, size, length, etc... Problem for me is that I want to group them in catergories. Would making a table of catergory names be the way to go? and then try to place the catergory number in each row of the videos table? and I guess the main issue is I am unsure how to script it to show up on the page. I know how to lookup info in each table, just not sure how to format it to show a catetgory with the correct links and info under each one.

😕

rIkLuNd

This is how you could do:

First you must add a column in your download table were you can write the category that the clip belongs to. Then you could use a code like this one:

<?php

$host = "localhost";
$user = "user";
$pass = "pass";

$db = "db";

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

$sel = mysql_select_db($db);
if(!$sel)
die(mysql_error());

$get = mysql_query("SELECT * FROM movie_clips WHERE category='$cat'");
if(!$get)
die(mysql_error());

// Now let's print the clips
// These values must be changed to the one in your table!
while($row = mysql_fetch_array($get))
{
print "Name: $row[movie_name]<br>\n";
print "Size: $row[movie_size]<br>\n";
print "Length: $row[movie_length]<br>\n";
// Etc.
}

$close = mysql_close($link);

?>

You can then access each category by pointing the browser to it like this:

http://www.yourdomain.com/index.php?cat=action

Hope this will help you!

Sonic_Rage

That is very helpful, thank you. So my understanding is that I would be doing my string query to look for the cat id and then display all of the links with that cat id, correct?

So if I wanted to make a name for each catergory, I would then link it somehow to a table containing the categories, their id, and their title. Then I would put the cat id in the videos table.

Do I have to change the string query then to look for the cat id and name and then also match it with the videos cat id?? Um, am I making sense? or doing it backward?

Thanks for your help ^_

rIkLuNd

What you have to do is just to add a column in your table, and the name of the column should be 'category' (or what you want). This is an example code of the structure of "your" table:

CREATE TABLE clips(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
category VARCHAR(50) NOT NULL,
movie_name VARCHAR(30) NOT NULL,
movie_size VARCHAR(20) NOT NULL,
movie_length VARCHAR(20) NOT NULL
);

Then maybe you have a few clips, that belongs to the action category, and then you access them by pointing your browser to, for example movies.php?cat=action

Understand?

Sonic_Rage

Ok, I'll try that out and see how it works. Thanks for your help. 😃