how would i set out the sql for a categories table???

Hello.
i want to make a categories table in my data base.
what would i include in the sql??
Thanks

 

need more info are you a coder? what script?

 

i am a coder but im very new to php, msql .

and i have a website about motorbikes, and i want to have articles put into categories. so i need to make the categories into the data base.

and if you know how to make pages into those categories that would be awesome

Thanks Kurt

 

first put categories in table
then use query to get the results

SELECT * from categories_table;

PHP:

* means every thing
now on inner pages use as you wish
like

SELECT * from cat_table WHERE cat_id='1';

PHP:

use this on page where you want to get cat ID 1

 

would that then make the pages in the categories??

 

NO
make categories in pages
some thing like

<?php
<header>
<aditional stylings>SELECT * from cat_table WHERE cat_id='catID';
<footer>
?>

PHP:

 

I am fresh php fresh developer i don't know how to do this
Thanks