Database Newbie needs assistance

[Digital-86]

ok this code below seems pretty simple but like I said I am totally new to this as far as DB goes.

This is code for a table now I want instead of the words below Movies, Anime etc I want to have images instead so instead of it saying Movie it will have a picture of a movie reel or something.

It is prob simple or I might be going about it wrong let me know thanks for your input.

--------------------------------------------------------

#

Table structure for table categories

#

CREATE TABLE categories (
id int(10) unsigned NOT NULL auto_increment,
name varchar(30) NOT NULL default '',
sort_index int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

#

Dumping data for table categories

#

INSERT INTO categories VALUES (1, 'Movies', 10);
INSERT INTO categories VALUES (2, 'Music', 20);
INSERT INTO categories VALUES (3, 'TV', 30);
INSERT INTO categories VALUES (4, 'Games', 40);
INSERT INTO categories VALUES (5, 'Apps', 50);
INSERT INTO categories VALUES (6, 'Misc.', 60);
INSERT INTO categories VALUES (8, 'Pictures', 80);
INSERT INTO categories VALUES (9, 'Anime', 90);
INSERT INTO categories VALUES (10, 'Comics', 100);
INSERT INTO categories VALUES (11, 'Books', 110);
INSERT INTO categories VALUES (13, 'Music Vid.', 120);

--------------------------------------------------------

[drawmack]

add a column yo to your database table to create this

CREATE TABLE categories ( 
    id int(10) unsigned NOT NULL auto_increment, 
    name varchar(30) NOT NULL default '', 
    img_path varchar(100 NOT NULL default 'no_image.jpg',
    sort_index int(10) unsigned NOT NULL default '0', 
    PRIMARY KEY (id),
   INDES sort_index (sort_index)
) TYPE=MyISAM;

For information on changing a table's structure see [url]htttp://www.mysql.com/alter table[/url]

The your inserts will look like this

INSERT INTO categories VALUES (1, 'Movies', 'images/movies.jpg',10); 
INSERT INTO categories VALUES (2, 'Music', 'images/music.jpg',20); 

Now when you're retrieving the data do something like this

$sql = "SELECT * FROM categories ORDER BY sort_index";
$query = mysql_query($sql);
while(($row = mysql_fetch_object($query) !== FALSE) {
    echo '<img src="' . $row->img_path . '" alt="' . $row->name . '" /><br />';