poruka koju dobijam:
Code:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/totalket/public_html/inc/home.php on line 5
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/totalket/public_html/inc/home.php on line 5
kod home.php stranice
Code:
<?
include 'config.php';
$sql = "SELECT * FROM info WHERE id = '16'";
$q=mysql_query($sql) or die;
while ($redak=mysql_fetch_array($q))
{
$naslov = $redak['naslov'];
$datum = $redak['datum'];
$tekst = $redak['tekst'];
$images = $redak['images'];
?>
<h1 class="h1" id="titleh1"><?=$naslov;?></h1>
<div id=textslika>
<p><img src=<?=$images;?>></p>
</div>
<p class=textvest><?=$tekst;?></p>
<?
}
?>
<?
include 'config.php';
$sql = "SELECT * FROM info WHERE id = '16'";
$q=mysql_query($sql) or die;
while ($redak=mysql_fetch_array($q))
{
$naslov = $redak['naslov'];
$datum = $redak['datum'];
$tekst = $redak['tekst'];
$images = $redak['images'];
?>
<h1 class="h1" id="titleh1"><?=$naslov;?></h1>
<div id=textslika>
<p><img src=<?=$images;?>></p>
</div>
<p class=textvest><?=$tekst;?></p>
<?
}
?>
config.php izgleda ovako
Code:
<?
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'baza';
if (!$dbh = mysql_connect($dbhost,$dbuser,$dbpass)) {
echo "Db Error";
exit;
}
mysql_select_db($dbname);
mysql_query("SET NAMES 'utf8'");
?>
<?
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'baza';
if (!$dbh = mysql_connect($dbhost,$dbuser,$dbpass)) {
echo "Db Error";
exit;
}
mysql_select_db($dbname);
mysql_query("SET NAMES 'utf8'");
?>
Probao sam i da izmacim ovaj dio koda koji bazu setuje za UTF8 medjutim i dalje ne radi i izbacuje mi istu gresku kao gore.
mysql - 5.0.91
php - 5.31
pozdrav
tesic
PROBLEM RIJESEN
da budem iskren, sramota me je da kazem u cemu je bio problem. useru nisam dao privilegije na bazu pa samim tim ni jedan upit nije mogao da se izvrsi.
izvinjavam se modernatorima i svim ostalim.
pozdrav
tesic
[Ovu poruku je menjao TeSiC dana 16.11.2010. u 18:08 GMT+1]