Meltdown

Can I call the page with an include: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(70, 'contact', 4, NULL, '<?php { include("contact.php");} ?>', 'NULL', 'text'); This particular code doesn't work but at least it isn't throwing an error when I update the database.

Here is the error I recieve when updating my database: Thanks

My new contact link is added but the specific page content for that page is not showing (It should be contact form). I see that other individual page content was added into the database directly, as shown below: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(11, 'links', 1, NULL, '<p> </p>\r\n<h3 style="text-align: left">AskART The artists Bluebook</h3>\r\n<p style="text-align: left"><a href="[url="http://www.test.com%22%3ehttp//www.test.com%3C/a%3E%3C/p%3E/r/n%3Cp%3E %3C/p%3E"]http://www.test.com">http://www.test.com</a></p>\r\n<p> </p>'[/url], NULL, 'text'); But I am unsuccessful I attempt to do the same with the contents of my contact page: INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'contact', 1, NULL, '<p><div align="center"><table border="0" width="480"><tr><td> <font face="Verdana" size="2"><form enctype='multipart/form-data' action='http://www.test.com/contact/forms/process.php' method='post'><div align="center"><h2 align="center"><em>Contact</em></h2><table border="0" cellspacing="1" style="border-collapse: collapse" width="45%" cellpadding="5"><tr><td colspan="3" height="16" width="100%"><font size="2" face="Verdana"><font face="Verdana" size="2" color="#000000"><!- You can add a brief form description here-->Commissions are welcome upon request, for further information please e-mail the Artist. <p> </p></font></b></font></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Name</td><td height="30" width="469"><font face="Verdana"><input type=text name='Name'></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Email</td><td height="30" width="469"><font face="Verdana"><input type=text name='Email'></td></tr><tr><td height="30" width="55"></td><td height="30" width="189"><font face="Verdana" size="2">Message</td><td height="30" width="469" ><font face="Verdana"><textarea name='Message' rows=5 cols=35></textarea></td></tr><tr><td colspan="3" height="25" width="537"><p align="center"><font face="Verdana" size="2"><input type=submit value='Submit Form'> <input type=reset value='Reset Form'></font></td></tr></table><p align="center"> </p><p align="center"> </p></div></form></font></td></tr></table></p>', 'NULL', 'text'); Any thoughts? Thank you!

OK, it looks like I've got that worked out.

I've finished updating the home page and creating the contents of the Contact Us page. However, I'm stumped as to how to add the new Contact Us link to the navagation bar. below is the database contents. I assume that the new link must be added here as well as to the index.php page. How would I go about that? -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] -- -- Host: 62.149.150.67 -- Generation Time: Jun 03, 2010 at 05:17 PM -- Server version: 5.0.82 -- PHP Version: 5.2.13 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `Sql165002003_1` -- -- -------------------------------------------------------- -- -- Table structure for table `accesso` -- CREATE TABLE IF NOT EXISTS `accesso` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(20) NOT NULL default '', `password` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `token` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `session` varchar(32) character set latin1 collate latin1_bin NOT NULL default '', `ip` varchar(15) character set latin1 collate latin1_bin NOT NULL default '', `level` int(2) NOT NULL default '0', PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `accesso` -- INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(1, 'guidoeffe', '06f074501e8aefaae85df98f42629b2e', '7d61464a0151b5a216ec3b1ae3278b83', '3631a5210845839ae70b461e8d7882b8', '159.213.32.228', 1); INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(2, 'oliviars', '0b16d2ffa469a9e7d06ce4033eafa5dc', '7bf936bafc2bf85671d13fa8bf1e0ab3', 'fdc6e3dba56a286bdecc00ca33233026', '151.49.47.233', 0); INSERT INTO `accesso` (`uid`, `username`, `password`, `token`, `session`, `ip`, `level`) VALUES(3, 'eusebio', '0b16d2ffa469a9e7d06ce4033eafa5dc', 'd0d3b63061edeb714557ba2ffdcb2f0a', '992b35ab052e5a3ac820c9b34b9d00d8', '79.23.122.33', 0); -- -------------------------------------------------------- -- -- Table structure for table `images` -- CREATE TABLE IF NOT EXISTS `images` ( `id_image` int(9) NOT NULL auto_increment, `section` varchar(100) collate utf8_unicode_ci NOT NULL, `file` varchar(255) collate utf8_unicode_ci NOT NULL, `type` varchar(100) collate utf8_unicode_ci NOT NULL default 'portrait', `title` varchar(100) collate utf8_unicode_ci NOT NULL, `description` varchar(255) collate utf8_unicode_ci default NULL, `sold` varchar(50) collate utf8_unicode_ci default NULL, `dimension` varchar(100) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id_image`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=140 ; -- -- Dumping data for table `images` -- INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(1, 'all', '', 'portrait', 'Empty frame', NULL, '', NULL); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(2, 'all', '', 'landscape', 'Empty frame', NULL, '', NULL); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(42, 'landscapes', '42_RADDAINCHIANTI60X50cm.jpg', 'landscape', 'Radda in chianti', 'Oil on Linen', 'sold', '60 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(64, 'still-life', '64_40x50.jpg', 'portrait', 'Myrna', 'Oil on Linen', 'sold', '40 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(86, 'landscapes', '86_drive.jpg', 'portrait', 'A drive through Tuscany', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(54, 'portraits', '54_ALESSIAINSARDINIA90X70cm.jpg', 'landscape', 'Alessia in Sardinia', 'Oil on Linen', NULL, '90 x 70 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(48, 'portraits', '48_SILVESTRO70X90cm.jpg', 'portrait', 'Silvestro', 'Oil on Linen', NULL, '70 X 90 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(49, 'portraits', '49_JOSEPH50X60cm.jpg', 'portrait', 'Joseph ', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(57, 'still-life', '57_CERAMICVASEWITHONIONSANDEGG50X40cm.jpg', 'landscape', 'Ceramic vase with onions and egg', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(56, 'still-life', '56_BOOKKEYANDCLAYVASE40X50cm.jpg', 'portrait', 'Book, key and clay vase', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(94, 'landscapes', '94_DSC01028copia.jpg', 'landscape', 'Chianti Sangiovese', 'Oil on Linen', NULL, '80 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(59, 'still-life', '59_CABBAGE,LEEKSANDPEPPERONI50X40cm.jpg', 'landscape', 'Cabbage, leeks, and pepperoni', 'Oil on Linen', NULL, '50 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(60, 'still-life', '60_OILWITHPEPERONCINO50X35cm.jpg', 'landscape', 'Oil with peperoncino', 'Oil on Linen', NULL, '50 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(39, 'portraits', '39_ALESSIA90X120cm.jpg', 'portrait', 'Alessia', 'Oil on Linen', NULL, '90 x 120 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(110, 'still-life', '110_DSC01037copia.jpg', 'portrait', 'Copper pitcher with rosemary and orange 40 x 60 cm oil on linen', 'Oil on Linen', NULL, '40 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(61, 'still-life', '61_JAPANESETEAPOT40X30cm.jpg', 'landscape', 'Japanese tea pot', 'Oil on Linen', NULL, '40 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(62, 'portraits', '62_DSC_7286.jpg', 'portrait', 'Marco', 'Oil on Linen', NULL, '60 x 100 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(63, 'landscapes', '63_DSC_7292.jpg', 'landscape', 'Tuscan countryside', 'Oil on Linen', NULL, '60 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(65, 'still-life', '65_DSC_7290.jpg', 'portrait', 'Carnival in Venice', 'Oil on Linen', NULL, '50 X 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(66, 'still-life', '66_DSC_7293.jpg', 'landscape', 'Bronze pot and Lemons', 'Oil on Linen', NULL, '60 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(67, 'still-life', '67_DSC_8401.jpg', 'landscape', 'Gubbio', '60 X 40 cm', 'sold', 'Oil on Linen'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(81, 'portraits', '81_stefania.jpg', 'portrait', 'Stefania', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(84, 'landscapes', '84_sanMichele.jpg', 'landscape', 'Monte San Michele', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(80, 'portraits', '80_nestor.jpg', 'portrait', 'Nestor', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(82, 'portraits', '82_giuseppe.jpg', 'portrait', 'Joseph 2008', 'Oil on Linen', NULL, '60 x 100 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(83, 'portraits', '83_roni.jpg', 'portrait', 'Roni', 'Oil on Linen', NULL, '60 x 80 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(85, 'landscapes', '85_fields.jpg', 'portrait', 'Fields of Tuscany', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(87, 'landscapes', '87_balena.jpg', 'landscape', 'Humpback Whale journey to Maui', 'Oil on Linen', NULL, '100 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(88, 'still-life', '88_porcini.jpg', 'landscape', 'Porcini ', 'Oil on Linen', NULL, '20 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(89, 'still-life', '89_japan.jpg', 'landscape', 'Antique Japanese Tea Pot', 'Oil on Linen', NULL, '30 x 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(90, 'still-life', '90_olive.jpg', 'portrait', 'Wine and Olives', 'Oil on Linen', NULL, '20 x 30 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(91, 'still-life', '91_copper.jpg', 'portrait', 'Copper Tea Pot With Red Onions', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(92, 'landscapes', '92_campo.jpg', 'portrait', 'Countryside', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(100, 'still-life', '100_BEETROOTSANDAPPLES40X50cmcopia.jpg', 'landscape', 'Beetroots and apples', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(130, 'portraits', '130_DSC01486.jpg', 'portrait', 'Giuseppe', 'CHARCOAL ON PAPER', NULL, '40 X 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(131, 'still-life', '131_DSC01488.jpg', 'portrait', 'Orchid', 'Oil on Linen', NULL, '50 x60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(97, 'still-life', '97_DSC01037copia.jpg', 'portrait', 'Copper pitcher with rosemary and orange', 'Oil on Linen', NULL, '40 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(134, 'portraits', '134_DSC01517copia.jpg', 'portrait', 'Victoria', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(101, 'still-life', '101_FRUITSANDSILVERMUG25X35cmcopia.jpg', 'landscape', 'Fruits and silver mug', 'Oil on Linen', NULL, '25 x 35 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(132, 'still-life', '132_DSC01493.jpg', 'portrait', 'Old Vase with fruits', 'Oil on Linen', NULL, '30 X 40 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(133, 'portraits', '133_DSC01516copia.jpg', 'portrait', 'Emily', 'Oil on Linen', NULL, '50 x 60 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(106, 'landscapes', '106_BALLEDIFIENO60X90cmcopia.jpg', 'landscape', 'Balle di Fieno', 'Oil on Linen', NULL, '60 x 90cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(107, 'still-life', '107_DSC01050copia.jpg', 'landscape', 'Old bean pot', 'Oil on Linen', NULL, '40 x 50 cm'); INSERT INTO `images` (`id_image`, `section`, `file`, `type`, `title`, `description`, `sold`, `dimension`) VALUES(108, 'still-life', '108_ITALIANBREAKFAST40X60cmcopia.jpg', 'landscape', 'Italian Breakfast', 'Oil on Linen', NULL, '40 x 60 cm'); -- -------------------------------------------------------- -- -- Table structure for table `link` -- CREATE TABLE IF NOT EXISTS `link` ( `codice` int(11) NOT NULL auto_increment, `descrizione` varchar(250) default NULL, `url` varchar(250) default NULL, `target` varchar(10) NOT NULL default '_self', `ordine` int(11) default NULL, KEY `codice` (`codice`), KEY `ordine` (`ordine`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Link' AUTO_INCREMENT=26 ; -- -- Dumping data for table `link` -- INSERT INTO `link` (`codice`, `descrizione`, `url`, `target`, `ordine`) VALUES(23, 'Web/Project Coordination', 'http://www.jmiltongroup.com', '_blank', NULL); INSERT INTO `link` (`codice`, `descrizione`, `url`, `target`, `ordine`) VALUES(19, 'Forence Gospel Choir School', 'http://www.fgcschool.com', '_blank', 1); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE IF NOT EXISTS `pages` ( `id_page` int(9) NOT NULL auto_increment, `section` varchar(100) collate utf8_unicode_ci NOT NULL, `number` int(3) NOT NULL default '1', `images` varchar(255) collate utf8_unicode_ci default NULL, `text` text collate utf8_unicode_ci NOT NULL, `message` varchar(255) collate utf8_unicode_ci default [email=""]'test@test.com'[/email], `structure` varchar(100) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id_page`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(50, 'still-life', 2, '66;64;67;90', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(51, 'landscapes', 3, '63;1;87;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(33, 'portraits', 2, '49;80;39;54;83', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(37, 'landscapes', 1, '94;86;106;85', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(11, 'links', 1, NULL, '<p> </p>\r\n<h3 style="text-align: left">AskART The artists Bluebook</h3>\r\n<p style="text-align: left"><a href="[url="http://www.aart.com"]http://www.aart.com[/url] \r\n '">http://www.aart.com">http://www.aart.com</a></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(38, 'still-life', 1, '108;131;101;132', '', NULL, 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(64, 'still-life', 4, '59;65;57;97', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(49, 'landscapes', 2, '42;92;84;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(53, 'bio', 1, NULL, '<p><font size="3"><font face="Times New Roman"><font color="#000000"> <img border="0" hspace="10" alt="" vspace="1" align="left" width="128" height="161" src="/img/img_text/b 50x60(5).jpg" /></font></font></font></p>\r\n<p>Olivia Santiago <b>was born and raised in Kahuku</b>, on the island of Oahu, Hawaii. She attended the University of Hawaii, at Windward, Kaneohe. For 2 years, she studied under artist professor <b>Snowden Hodges </b>who specializes in painting and drawing of the old masters, such as <i>Peter Paul Rubens</i>.</p>\r\n<p> </p>\r\n<p>Shortly after, Olivia furthered her <b>studies in Florence</b>, Italy attending <i>Charles Cecil Studio</i>, there she continued training in naturalistic tradition drawing and painting which dates back to <i>Titian</i>, <i>Van Dyck </i>and <i>Velàzques</i>, after which she remained in Florence and studied privately on her own for 3 years.</p>\r\n<p><o:p> </o:p></p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal">In 2004 she entered <b>Atelier Rebecca Harp in Florence</b>, Italy. Rebecca is an artist and teacher who structures her work in tradition of the old masters.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal">Thanks to Rebecca’s cunning guidance, Olivia became more aware of the importance to communicate visually. </p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"> </p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><b>She currently paints</b> in her studio.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><o:p> </o:p></p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><b>Olivia resides</b> in Florence with her husband and still profoundly inspired by the Masters of Art.</p>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"> </p>\r\n<h4><b>For informations about prices and commissions please contact the artist</b></h4>\r\n<p style="margin: 0cm 0cm 0pt" class="MsoNormal"><span lang="EN-GB"><font size="3"><font color="#000000"><font face="Times New Roman"><o:p></o:p></font></font></font></span></p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(68, 'events', 1, NULL, '<p><img width="460" height="325" alt="" src="/img/img_text/image/art%20poster.jpg" /></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(54, 'still-life', 3, '107;56;61;91', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(69, 'events', 1, NULL, '<p><img height="308" width="220" alt="" src="/img/img_text/image/_FIL2884xxx%20copia.jpg" /></p>\r\n<p> </p>', NULL, 'text'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(66, 'still-life', 5, '89;1;60;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(67, 'still-life', 6, '2;1;2;1', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'portraits', 1, '82;134;81;62;133;48', '', "[email="test@test.com"]test@test.com[/email]", 'gallery'); INSERT INTO `pages` (`id_page`, `section`, `number`, `images`, `text`, `message`, `structure`) VALUES(63, 'contact', 1, NULL, '', "[email="test@test.com"]test@test.com[/email]", 'text');</P> Thank you!!

Hmmm... I can see the nav bar in the html of the home page but it is not actually showing up on the page itself. Could there be an if or elseif statement that is blocking the nav bar from appearing on the home page? If one of you gets a moment, could you please take a look at the index.php page I posted (post #6 in this thread) to see if that may be the case? Thanks!

If you look at the index.php that I posted earlier (post #6 in this thread) you'll see that the navigation links (Home, Portrait etc.) are listed twice. Is there a logical reason for this? I would like to reproduce the same navigation bar found on all other site pages on the index page, as well. How would I go about that? Thanks!

I'm in...! I'll dig around a bit and bother you later with annoying questions I appreciate the effort - I've always meant to install Xampp. It's good tohave it in place, no matter what the outcome of this project.

OK, that did it - Thanks! Should I enable intranet settings on my localhost browser? Hmmm... I'm still having trouble accessing the home page on my localhost. Would the passwords still be the same or should I remove/change them?

Sorry to be such a pain, Pat - I keep getting an error on import. It could be my connection details. Is the only change I'm going to make to the connection details that the hostname is "localhost"? [b]Error[/b] [b]SQL query:[/b] -- -- Database: `Sql160004_1` -- -- -------------------------------------------------------- -- -- Table structure for table `accesso` -- CREATE TABLE IF NOT EXISTS `accesso` ( `uid` int( 11 ) NOT NULL AUTO_INCREMENT , `username` varchar( 20 ) NOT NULL default '', `password` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `token` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `session` varchar( 32 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `ip` varchar( 15 ) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL default '', `level` int( 2 ) NOT NULL default '0', PRIMARY KEY ( `uid` ) , UNIQUE KEY `username` ( `username` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; [b]MySQL said: [/b][url="http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html"][img=./themes/original/img/b_help.png][/url] #1046 - No database selected

Import it using xampp/MySql/admin/import? And you said a text file - Not a sql file?

Thanks for that. I have successfully installed Xampp and have access to localhost. How exactly can I use it in this instance? Should I copy the entire site to xampp/htdocs? Hmmm... I copied my index.php (deleting the xampp index.php & index.html) to htdocs and am getting the dreaded "Trojan Horse" message from Avast again, plus the following error: [b]Warning[/b]: require_once(../Connections/santiago_ado.php) [[url="http://localhost/function.require-once"]function.require-once[/url]]: failed to open stream: No such file or directory in [b]C:\xampp\htdocs\index.php[/b] on line [b]5[/b] [b]Fatal error[/b]: require_once() [[url="http://localhost/function.require"]function.require[/url]]: Failed opening required '../Connections/santiago_ado.php' (include_path='.;C:\xampp\php\PEAR') in [b]C:\xampp\htdocs\index.php[/b] on line [b]5[/b] Thanks

Is it possible to create a simple test environment where I can make page modifications without affecting the existing site?

And what about this idea to avoid trying to build a page using php: Right now the index.php is the default page. If I put in an index.htm it becomes the default. Couldn't I create my html home page, upload it as index.htm and then just update the links within the database to point to it rather than the php page? Sorry if this is inane...

Thanks Pat, this really is quite generous of you. My php experience is limited to working with existing php structures, such as Zen Cart. Since I have been building Zen Carts commercially for some time, I have logged a good number of hours within that environment but unfortunately I've generally avoided database work like the plague. I'll go and take a good look around and see if I can get my head around it. A question: Where do you do the database work? Within the database itself or in a notepad editor that is then copied and pasted...? Another question; If I "view source" on the home page I see a basic html page but none of the php that makes up the site. Does this mean that I will be able to create my html page using my regular tools and then plug it in to the php of the index.php? If so, any idea why my last attempt at doing so generated a "Trojan Horse" warning? Thanks