gwolf2u

this is my first post here as you might think, I'm new to mysql well now related to my question I have a database created and I want that for each row to output some data in my php page in short my table is named info and has two columns, name and image now I want for each name to output something like this <a href="page/{name}"><img src="images/{image}.jpg" onMouseOver="this.src='images/over.png';" onMouseOut="this.src='images/{image}.jpg';"></a> my mysql database looks like this CREATE TABLE IF NOT EXISTS `info` ( `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'game name', `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'image name', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO `info` (`name`, `image`) VALUES ('Name 1', 'image1'), ('Name 2', 'image2'), ('Name 3', 'image3'); now any ideas how can I do this again I'm new to this so no genius here