Newbie Help...

[Anon]

Hi,

I'm using PHP-Nuke 5.0 beta and am trying to write a function to replace the code "<!--acrobat-->" with some HTML, stored in the mySQL database.

The function I have so far is:

function replace_acrobat($content) {
$result = mysql_query("select html from includes where inclid = '0'");
$html = mysql_fetch_array($result);

$content = str_replace("<!--acrobat-->", $html, $content);

return($content);

}

However, when it runs, the function returns "Array", not the contents of the HTML field in the database.

My apologies for the newbie-ness of this question, and my thanks in advance for any help!

--Chris Johnson
[e-mail]

[Anon]

pop this under your $html = mysql_fetch..

$html = $html['html'];

[craigh]

that's because $html is an array. You probably are expecting only one value to be present at 'inclid' but mysql_fetch_array returns an array nonetheless. So - find a way to make it a regular variable.

[Anon]

Hmm... I tried that out, it caused the script to not function correctly (the article never appears in the mySQL database)

Anything else I'm doing wrong?

[Anon]

To turn an array from a database do something like what I did for my news script...

$query = "SELECT * FROM news ORDER BY news_date";
$result = @($query,$dbcon) or die("Couldn't execute query");

while ($row = mysql_fetch_array($result))
{
$news_id = $row['news_id'];
$news_poster = $row['news_poster'];
$news_poster_email = $row['news_poster_email'];
$news_date = $row['news_date'];
$news_title = $row['news_title'];
$news_body = $row['news_body'];
$news_source = $row['news_source'];
$news_source_url = $row['news_source_url'];

Now you can simply call $news_id when needed without messing with an array.