[SOLVED] Problem with includes from dbase in php script

dossie · August 17, 2009

Hi,

i'm busy with a site which shows information out of a dbase. No problem with making a connection to the dbase or getting the information from the dbase to the site but it goes wrong when i try to get the fields into an include. I want to break my page into different includes so I might be able to change text for all pages at once.

Does anybode know where I go wrong?

<?

include('../dbaseincludes/connectioninclude.php');

include('../dbaseincludes/doctypeinclude.php');

$query = 'SELECT * FROM affiliates WHERE id="4"';

if ($result = mysql_query($query)){

echo "";

}

else{

echo "Something went wrong, possibly you don't see all information";

exit;

}

while ($rij = mysql_fetch_array($result))

{

// this include doesn't work

include('../dbaseincludes/metainclude.php');

// this echo gives the good information but when I try to get it into an include it doesn't work

echo "{$rij['town']}";

// these things I need in 3 different includes

echo "<h4>{$rij['name']}</h4>";

echo "adress: {$rij['adress']}<br>";

echo "website: <a href={$rij['siteUrl']} target=_blank>{$rij['name']}</a>";

echo "<br><br>";

echo "<h4>Opinion</h4>";

echo "<a href={$rij['siteUrl']} target=_blank>Click here for opinions</a>";

echo "<br><br>";

echo "<h4>Is {$rij['name']} not what you're looking for?</h4>";

echo "<a href={$rij['more']}>Click here for more opinions</a>";

// this goes allright

include('../tip.php');

echo "</div>";

echo "";

include('../onderaan3.php');

echo "</div>";

echo "</body>";

echo "</html>";

}

?>

Thanks!

Arjen

dossie · August 17, 2009

And to be a little bit more specific:

Before I said:

// this include doesn't work

include('../dbaseincludes/metainclude.php');

..That's not totally correct, the include does work for the css, the divs and all the written content but not for the dbase fields.. The include looks like this:

</head>

<body>

</div>

ignace · August 17, 2009

First of all: add the while inside the if ($result ..) otherwise your while will execute even if your if failed. You can even extend to make sure there is something to loop over.

$result = mysql_query($query);
if ($result && mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
        ..
    }
}

Second:

$query = 'SELECT * FROM affiliates WHERE id="4"';

Implies your result will be one row which makes the while redundant:

$result = mysql_query($query);
if ($result && mysql_num_rows($result)) {
    $rij = mysql_fetch_assoc($result);
    
    // this include doesn't work
include('../dbaseincludes/metainclude.php');

// this echo gives the good information but when I try to get it into an include it doesn't work
echo "{$rij['town']}";

// these things I need in 3 different includes
echo "<h4>{$rij['name']}</h4>";
echo "adress: {$rij['adress']}<br>";
echo "website: <a href={$rij['siteUrl']} target=_blank>{$rij['name']}</a>";

echo "<br><br>";
echo "<h4>Opinion</h4>";
echo "<a href={$rij['siteUrl']} target=_blank>Click here for opinions</a>";
echo "<br><br>";

echo "<h4>Is {$rij['name']} not what you're looking for?</h4>";         
echo "<a href={$rij['more']}>Click here for more opinions</a>";           

// this goes allright
include('../tip.php');         
echo "</div>";         
echo "<!-- end #welcome -->";   
include('../onderaan3.php');   
echo "</div>";         
echo "</body>";           
echo "</html>";
}

P.S. Groeten vanuit België

Sign In

[SOLVED] Problem with includes from dbase in php script

Recommended Posts

dossie

Link to comment

Share on other sites

dossie

Link to comment

Share on other sites

ignace

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information