PDA

View Full Version : سوال: مشکل در خواندن از دیتابیس



dev_ti
چهارشنبه 12 بهمن 1390, 15:57 عصر
سلام
این کد صفحه من هستش :‌


<?php
function headtag($pageid)
{
require ('config.php');
$db =db_connect();
if(!$db)
{
echo "Connect nashod be database";
exit;
}
mysql_query('SET NAMES UTF8');
$query=mysql_query('SELECT * from pagedata WHERE id=$pageid');
$field=mysql_fetch_array($query);
$query2=mysql_query('select sitename from sitesetting where id=1');
$title=mysql_fetch_array($query2);
mysql_close($db);
?>
<title>
<?php echo $title['sitename'] . '|'.$field['title']; ?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $field['charset'];?>" />
<meta name="Keywords" content="<?php echo $field['keyword']; ?>" />
<meta name="Description" content="<?php echo $field['description']; ?>" />
<?php }
function make_header($id)
{

require ('config.php');
$db =db_connect();
if(!$db)
{
echo "Connect nashod be database";
exit;
}
mysql_query('SET NAMES UTF8');
$query=mysql_query('select lang from sitesetting where id=1');
$field=mysql_fetch_array($query);
mysql_close($db);
?>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $field['lang']; ?>">
<head>
<?php headtag($id); ?>
<link type="text/css" rel="stylesheet" href="./css/all.css"/>
<link type="text/css" rel="stylesheet" href="./css/form.css"/>
<link type="text/css" rel="stylesheet" href="./css/lightbox.css"/>
<script type="text/javascript" src="./js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="./js/slideblock.js"></script>
<script type="text/javascript" src="./js/latte.js"></script>
<script type="text/javascript" src="./js/prototype.js"></script>
<script type="text/javascript" src="./js/scriptaculous_b2918e73.js"></script>
<script type="text/javascript" src="./js/lightbox.js"></script>
<script type="text/javascript" src="./js/jquery.roundabout.min.js"></script>
<script type="text/javascript" src="./js/ddsmoothmenu.js"></script>
<script type="text/javascript" src="./js/loader.js"></script>
<script type="text/javascript" src="./js/cufon.js"></script>
<script type="text/javascript" src="./js/cufon-fonts.js"></script>
<script type="text/javascript" src="./js/cufon-settings.js"></script>
<script type="text/javascript" src="./js/input.js"></script>
<script type="text/javascript" src="./js/main.js"></script>
<!--[if lt IE 8]><link rel="stylesheet" href="http://mhtml.ru/2010-12/synoptic/colors/amethyst/css/ie.css" type="text/css" /><![endif]-->
</head>
<?php }
function topMenuBar($id)
{

?>

<?php
}
?>


ولی در این قسمت :‌


$field=mysql_fetch_array($query);

این ارور رو میگیرم :‌
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/final/include/functions.php on line 13
ممنون میشم اگه راهنماییم کنید ..

Reza1607
چهارشنبه 12 بهمن 1390, 18:06 عصر
این قسمت رو

$query=mysql_query('SELECT * from pagedata WHERE id=$pageid');
به این صورت تغییر بدین

$query=mysql_query('SELECT * from pagedata WHERE id='.$pageid);