PS: статья по настройке PHP Development Tools: http://fractalizer.wordpress.com/2007/1 … lipse-pdt/
Официальная страница в переводе Google: http://translate.google.ru/translate?hl … e.org/pdt/
SELECT title,meta_d,meta_k,text FROM settings WHERE page='contacts.php'может у Вас нет данных в таблице в поле text. проверьте данные на наличие и соотвествие вашему отбору
WHERE page='contacts.php'PS и в строке <title>О нас</title> пропустили вставку.
]]><?php
include ("blocks/bd.php");
mysql_query("SET NAMES cp1251");
$result = mysql_query("SELECT title,meta_d,meta_k,text FROM settings WHERE page='contacts.php'",$db);
$myrow = mysql_fetch_array($result);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta name="description" content="<?php echo $myrow['meta_d']; ?> ">
<meta name="keywords" content="<?php echo $myrow['meta_k']; ?> ">
<meta http-equiv="content-type" content="text/html; charset=windows-1251" />
<meta name="author" content="admin" />
<title>О нас</title>
<link href="add1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="690" border="5" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<?php
include("blocks/header.php"); ?>
<tr>
<td><table width="690" border="5" cellspacing="0" cellpadding="0"></td>
<tr>
<?php
include ("blocks/lefttd.php"); ?>
<td valign="top">
<?php echo $myrow['text']; ?>
</td>
</tr>
</table></td>
</tr>
<?php
include ("blocks/footer.php"); ?>
</table>
</body>
</html>
а вывод написать переменных в нужных Вам местах, по аналогии как Вы написали в первой странице забыли
<?php echo $myrow['title']; ?>
<?php echo $myrow['meta_d']; ?>
<?php echo $myrow['meta_k']; ?>
<?php echo $myrow['text']; ?>и т д.
]]><head>
<meta http-equiv="content-type" content="text/html; charset=windows-1251" />
<meta name="author" content="admin" />
<title>О нас</title>
<link href="add1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="690" border="5" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<?php
include("blocks/header.php"); ?>
<tr>
<td><table width="690" border="5" cellspacing="0" cellpadding="0"></td>
<tr>
<?php
include ("blocks/lefttd.php"); ?>
<td>
</td>
</tr>
</table></td>
</tr>
<?php
include ("blocks/footer.php"); ?>
</table>
</body>
</html>
----------------------------------------------------------------------------------------------------
<?php
include ("blocks/bd.php");
mysql_query("SET NAMES cp1251");
$result = mysql_query("SELECT title,meta_d,meta_k,text FROM settings WHERE page='lessons'",$db);
$myrow = mysql_fetch_array($result);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1251" />
<meta name="author" content="admin" />
<title>Уроки</title>
<link href="add1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="690" border="5" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<?php
include("blocks/header.php"); ?>
<tr>
<td><table width="690" border="5" cellspacing="0" cellpadding="0"></td>
<tr>
<?php
include ("blocks/lefttd.php"); ?>
<td>
</td>
</tr>
</table></td>
</tr>
<?php
include ("blocks/footer.php"); ?>
</table>
</body>
</html>
------------------------------------------------------------------------------------------------------------------
<?php
include ("blocks/bd.php");
$result = mysql_query("SELECT title,meta_d,meta_k,text FROM settings WHERE page='Articles'",$db);
$myrow = mysql_fetch_array($result);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1251" />
<meta name="author" content="admin" />
<title>Статьи</title>
<link href="add1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="690" border="5" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<?php
include("blocks/header.php"); ?>
<tr>
<td><table width="690" border="5" cellspacing="0" cellpadding="0"></td>
<tr>
<?php
include ("blocks/lefttd.php"); ?>
<td>Статьи
</td>
</tr>
</table></td>
</tr>
<?php
include ("blocks/footer.php"); ?>
</table>
</body>
</html>
Спасибо большое получилось,но текст вывелся только на 1 странице.Не понятно почему не выводятся остальные?
А как выглядят другие страницы?
]]>Исходный код:<?php
include ("blocks/bd.php");
$result = mysql_query("SELECT title,meta_d,meta_k,text FROM settings WHERE page='index'".$db);(если я добавляю в эту строку or die(mysql_error()) то пишет такую ошибку:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #4' at line 1)
$myrow = mysql_fetch_array($result);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta name="description" content="<?php echo $myrow['meta_d']; ?> ">
<meta name="keywords" content="<?php echo $myrow['meta_k']; ?> ">
<meta http-equiv="content-type" content="text/html; charset=windows-1251" />
<meta name="author" content="admin" />
<title><?php echo $myrow['title']; ?></title>
<link href="add1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="690" border="5" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<?php
include("blocks/header.php"); ?>
<tr>
<td><table width="690" border="5" cellspacing="0" cellpadding="0"></td>
<tr>
<?php
include ("blocks/lefttd.php"); ?>
<td valign="top">
<?php echo $myrow['text']; ?>
</td>
</tr>
</table></td>
</tr>
<?php
include ("blocks/footer.php"); ?>
</table>
</body>
</html>